想写一个表名为参数的存储过程,可是不知道错误在哪?(10分)

X

xuzhic2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-01

• #1

creat procedure aa
@tablex varchar(30),@fieldx varchar(30)
as
select * from @tablex where @fieldx in(select...... )
go
总是提示在@tablex这个地方出错，可是不知道错误在哪?

 

D

dey-999

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-01

• #2

exec('select * from '+@tablex+' where '+@fieldx+' in(select...... )')

 

X

xuzhic2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-01

• #3

楼上说的不对啊.仍旧还是那个错误

 

X

xuzhic2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-01

• #4

creat procedure aa
@tablex varchar(30),@fieldx varchar(30)
as
exec('select * from '+@tablex+' where '+@fieldx+' in(select...... )')
go

错误是必须声明 @tablex

 

空

空心

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-01

• #5

create procedure aa(
@tablex varchar(30),
@fieldx varchar(30)
)
as
begin
declare
@tmpsql varchar(6000)
set @tmpsql=''
set @tmpsql = @tmpsql + 'select * from '+@tablex + 'where '+ @fieldx + 'in (select ...........)'
exec(@tmpsql)
end
go 给我分吧，这样的问题还是多看下帮助吧，相信自己么问题

 

B

bytelife

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-01

• #6

我试过没有问题的呀?

 

X

xuzhic2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-01

• #7

谢谢各位了