03 2003 档案
摘要：create proc spGenInsertSQL@TableName as varchar(100)as--declare @TableName varchar(100)--set @TableName = 'orders'--set @TableName = 'eeducation'DECLARE xCursor CURSOR FORSELECT name,xusertypeFROM syscolumnsWHERE (id = OBJECT_ID(@TableName))declare @F1 varchar(100)declare @F2 integer
阅读全文
摘要：相关讨论连接:http://expert.csdn.net/Expert/TopicView1.asp?id=1477009原题:表:Tree (ID [Integer],ParentID [Integer],Remark [varchar])INSERT INTO Tree (ID,ParentID) SELECT 1,0 UNION ALL SELECT 2,1 UNION ALL SELECT 3,1 UNION ALL SELECT 4,2 UNION ALL SELECT 5,4 UNION ALL SELECT 6,5 UNION ALL SELECT 7,2T(F1,......
阅读全文
