Stored Procedures

[Clea Boe]

Can anyone suggest documentation/examples of stored procedures ? I am learning Transact-SQl and would like to see examples for study purposes -

Thanks

[Glauco Martins]

There are two good places to learn about stored procedures: the online version of the book "Special Edition, Using SQL Server second edition", that you can find at http://www.swynk.com/SQL.asp, and SQL Server books online (Database developers companion - chapter 6), that you can find in SQL Server directory.

Hope it can help you.





On 7/3/98 10:43:53 AM, Clea Boe wrote:
> Can anyone suggest documentation/examples of stored procedures ? I am
> learning Transact-SQl and would like to see examples for study purposes -

Thanks

[Asfen Tantono]

On 7/3/98 10:43:53 AM, Clea Boe wrote:
> Can anyone suggest documentation/examples of stored procedures ? I am
> learning Transact-SQl and would like to see examples for study purposes -

Thanks

Clea,

In your SQL*Server, under the `master` database, open the `object` folder and you will find a `Stored Procedure` folder. Double click on any of the stored procedure under that folder will enable you to view the SQL script.

Refer to the books online on how to create Stored Procedure and Triggers.

Cheers,
Asfen

[Stephen Power]

Clea,

Take a look at the code for all the system stored procedures. They are located in the master db.
Not only do they work, but they are easy to follow.

steve



On 7/3/98 10:43:53 AM, Clea Boe wrote:
> Can anyone suggest documentation/examples of stored procedures ? I am
> learning Transact-SQl and would like to see examples for study purposes -

Thanks

[Clea Boe]

Thanks - the "Special Edition, Using SQL Server second edition", looks very helpful -
Clea



On 7/4/98 3:08:31 PM, Glauco Martins wrote:
> There are two good places to learn about stored procedures: the online
> version of the book "Special Edition, Using SQL Server second edition",
> that you can find at http://www.swynk.com/SQL.asp, and SQL Server books
> online (Database developers companion - chapter 6), that you can find in
> SQL Server directory.

Hope it can help you.





On 7/3/98
> 10:43:53 AM, Clea Boe wrote:
> Can anyone suggest documentation/examples
> of stored procedures ? I am
> learning Transact-SQl and would like to
> see examples for study purposes -

Thanks