111,096
社区成员




-- 校验语法
DECLARE @BusinessEntityID int = 123;
SELECT BusinessEntityID, NationalIDNumber, JobTitle, LoginID
FROM AdventureWorks2012.HumanResources.Employee
WHERE BusinessEntityID = @BusinessEntityID
-- 测试执行
EXECUTE sp_executesql
N'SELECT BusinessEntityID, NationalIDNumber, JobTitle, LoginID
FROM AdventureWorks2012.HumanResources.Employee
WHERE BusinessEntityID = @BusinessEntityID
', N'@BusinessEntityID tinyint', N'@BusinessEntityID = 123';