sqlserverinsert:SQL SERVER数据导成INSERT来源: 发布时间:星期日, 2009年3月29日 浏览:0次 评论:0
="t18">create proc spGenInsertSQL
@TableName as varchar(100) as --declare @TableName varchar(100) -- ![]() -- ![]() DECLARE xCursor CURSOR FOR SELECT name,xusertype FROM syscolumns WHERE (id = OBJECT_ID(@TableName)) declare @F1 varchar(100) declare @F2 ![]() declare @SQL varchar(8000) ![]() OPEN xCursor FETCH xCursor ![]() WHILE @@FETCH_STATUS = 0 BEGIN ![]() + ![]() ![]() ![]() ![]() + 'replace(ISNULL(cast(' + @F1 + ' as varchar(8000)),''NULL''),'''''''','''''''''''')' + ![]() ![]() ![]() ![]() + char(13) + ''',''' FETCH NEXT FROM xCursor ![]() END CLOSE xCursor DEALLOCATE xCursor ![]() exec (@sql) go EXEC spGenInsertSQL *TBLNAME* 0
相关文章
读者评论发表评论 |
|