Выберите синтаксис создания хранимой процедуры:
CREATE PROCEDURE TestProcedure
(@par1 INT, @par2 VARCHAR(100), @par3 MONEY = 0) AS
BEGIN
....
END
GO
CREATE TABLE #Procedure
(@par1 INT, @par2 VARCHAR(100), @par3 MONEY = 0) AS
BEGIN
END
GO
CREATE PROCEDURE @Procedure
( par1 INT, par2 VARCHAR(100), par3 MONEY = 0) AS
BEGIN
END
GC
CREATE VIEW Procedure
( par1 INT, par2 VARCHAR(100), par3 MONEY) AS
BEGIN
END
GO