Comments in Sql Store Procedure
Course- SQL Sever Store Procedure >
Comments: TWo types comments in sql store procedure
Line Comments
To create line comments you just use two dashes "--" in front of the code you want to comment. You can comment out one or multiple lines with this technique.
In this example the entire line is commented out.
-- this procedure gets a list of addresses based
-- on the city value that is passed
CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30)
AS
SELECT *
FROM Person.Address
WHERE City = @City
GO
This next example shows you how to put the comment on the same line.
-- this procedure gets a list of addresses based on the city value that is passed CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30) AS SELECT * FROM Person.Address WHERE City = @City -- the @City parameter value will narrow the search criteria GO
Block Comments
To create block comments the block is started with "/*" and ends with "*/". Anything within that block will be a comment section.
/*
-this procedure gets a list of addresses based
on the city value that is passed
-this procedure is used by the HR system
*/
CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30)
AS
SELECT *
FROM Person.Address
WHERE City = @City
GO