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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedure to declare variables
- Thread starter ProgrammingB52
- Start date
- Status
NoCoolHandle
Programmer
Code:
Create proc somename
@Phone varchar(14),
@CustomerID int
as
select * from customer where phone = @phone and customerid = @customerid
Code:
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- Status
Similar threads
- Locked
- Question