一些有用的SQL

来源:互联网 发布:卓讯外贸数据 编辑:程序博客网 时间:2024/05/16 06:27

1. 查询存储过程列表

select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsProcedure') = 1 and type= 'P' and name like 'sp%' order by name asc

(select * from  sys.objects where type= 'P' and name like 'sp%' order by name)