34,576
社区成员
发帖
与我相关
我的任务
分享在存储里,这条SQL语句怎么写?
在写存储的时候,碰到了个麻烦,搞不懂.
语句是这样的:
DECLARE @SQL Varchar(200)
DECLARE @RS Varchar(100)
Set @SQl = SELECT ProductName FROM Product WHERE ID = @ID
我想取到ProductName这个值，怎么取啊
语句是这样的:
DECLARE @SQL Varchar(200)
DECLARE @RS Varchar(100)
Set @SQl = SELECT ProductName FROM Product WHERE ID = @ID
我想取到ProductName这个值，怎么取啊
...全文
请发表友善的回复…
发表回复
bullion 2004-04-10
- 打赏
- 举报
谢谢了！
chludlf 2004-04-10
- 打赏
- 举报
DECLARE @SQL Varchar(200)
DECLARE @RS Varchar(100)
if (select sum(1) FROM Product WHERE ID = @ID)>1
begin
RAISERROR 33333,'記錄有重復.'
return
end
select @SQl = SELECT ProductName FROM Product WHERE ID = @ID
print @SQl
DECLARE @RS Varchar(100)
if (select sum(1) FROM Product WHERE ID = @ID)>1
begin
RAISERROR 33333,'記錄有重復.'
return
end
select @SQl = SELECT ProductName FROM Product WHERE ID = @ID
print @SQl
zheninchangjiang 2004-04-10
- 打赏
- 举报
还是你想在存储过程返回这个productname
progress99 2004-04-10
- 打赏
- 举报
DECLARE @SQL Varchar(200)
DECLARE @RS Varchar(100)
SELECT @SQl =ProductName FROM Product WHERE ID = @ID
DECLARE @RS Varchar(100)
SELECT @SQl =ProductName FROM Product WHERE ID = @ID
zheninchangjiang 2004-04-10
- 打赏
- 举报
select @sql=productname from product where id=@id
