Save 15% on Instant Deploy Bare-Metal Servers in 26 Global Markets with Coupon Code: EdgeSave

Write a stored procedure for MS SQL

Connect to your database through an application such as Enterprise Manager, go to your database, right click stored procedures and select new. Below is a basic example of a stored procedure:

CREATE PROCEDURE spStoredPrcedureName

@variable1 int,
@variable2 varchar(64)


select id from someTable where column1 = @variable1 AND column2 = @variable2


Share on Twitter
Share on Facebook