creating stored procedures

[lothadio]

How do I create a storedprocedure?

After I establish a storedprocedure, how do I call it for execution within a php script?

Thanks

 

[tlbroadbent]

To create a stored procedure...

Create procedure MyProcedureName As
.
.
Insert your code here
.
.
Go

To execute a stored procedure...

Exec MyProcedureName

SQL Books Online have more details about creating stored procedures including the use of parameters in procedure calls. Terry

http://members.home.net/tlbroadbent/index.htm