摘要：
SELECT Name,--存储过程名字 Definition --存储过程内容 FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id WHERE o.[type] = 'P' 阅读全文
posted @ 2019-08-15 08:49
派大星帅帅
阅读(5080)
评论(3)
推荐(0)
摘要：
SELECT Name,--视图名字 Definition --视图内容 FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id WHERE o.[type] = 'v' 阅读全文
posted @ 2019-08-15 08:47
派大星帅帅
阅读(7930)
评论(0)
推荐(0)
摘要：
SELECT 字段名=a.name, 类型=b.name, 字段说明=isnull(g.[value],''), 是否为空=case when a.isnullable=1 then 1 else 0 end, 是否自增=case when COLUMNPROPERTY(a.id,a.name,'IsIdentity')=1 then 1 else 0 end, 主键=case when exi... 阅读全文
posted @ 2019-08-15 08:41
派大星帅帅
阅读(1031)
评论(0)
推荐(0)
摘要：
DECLARE DataClean CURSOR FOR SELECT a.name AS t_name , b.name AS c_name , c.DATA_TYPE FROM sys.tables a JOIN sys.columns b ON b.object_id = a.object_id... 阅读全文
posted @ 2019-08-15 08:37
派大星帅帅
阅读(850)
评论(0)
推荐(0)
浙公网安备 33010602011771号