// all procedures must start in a new line and the go command also
create procedure sp_example1 (@param1, @param2) as //comment
select * from test where id > @param1
go
create procedure sp_example2(@param in, @param2 out) as
// comment
insert into test (text)
values (@param)
select id from test where text = @param
go
Download
