Collections:
Creating Stored Procedures with Parameters in SQL Server
How To Create Stored Procedures with Parameters in SQL Server Transact-SQL?
✍: FYIcenter.com
Very often, you need to create a stored procedure with one or more parameters. You only supply values to those parameters at the time of executing the stored procedure.
Stored procedures with parameters can be created with the following syntax:
CREATE PROCEDURE procedure_name @parameter_1 datatype, @parameter_2 datatype, ... @parameter_n datatype AS statement_1; statement_2; ... statement_n; GO
The following tutorial exercise shows you how to create a stored procedure with one parameter called @url:
USE FyiCenterData; GO DROP PROCEDURE Hello; GO CREATE PROCEDURE Hello @url nvarchar(40) AS PRINT 'Welcome to ' + @url; GO EXEC Hello 'dba.fyicenter.com'; GO Welcome to dba.fyicenter.com
2017-01-05, 753👍, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...