Recommend this page to a friend! | Stumble It! | Bookmark in del.icio.us |
Classes of Cosmin Cristea | > | MySQL stored procedures | > | default.sp | > | Download | ||
|
Download |
// 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 |