DECLARE @SQL Varchar(200) DECLARE @RS Varchar(100) SELECT @SQl =ProductName FROM Product WHERE ID = @ID
还是你想在存储过程返回这个productname
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)
SELECT @SQl =ProductName FROM Product WHERE ID = @ID
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