sqlserverinsert:SQL SERVER数据导成INSERT来源: 发布时间:星期日, 2009年3月29日 浏览:0次 评论:0
="t18">create proc spGenInsertSQL
@TableName as varchar(100) as --declare @TableName varchar(100) -- @TableName = 'orders' -- @TableName = 'eeducation' DECLARE xCursor CURSOR FOR SELECT name,xusertype FROM syscolumns WHERE (id = OBJECT_ID(@TableName)) declare @F1 varchar(100) declare @F2 eger declare @SQL varchar(8000) @sql ='SELECT ''INSERT INTO ' + @TableName + ' VALUES(''' OPEN xCursor FETCH xCursor o @F1,@F2 WHILE @@FETCH_STATUS = 0 BEGIN @sql =@sql + + when @F2 IN (35,58,99,167,175,231,239,61) then ' + when ' + @F1 + ' IS NULL then '''' '''''''' end + ' '+' end + 'replace(ISNULL(cast(' + @F1 + ' as varchar(8000)),''NULL''),'''''''','''''''''''')' + when @F2 IN (35,58,99,167,175,231,239,61) then ' + when ' + @F1 + ' IS NULL then '''' '''''''' end + ' '+' end + char(13) + ''',''' FETCH NEXT FROM xCursor o @F1,@F2 END CLOSE xCursor DEALLOCATE xCursor @sql = left(@sql,len(@sql) - 5) + ' + '')'' FROM ' + @TableName exec (@sql) go EXEC spGenInsertSQL *TBLNAME* 0
相关文章
读者评论发表评论 |
|