收藏几段SQL Server语句和存储过程

 (length as varchar) ')) ''''''''' ' end'
else '''NULL'''
end as Cols,name
from syscolumns
where id = object_id(@tablename)
) T
set @sql ='select ''insert into [' @tablename ']' left(@sql,len(@sql)-1) ') ' left(@sqlValues,len(@sqlValues)-4) ')'' from ' @tablename
--print @sql
exec (@sql)
end
GO

-- ======================================================

--根据表中数据生成insert语句的存储过程

--建立存储过程，执行 proc_insert 表名

--感谢Sky_blue

-- ======================================================

create proc proc_insert (@tablename varchar(256))
as
begin
set nocount on
declare @sqlstr varchar(4000)
declare @sqlstr1 varchar(4000)
declare @sqlstr2 varchar(4000)
select @sqlstr='select ''
共16页: 上一页 [1] [2] [3] [4] [5] [6] [7] [8] 9 [10] [11] [12] [13] [14] [15] [16] 下一页

评论加载中…