New Transact SQL Video Tutorial: Using SET Commands Inside Stored Procedures and When Executing Stored Procedures

Using SET Commands Inside Stored Procedures and When Executing Stored Procedures - view details

This video is "Must-See TV" for those of you wanting to be better stored procedure programmers. The focus of this video is how the scoping of the SET commands in your stored procedures can impact performance and/or results.

This video was shot on SQL Server 2005 but the same concepts still apply for SQL Server 2000

Highlights from this video:

• Using SET NOCOUNT ON/OFF
• Using TOP vs. ROWCOUNT
• Best Practices for using SET commands in stored procedures
• Optimizing stored procedures for faster execution and easier client use
• Temporary tables and scoping
• Creating temporary stored procedures
• Using DBCC USEROPTIONS to view connection settings
• sys.objects/sysobjects
• Error Handling with transactions using XACT_ABORT and @@ERROR

• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 300 (Intermediate)
• Length: 11:02 (7.47MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

Note: You must have the TSCC codec installed to view this video