摘要：--delete test.dbo.Table_1--test.dbo.Table_1 是存需要导出存储过程的列表declare @strColName as varchar(50)Declare Cur_NewTable Cursor ForSelect a from test.dbo.Table_1Open Cur_NewTableWhile 1 = 1Begin Fetch Next Fro... 阅读全文

摘要：EXEC Sp_HelpText 'stp_xxx' 阅读全文

摘要：declare @name varchar(1000)declare @tablename varchar(1000)declare @fieldname varchar(1000)declare @defaultValue varchar(100)set @tablename='Contract'set @fieldname='StockNo'set @defaultValue=''''''--... 阅读全文

摘要：declare @defname varchar(100)declare @cmd varchar(500)declare @tablename varchar(100)declare @keyname varchar(100)Set @tablename='Temp1'Set @keyname='id' --需要設置的key,分隔select @defname= nameFROM sysobje... 阅读全文