Writing Stored Procedures with Microsoft SQL ServerAnnotation Writing Stored Procedures for Microsoft SQL Server will focus on teaching the reader not only how to build effective stored procedures, but also on how to optimize and stream line them for long term use. The reader will be provided with an understanding of how SQL Server interprets stored procedures verses direct access via SQL queries. This will be followed by detailed instructions on creating and maintaining a repository of stored procedures. Once the reader knows how stored procedures are created and built, they will be taught how to determine which logic within an application makes sense to be put into this scheme. Additionally, they will be provided with guidance on making stored procedures that are portable across applications. Some of the specific topics covered in Writing Stored Procedures with Microsoft SQL Server will include How SQL Server interprets stored procedures and SQL statements, Designing, building, and implementing stored procedures, Creating stored procedures that can be used in multiple applications, Working with Indexes, Views and Triggers in stored procedures, Building business logic into stored procedures, "Componentizing" database access, and Accepting parameters in stored procedures. |
Common terms and phrases
ActionType application au_fname au_id BEGIN SELECT BEGIN UPDATE business logic CHAPTER CHAR checks client code in Listing column CONVERT VARCHAR CREATE PROCEDURE create stored procedures CREATE TABLE cursor data type database default DELETE error example EXEC execution plan extended stored procedure FETCH FETCH_STATUS GETDATE GO CREATE GRANT 51 INNER JOIN INSERT DATA INT DECLARE intBasePos intCounter Internet Information Server intLineID intObjectID keyword lock loop Microsoft Microsoft SQL Server NULL ObjectID objects operator option OUTPUT parameter perform permissions PRINT PROCEDURES STORED ProcSecurity pSrvProc Query Analyzer query plan RAISERROR referenced RETURN statement role rows SELECT statement SET NOCOUNT specified SQL Server 2000 SQL Server 7.0 stored proce syntax system stored procedure T-SQL tells SQL Server Transact-SQL trigger user-defined functions UserName VARCHAR 32 variables vchActionType vchColumnType vchCurrentLine vchName vchObjectType vchPrint vchStatus vchStatusMessage vchUserName versions of SQL ViewTable1 ViewTable2 Value Windows NT