zjcxc(邹建) 大哥及各位高手请进
create proc p_qry
@tbname sysname, --要查的表名
@re nvarchar(4000) out
as
set nocount on
declare @s nvarchar(4000)
set @s=''
select @s=@s+'+case when ['+name+']=2 then '','+name+''' else '''' end'
from syscolumns where id=object_id(@tbname)
select @s='select @s='+stuff(@s,1,1,'')+' from ['+@tbname+'] set @s=stuff(@s,1,1,'''')'
exec sp_executesql @s,N'@s nvarchar(4000) out',@re out
go
=============================我想在上面的存储过程中加一个参数为什么不行============
CREATE proc p_qry
@tbname sysname, --要查的表名
@BAB0000 int,
@re nvarchar(4000) out
as
set nocount on
declare @s nvarchar(4000)
set @s=''
select @s=@s+'+case when ['+name+']=2 then '','+name+''' else '''' end'
from syscolumns where id=object_id(@tbname) and name <>'TS' and len(name) <=13
select @s='select @s='+stuff(@s,1,1,'')+' from ['+@tbname+'] where BAB0000=['+@BAB0000+'] set @s=stuff(@s,1,1,'''')'
exec sp_executesql @s,N'@s nvarchar(4000) out',@re out
GO
对了如果通过主建没有检索到 数据时 会不会保错
谢谢大家了!