Câu 37: 70-464: Developing Microsoft SQL Server 2012/2014 Databases

You need to convert the functionality of Dynamic.sql to use a stored procedure. Which Transact SQL statement should you add to the stored procedure contain?

1. A. CREATE PROC Production.ProductsAfterDate (@ProductID AS varchar(11), @CreationDate AS date) AS ...
2. B. CREATE PROC Production.ProductsAfterDate( @sqlstring AS nvarchar(1000)) AS ...
3. C. CREATE PROC Production.ProductsAfterDate( @sqlstring AS nvarchar(1000), OUTPUT @ProductID AS varchar(11), OUTPUT @CreationDate AS date) AS ... — đáp án hiện tại
4. D. CREATE PROC Production.ProductsAfterDate( @sqlstring AS nvarchar(1000), @ProductID AS varchar(11), @CreationDate AS date) AS ...