Login   Register  
PHP Classes
elePHPant
Icontem

File: default.sp

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 10 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