How to create stored procedure in sqlserver for insert statement.

Anonymous User 1620 26 Oct 2015

Can anyone please help me how to solve this problem.

Ask by Anonymous User

Updated 26 Oct 2015

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'

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How to create stored procedure in sqlserver for insert statement.

Can you answer this question?

1 Answers