Sample Stored Procedure_1

Sample Stored Procedure
*Create procedure

create proc Insert_sp

(

@UserName nvarchar(50),

@UserCity nvarchar(50),

@PhoneNo nvarchar(50),

@UserAddress nvarchar(50)

)

as

insert into ThreetierArchitecture(UserName,UserCity,PhoneNo,UserAddress) values(@UserName,@UserCity,@PhoneNo,@UserAddress)

return

 *Create select procedure

Create procedure Select_sp

as

Select * from ThreetierArchitecture

return

 *Create update procedure

create proc Update_sp

(

@UserId int,

@UserName nvarchar(50),

@UserCity nvarchar(50),

@PhoneNo nvarchar(50),

@UserAddress nvarchar(50))

as

/* set NOCOUNT ON*/

update ThreetierArchitecture set UserName=@UserName,UserCity=@UserCity,PhoneNo=@PhoneNo,UserAddress=@UserAddress where UserId=@UserId

return

 *Create delete procedure

create proc Delete_sp

(

@UserId int

)

as

delete from ThreetierArchitecture where UserId=@UserId

return

 *Alter insert procedure

ALTER proc Insert_sp

(

@UserId int,

@UserName nvarchar(50),

@UserCity nvarchar(50),

@PhoneNo nvarchar(50),

@UserAddress nvarchar(50))

as

insert into ThreetierArchitecture(UserName,UserCity,PhoneNo,UserAddress) values(@UserName,@UserCity,@PhoneNo,@UserAddress)

go

https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos