34,593
社区成员
发帖
与我相关
我的任务
分享可不可以把表名作为参数传递?
CREATE PROCEDURE x
@cltable1 char(10)
as
select * from @cltable1
go
exec "cl11"
这样可不可行?
...全文
请发表友善的回复…
发表回复
abc_sk 2006-08-13
- 打赏
- 举报
CREATE PROCEDURE x
as
declare @cltable1 table (a varchar(10))
select * from @cltable1
go
exec x
as
declare @cltable1 table (a varchar(10))
select * from @cltable1
go
exec x
OracleRoob 2006-08-13
- 打赏
- 举报
CREATE PROCEDURE x
@cltable1 varchar(10) --定义为varchar
as
declare @s varchar(8000)
set @s='select * from ' + @cltable1
exec (@s)
go
@cltable1 varchar(10) --定义为varchar
as
declare @s varchar(8000)
set @s='select * from ' + @cltable1
exec (@s)
go
vmans 2006-08-13
- 打赏
- 举报
是exec x "cl11"
