---

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.SQL Server 2000 Training1. Introduction to Microsoft SQL Server 2000 Overview of SQL Server 2000 Components of SQL Server 2000 Overview...
This tutorial series covers the basic concepts of Stored Procedures in SQL Server and hot create and execute a simple stored procedure.Using Stored ProceduresSome of the most important concerns to a database user are speed and efficiency. Faster data retrieval provides applications to responds and behaves quickly. SQL Server provides Stored Procedures”...
This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code. Creating Stored Procedure with Input ParametersInput Parameters in Stored Procedures are placeholders for data that the user needs to send. Technically input parameters are memory variables because...
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. Securing Your Stored ProcedureStored Procedures resides on the database server in open fashion. It means that every body can easily access and...
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_’ .Using System Stored Procedures Whenever you add a database add a login create a table or modify any object the changes reflect in the...
This tutorial on Views in SQL Server covers the concept of views Creating Simple View deleting views and how to use them.Using Views in SQL ServerViews are nothing but saved SQL Statements and are sometimes referred as Virtual Tables” . Views cannot store data; rather they only refer to data present in tables. As the name implies they...