Code a statement that calls the following stored procedure and passes the values ‘2011-12-01’ and 122 to its input parameters. pass the parameters by name in the reverse order that they’re declared in the procedure.
create proc spinvoicetotal1
@datevar smalldatetime,
@vendorid int
as
select sum(invoicetotal)
from invoices
where vendorid = @vendorid and invoicedate > = @datevar;