Reviewing scripts

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