How to create stored procedure in sqlserver for insert statement.

Question

Anonymous User · Answer

--let’s start querying create a table.
and  CREATE TABLE UserMasters(
and and and and and and  UserId int IDENTITY(1,1) primary key,
and and and and and and  LoginName nvarchar(100) ,
and and and and and and  password nvarchar(100) ,
and and and and and and  UserName nvarchar(100) and 
and  )
and --Now start querying create a procedure for insert data.
and alter procedure sp_InsertUserMasters
and (  @LoginName nvarchar(100) ,
and and and and and and  @password nvarchar(400) ,
and and and and and and  @UserName nvarchar(400)and and 
and )
and as
and begin
and insert into UserMasters (LoginName,password,UserName) values(@LoginName,@password,@UserName) 
and end
and --Now start querying createand use procedure for insert data.and exec sp_InsertUserMasters 'kavita@hotmail.com','kavita$%2015','kavita Patel'

forum

How to create stored procedure in sqlserver for insert statement.

Anonymous User

Can you answer this question?

1 Answers

Liked By