 |
|
|
|
|
|
|
|
|
|
|
- We are glad to let you know that we have started SQL Server 2000 training series. See the topics below which we will be providing the tutorials. Please let us know if there anything you would like to add to the topics.
|
|
|
|
|
|
- This tutorial series covers the basic concepts of Stored Procedures in SQL Server and hot create and execute a simple stored procedure.
|
|
|
|
|
|
- This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code.
|
|
|
|
|
|
- This tutorial explains how to secure your stored procedures if you ever need to. Procedures resides on the database server in open fashion. It means that every body can easily access and view its code.
|
|
|
|
|
|
- This tutorial covers how to use System Stored Procedures which are stored in master and msdb databases and normally begin with ‘sp_' and Extended Stored Procedures normally begin with ‘xp_'.
|
|
|
|
|
|
- This tutorial on Views in SQL Server covers the concept of views, Creating Simple View, deleting views and how to use them.
|
|
|
|
|
|
|
|
|
|
|
|