ProgrammingB52
Technical User
How do I write a stored procedure to declare the following variables @Phone and @CustomerID to equal the Customer's table's fields Customer.phone and Customer.customerID?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Create proc somename
@Phone varchar(14),
@CustomerID int
as
select * from customer where phone = @phone and customerid = @customerid
Create proc somename
as
declare @Phone varchar(14),@CustomerID int
set @phone ='219 123 1234'
set @customerid = '1234'
select * from customer where phone = @phone and customerid = @customerid