链接服务器
EXECUTE ('SELECT ProductID, Name
FROM AdventureWorks.Production.Product
WHERE ProductID = ? ', 952) AT SeattleSales;这个SQL传入一个参数,如果我要传入两个呢,如
EXECUTE ('SELECT ProductID, Name
FROM AdventureWorks.Production.Product
WHERE ProductID = ? and ProductName=这里是什么', 952) AT SeattleSales;这个SQL怎么写
EXECUTE ('SELECT ProductID, Name
FROM AdventureWorks.Production.Product
WHERE ProductID = ? ', 952) AT SeattleSales;这个SQL传入一个参数,如果我要传入两个呢,如
EXECUTE ('SELECT ProductID, Name
FROM AdventureWorks.Production.Product
WHERE ProductID = ? and ProductName=这里是什么', 952) AT SeattleSales;这个SQL怎么写
DECLARE @ProductID INT;
SET @ProductID = 952;
DECLARE @ProductName nvarchar(100);
SET @ProductName = '这里是什么';
EXECUTE ('SELECT ProductID, Name
FROM AdventureWorks.Production.Product
WHERE ProductID = @ProductID and ProductName=@ProductName ', @ProductID, @ProductName AT SeattleSales;
定义两个变量 也可以用exec sp_executesql 来输出