How to create stored procedure in sql server .

Total Post:341

Points:2389
 1164  View(s)
Ratings:
Rate this:

Can anyone please help me how to solve this problem.

  1. Post:281

    Points:2003
    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

      Modified On Apr-10-2018 04:53:48 AM

Answer