---
title: "How to create stored procedure in sql server ."  
description: "How to create stored procedure in sql server ."  
author: "Anonymous User"  
published: 2015-10-24  
updated: 2015-10-24  
canonical: https://www.mindstick.com/forum/33533/how-to-create-stored-procedure-in-sql-server  
category: "mssql server"  
tags: ["database", "mssql server", "sql server", "sql"]  
reading_time: 1 minute  

---

# How to create stored procedure in sql server .

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(max) ,
       password nvarchar(max) ,
       UserName nvarchar(max)
  )
 --Now start querying create a procedure.

 create procedure sp_GetUserMasters
 as
 begin
 select * from UserMasters
 end
--Now start querying execute a procedure.
 exec sp_GetUserMasters
```

```

```


---

Original Source: https://www.mindstick.com/forum/33533/how-to-create-stored-procedure-in-sql-server

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