Reviewing scripts

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Which of the following calls to the stored procedure are valid? CREATE PROC spInvoiceTotal1 @DateVar smalldatetime = '2022-01-01' @VendorID int AS SELECT SUM(InvoiceTotal) FROM Invoices WHERE VendorID = @VendorID AND InvoiceDate >= @DateVar

EXEC spInvoiceTotal1 '2019-10-01', 122 EXEC spInvoiceTotal1 @VendorID = 122 EXEC spInvoiceTotal1 @VendorID = 122, @DateVar = '2019-10-01'

Which of the following statements calls the stored procedure and passes the values '2019-10-01' and 122 to its input parameters? CREATE PROC spInvoiceTotal1 @DateVar smalldatetime, @VendorID int AS SELECT SUM(InvoiceTotal) FROM Invoices WHERE VendorID = @VendorID AND InvoiceDate

EXEC spInvoiceTotal1 @VendorID = 122, @DateVar = '2019-10-01'

What statement can you use to divide a script into multiple batches?

GO

Which statement assigns the value "Test" to a scalar variable named @Name that's declared with the varchar data type?

SET @Name = 'Test'

The scope of a local variable is limited to what?

the batch in which it's defined


Ensembles d'études connexes

Discuss the risk factors that contribute to pressure ulcer formation.

View Set

The Setting Sun and Rolling World

View Set

Exam 1 Impact of Digital Technology ISDS

View Set

Relief, Recovery, Reform Definitions

View Set