如下是查询出当前数据库中所有表中 有默认值的字段并生成添加默认值的SQL语句
SELECT 'ALTER TABLE[dbo].['+SO.NAME+'] ADD DEFAULT '+SM.TEXT+' FOR '+SC.NAME+'' FROM dbo.sysobjects SO INNER JOIN dbo.syscolumns SC ON SO.id = SC.id LEFT JOIN dbo.syscomments SM ON SC.cdefault = SM.id WHERE SO.xtype = 'U' AND SM.TEXT IS NOT NULL ORDER BY SO.[name], SC.colid
效果如下图