在存储过程中，使用表名做参数时怎样做查询？

[clbug]

存储过程表名参数为@dbname，关键字@title;
怎么判断表@dbname中是否存在字段title=@title的记录?
如果直接用
Select * from @dbname where title=@title
会报错;如果用
exec('Select * from '+@dbname+' where title='''+@title+
'''')
好像不能用if exists exec('..')来判断执行结果?
各位老大,应该怎么做啊?

[robin_xin_xin]

关注！
up

[happydreamer]

create procedure sp_check @dbname varchar(100) ,@title varchar(100)
as

exec('Select * from '+@dbname+' where title='''+@title+'''')

if @@rowcount>0
begin
your sql statement
end

[joygxd]

declare @name varchar(8000)
@name='Select * from '+@dbname +'where title= '''+@title+''''
exec @name

[psxfghost]

set @rowcount=0
exec('Select * from '+@dbname+' where title='''+@title+
'''')
if (@rowcount=0)
print '没有满足条件的数据'
else
print '有'+@rowcount+'条满足条件的数据'

[CrazyFor]

exec('Select * from '+@dbname+' where title=@title')

[friendliu]

表名的变量用“+”来连接赋值

对于字段可以直接赋值。

[clbug]

@@RowCount是上一次语句影响的数据行的行数,是全局变量来的;
用它来判断的话,如果数据库有多个线程在运行的时候会不会出问题啊?

[dafu71]

create procedure sp_check @dbname varchar(100) ,@title varchar(100)
as

exec('Select * from '+@dbname+' where title='''+@title+'''')

if @@rowcount=0
print '没有满足条件的数据'
else
print '有'+@@rowcount+'条满足条件的数据'

[leimin]

declare @dbname sysname
declare @title varchar(100)
declare @Author varchar(20),@CreateTime datetime,@sql nvarchar(2000)
set @sql ='Select @Author=Author,@CreateTime=CreateTime from '+@dbname+' where title='''+@title+''''
exec sp_executesql @sql ,N'@a varchar(20) output,@c datetime output'
,@Author output,@CreateTime output

[leimin]

--select * from sales

use pubs
go
declare @tbname sysname
declare @title varchar(100)
declare @Author varchar(20),@CreateTime datetime,@sql nvarchar(2000)

select @tbname='sales'
select @title='TC7777'
set @sql ='Select @Author=ord_num,@CreateTime=ord_date from '+@tbname+' where title_id='''+@title+''''
exec sp_executesql @sql ,N'@author varchar(20) output,@CreateTime datetime output'
,@Author output,@CreateTime output

print @author
print @CreateTime