---
title: "How to create stored procedure in sqlserver for insert statement."  
description: "How to create stored procedure in sqlserver for insert statement."  
author: "Anonymous User"  
published: 2015-10-26  
updated: 2015-10-26  
canonical: https://www.mindstick.com/forum/33537/how-to-create-stored-procedure-in-sqlserver-for-insert-statement  
category: ".net"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# How to create stored procedure in sqlserver for insert statement.

Can [anyone](https://www.mindstick.com/articles/23207/how-to-find-the-best-fit-job-for-anyone) please help me how to [solve this problem](https://answers.mindstick.com/qa/94681/my-google-assistant-shows-completely-different-search-results-from-what-i-ask-how-can-i-solve-this-problem).

## Replies

### Reply by Anonymous User

```
--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'
```

```

```


---

Original Source: https://www.mindstick.com/forum/33537/how-to-create-stored-procedure-in-sqlserver-for-insert-statement

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.