GREEN JOBS GREEN RECRUITING

An efficient way to create or edit a stored procedure is to use the Query Analyzer, which can create a script for dropping an existing sproc, and creating a new one. The new one can be created using the View editor to click and drag to create a SELECT statement. Then that SQL statement can be cut and pasted into the Query Analyzer, where it can then be tested and debugged.

Stored procedures can be debugged in the Query Analyzer by opening the object browser and right clicking on a stored procedure and choosing Debug.

2. " "SQL Server Stored Procedures. Stored Procedures are SQL statements saved in a database as a n object. They can be called interactively through the Query Analyzer, and by other stored procedures. They can be defined with parameters to make them more flexible, and can return result sets and status codes.

Their advantages include: The ability to restrict access to the underlying tables;

Increased security in a networked environment;

The vehicle to modularize programming on the database end of an application by allowing re-usable code with callable subroutines;

Faster execution because they are pre-compiled;

Preservation of integrity in tables through enforced data procedures; and.

Reduction of programming error and network traffic in passing in ad hoc queries.