Ankit Singh Total Post:341 Points:2389 Posted by Ankit Singh October-24-2015 7:08 AM Database MSSQL Server SQL Server SQL MSSQL Server 1 Reply(s) 1005 View(s) Ratings: Rate this: Can anyone please help me how to solve this problem.
aditya kumar Patel Post:254 Points:1810 Re: How to create stored procedure in sql server . Posted on 2 years ago --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
Post:254
Points:1810Re: How to create stored procedure in sql server .