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