New Transact SQL Video Tutorial: Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions

Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions - view details

This video continues our discussion of SET commands and how they work within/outside-of stored procedures. This video also has an excellent discussion of using brackets and double quotes to delimit objects with spaces and/or reserved keywords in the name. Should You Use Brackets or Double-Quotes to delimit objects? In other words, should you use [Order Details] or "Order Details"?

Note: This video was shot on SQL Server 2005 but the concepts are the same for SQL Server 2000.

Highlights from this video:

• Using SET NOCOUNT ON inside stored procedures and triggers
• DBCC USEROPTIONS
• Discussion of Quoted Identifiers and SET QUOTED_IDENTIFIERS ON/OFF
• Object delimiters and when to use double quotes instead of single quotes
• Hierarchy of settable options: database-level, connection-level, stored procedures/triggers, hints
• Using the SQL Server Management Studio (SSMS) to view and change database-level connection options
• How to change connection-level options
• How the Query Analyzer and SSMS use connection-level options

• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 200 (Beginner - Intermediate)
• Length: 14:39 (10.8MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

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