34,587
社区成员
发帖
与我相关
我的任务
分享大家帮我看看我怎么错了
ALTER proc [dbo].[pr_test]
(
@arg varchar(20)
)
as
declare @str varchar(100)
set @str='select * from t1 where arg='''+@arg+''''
exec @str
set @str='select * from t2 where arg='''+@arg+''''
exec @str
我这么写有什么错误啊
(
@arg varchar(20)
)
as
declare @str varchar(100)
set @str='select * from t1 where arg='''+@arg+''''
exec @str
set @str='select * from t2 where arg='''+@arg+''''
exec @str
我这么写有什么错误啊
...全文
请发表友善的回复…
发表回复
杯酒畅怀 2012-02-24
- 打赏
- 举报
樓上正解
dawugui 2012-02-24
- 打赏
- 举报
ALTER proc [dbo].[pr_test]
(
@arg varchar(20)
)
as
begin
declare @str varchar(100)
set @str='select * from t1 where arg = ''' + @arg + ''''
exec (@str)
set @str='select * from t2 where arg = ''' + @arg + ''''
exec (@str)
end老猫五号 2012-02-24
- 打赏
- 举报
ALTER proc [dbo].[pr_test]
(
@arg varchar(20)
)
as
declare @str varchar(100)
set @str='select * from t1 where arg='''+@arg+''''
exec (@str)
set @str='select * from t2 where arg='''+@arg+''''
exec (@str)
(
@arg varchar(20)
)
as
declare @str varchar(100)
set @str='select * from t1 where arg='''+@arg+''''
exec (@str)
set @str='select * from t2 where arg='''+@arg+''''
exec (@str)
