I have created a table (CUSTOMERS) in the SQL database with the following parameters:
Name datatype length
CustomerID int 4
CustomerName varchar 50
CustomerAddress varchar 250
I'm using a stored procedure: GetCustomersbyID:
Alter procedure dbo.GetCustomersbyID
@id int
AS
select * from Customers
where ...