New Transact SQL Video Tutorial: Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them

Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them - view details

SET commands in T-SQL control the environment in which SQL Server or the client processes that client queries. This view shows you some of the more common SET commands, how they work, scoping (are they scoped to the statement, the batch, the connection?), and how you can use SET commands to increase throughput and help increase your SQL knowledge.

---

• Source: Transact SQL videos
• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:44 (7.27MB)
• 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

---

Keywords Associated with this video: SET NOCOUNT ON, OFF, QUOTED_IDENTIFIERS, ANSI_NULLS