摘要: SELECT * FROM sys.all_objects WHERE 1=1 --AND TYPE IN ('p','pc') AND is_ms_shipped=0 AND TYPE IN ('FN','P','U','V','TR') AND left([name],3)!='sp_' ORDER BY modify_date DESC 阅读全文
posted @ 2008-12-30 23:44 Benny Ng 阅读(166) 评论(0) 推荐(0) 编辑
摘要: /* Benny:只处理那些NVARCHAR字段,并且NTEXT也是小于4000个字符时的情况.不管类型.只管长度. */ ------------------------------------------------------ NTEXT FIELDS ----------------------------------------------------------------------... 阅读全文
posted @ 2008-12-30 01:21 Benny Ng 阅读(340) 评论(0) 推荐(0) 编辑