This article is a spanzhang original, its blog address is: http://blog.9cbs.net/spanzhang. Quote or repost, please indicate the source, thank you! !
/ * Author: Zhang Youbang Time: 2005-03-03 Description: simply copy the contents of a table version: 1.0 History: Note: * / ALTER procedure dbo.x_p_copyTable (@tableName nvarchar (128), @condition nvarchar (1024) = N '', @remoteServer nvarchar (128) = N'TGM_OLD.span_tgm_020 ') asdeclare @sql nvarchar (4000) set @sql = N'select @cnt = count (*) from sysobjects, syscolumns where sysobjects.id = syscolumns .id and syscolumns.colstat = 1 and sysobjects.name = '' ' @tableName N' '' 'declare @count intexecute sp_executesql @sql, N' @ cnt int output ', @count outputif @count> 0 begin set @sql = N'set identity_insert ' @tableName N' on 'execute sp_executesql @sqlenddeclare @columns nvarchar (2048) set @columns = N''select @columns = @columns syscolumns.name N', 'from sysobjects , syscolumnswhere sysobjects.id = syscolumns.id and syscolumns.iscomputed <> 1 and sysobjects.name = @tableNameif len (@columns)> 0 begin set @columns = substring (@columns, 1, len (@columns) - 1) Endset @SQL = N'Insert ' @tablename n' (' @colu MNS N ')' N'SELECT ' @columns n' from ' @RemoteServer N'.dbo.' @tablenameif @condition <> n 'begin set @SQL = @SQL N' Where ' @conditionendexecute sp_executesql @sqlif @count> 0 begin set @SQL = n'
