Tuesday 13 March 2012

procedure to update the table values


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[updating]
(
@regid int,
@name varchar(50),
@email varchar(50),
@password varchar(50),
@phno varchar(50),
@addres varchar(50),
@institute varchar(50),
@course varchar(50),
@studying varchar(50)
)
as
update registration set
SE_name = @name,
SE_email = @email,
SE_password = @password,
SE_phno = @phno,
SE_address = @addres,
SE_institute = @institute,
SE_course = @course,
SE_studying = @studying
where
SE_regid = @regid

No comments:

Post a Comment