forum

Home / DeveloperSection / Forums / How to create stored procedure in sqlserver for insert statement.

Ask Question

How to create stored procedure in sqlserver for insert statement.

Anonymous User 1237 26-Oct-2015

Can anyone please help me how to solve this problem.

sql server

Updated on 26-Oct-2015

Anonymous User

I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

26-Oct-2015

--let’s start querying create a table.

  CREATE TABLE UserMasters(
       UserId int IDENTITY(1,1) primary key,
       LoginName nvarchar(100) ,
       password nvarchar(100) ,
       UserName nvarchar(100)  
  )

 --Now start querying create a procedure for insert data.
 alter procedure sp_InsertUserMasters
 ( 
 @LoginName nvarchar(100) ,
       @password nvarchar(400) ,
       @UserName nvarchar(400)  
 )
 as
 begin
 insert into UserMasters (LoginName,password,UserName) values(@LoginName,@password,@UserName) 
 end

 --Now start querying create use procedure for insert data.
 exec sp_InsertUserMasters 'kavita@hotmail.com','kavita$%2015','kavita Patel'

forum

How to create stored procedure in sqlserver for insert statement.

Anonymous User

1 Answers

Liked By