SQL SERVER , 一些sql语句记录

1.Group by 分组分页

    SELECT * FROM 
    ( 
   SELECT ROW_NUMBER() OVER 
   (order by T.LXMC desc)AS Row, * from (select LXMC,count(LXMC) as SL from  TableName  WHERE 1=1 group by LXMC ) T
   ) 
   TT
   WHERE TT.Row between 1 and 20

2、查询一个表的所有列名，字段的注释

  SELECT
A.name AS table_name,
B.name AS column_name,
C.value AS column_description
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE A.name = 'Sys_User'

sql server 查询某个表被哪些存储过程调用

select distinct object_name(id) from syscomments where id in
(select id from sysobjects where type =’P’) and text like’%TableName%’