你是一个出版公司的数据库开发人员,对特定的书名的每天的销售情况建立了如下的存储过程:CREATE PROCEDURE get_sales_for_titletitle varchar(80), @ytd_sales int OUTPUTASSELECT @ytd_sales = ytd_salesFROM titlesWHERE title = @titleIF @@ROWCOUNT = 0RETURN(-1)ELSERETURN(0)另外建立了一个脚本执行这个存储过程,如果执行成功,将返回对应于书名的每天的销售情况的报表,如果执行失败,将返回“No Sales Found”,怎样建立这个脚本?A. DECLARE @retval intDECLARE @ytd intEXEC get_sales_for_title ‘Net Etiquette’, @ytdIF @retval 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GOB. DECLARE @retval intDECLARE @ytd intEXEC get_sales_for_title ‘Net Etiquette’, @ytd OUTPUTIF @retval 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GOC. DECLARE @retval intDECLARE @ytd intEXEC get_sales_for_title ‘Net Etiquette’,@retval OUTPUTIF @retval 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GOD. DECLARE @retval intDECLARE @ytd intEXEC @retval = get_sales_for_title ‘Net Etiquette’, @ytd OUTPUTIF @retval 0PRINT ‘No sales found’ELSEPRINT ‘Year to date sales: ’ + STR (@ytd)GO
你是一个出版公司的数据库开发人员,对特定的书名的每天的销售情况建立了如下的存储过程:
CREATE PROCEDURE get_sales_for_title
title varchar(80), @ytd_sales int OUTPUT
AS
SELECT @ytd_sales = ytd_sales
FROM titles
WHERE title = @title
IF @@ROWCOUNT = 0
RETURN(-1)
ELSE
RETURN(0)
另外建立了一个脚本执行这个存储过程,如果执行成功,将返回对应于书名的每天的销售情况的报表,如果执行失败,将返回“No Sales Found”,怎样建立这个脚本?
A. DECLARE @retval int
DECLARE @ytd int
EXEC get_sales_for_title ‘Net Etiquette’, @ytd
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO
B. DECLARE @retval int
DECLARE @ytd int
EXEC get_sales_for_title ‘Net Etiquette’, @ytd OUTPUT
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO
C. DECLARE @retval int
DECLARE @ytd int
EXEC get_sales_for_title ‘Net Etiquette’,@retval OUTPUT
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO
D. DECLARE @retval int
DECLARE @ytd int
EXEC @retval = get_sales_for_title ‘Net Etiquette’, @ytd OUTPUT
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO