How to create stored procedure in sql server .

Anonymous User 2142 24 Oct 2015

Can anyone please help me how to solve this problem.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 24 Oct 2015

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

forum

How to create stored procedure in sql server .

Can you answer this question?

1 Answers