Sql生成 Insert 语句
declare @TableName sysname select @TableName = 'T_OOSOrder' declare @result varchar(max) = 'INSERT INTO '+@TableName+' (' declare @result1 varchar(max) = 'VALUES(' select @result = @result + name+ ',' FROM ( select name from sys.columns where object_id = object_id(@TableName) )a select @result = SUBSTRING(@result,1,LEN(@Result)-1)+')' select @result1 = @result1 + '@'+ name+ ',' FROM ( select name from sys.columns where object_id = object_id(@TableName) )a select @result1 = SUBSTRING(@result1,1,LEN(@result1)-1)+')' set @result = @result +CHAR(10)+ @result1 print @result