PHP Classes

File: default.sp

Recommend this page to a friend!
  Classes of Cosmin Cristea   MySQL stored procedures   default.sp   Download  
File: default.sp
Role: Auxiliary data
Content type: text/plain
Description: example
Class: MySQL stored procedures
Emulation of stored procedures for MySQL databases
Author: By
Last change:
Date: 20 years ago
Size: 346 bytes
 

Contents

Class file image 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