HOW TO CREATE STORED PROCEDURE IN SQL SERVER .

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 858  View(s)
Ratings:
Rate this:

Can anyone please help me how to solve this problem.

  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: How to create stored procedure in sql server .

    
    
    

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!