How to create stored procedure in sql server .

Question

Anonymous User · Answer

and and and and and 
--let’s start querying create a table.
CREATE TABLE UserMasters(
and and and and and and UserId int IDENTITY(1,1) primary key,
and and and and and and LoginName nvarchar(max) ,
and and and and and and password nvarchar(max) ,
and and and and and and UserName nvarchar(max) 
and )
and --Now start querying create a procedure.
and create procedure sp_GetUserMasters
and as
and begin
and select * from UserMasters 
and end
--Now start querying execute a procedure.
and exec sp_GetUserMasters

forum

How to create stored procedure in sql server .

Anonymous User

1 Answers

Liked By