Create Procedure on Registration Table

1.Insert Procedure

Create proc UDP_INSRegistration

(

@UserName varchar(50),

@Addresses varchar(50),

@PhoneNo numeric(11, 0))

as

insertinto Regisration(UserName,Addresses,PhoneNo)values(@UserName,@Addresses,@PhoneNo)

go

                                    OR

Create PROCEDURE UDP_INSRegistration

(

@UserName varchar(50),

@Addresses varchar(50),

@PhoneNo numeric(11, 0))

AS

BEGIN

insertinto Registration(UserName,Addresses,PhoneNo)values(@UserName,@Addresses,@PhoneNo)

END

2.Select Procedure

Create PROCEDURE UDP_SELRegistration

AS

BEGIN

select * from Registration

END

3.Delete Procedure

Createproc UDP_DELRegistration

(

@UserName varchar(50),

@Addresses varchar(50),

@PhoneNo nvarchar(50))

AS

BEGIN

DELETEfrom Registration

WHERE

UserName=@UserName

END

4.Alter Procedure

Alterproc UDP_DELRegistration

(

@UserName varchar(50),

@Addresses varchar(50),

@PhoneNo nvarchar(50))

AS

BEGIN

DELETEfrom Registration

WHERE

UserName=@UserName

END

5. Execute Procedure

eg:-exec ProcdureName

exec UDP_INSRegistration'Bansal','Moradabad',0987654321

exec UDP_DELRegistration UserName='Amit'

exec UDP_SELRegistration

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