Monday, November 16, 2009

UpdateProcedure !!

CREATE Procedure UpdateProcedure
(
@firstname varchar(50),
@lastname varchar(50),
@address Varchar(100),
@city Varchar(50),
@state Varchar(50),
@pincode Varchar(20),
@EmailId Varchar(80),
@customerid int
)
AS
Update Registration set
customesr_firstname=@firstname,
customers_lastname= @lastname,
customers_address=@address,
customers_city= @city,
customers_state=@state,
customers_zipcode= @pincode ,
customers_email_address= @EmailId
where customers_id=@customerid


GO

No comments: