SQL-Transact SQL (T-SQL) Reference & Learning Page 2 - SearchSQLServer.com

SQL-Transact SQL (T-SQL)

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Problems and justified use of cursors

    The use of cursors in T-SQL should traditionally be avoided when possible, as they are a procedural feature and performace penalties tend to be a problem. However, this excerpt outlines situations in which cursors are acceptable, and even necessary.  Tutorial

  • Special data types-Part 2

    This section continues discussion of special data types, including table and the cursor types and also traditional user-defined data types.  Tutorial

  • Blocks, looping and conditional flow control statements

    Statements blocks (Begin…End) can be used to group several statements to be executed together. Conditional execution (If statements) are used to change the flow of code based on the value of a condition. T-SQL contains only one statement that allows ...  Tutorial

  • Flow control statements

    T-SQL flow-control statements require skill and lack user friendliness, yet they allow for complex procedures. This book excerpt covers the use of comments. Comments can be included inside the source code of a batch or stored procedure. Comments are ...  Tutorial

  • Database object qualifiers

    The name of a database object has four identifiers. These identifiers must comply with the rules for T-SQL identifiers. This is referred to as the object's fully qualified name. The following excerpt outlines the different schemas that can be created...  Tutorial

  • Global variables

    Your SQL Server maintains values in global variables. They carry information specific to the server or user session and can be examined from anywhere and return one value. Get more on this and how global variables begin with the @@ prefix and do not ...  Tutorial

  • T-SQL identifiers

    T-SQL Identifiers are used in all databases, servers and database objects in SQL Server. Identifiers are assigned to identify and object when it is created, but can be changed after. Rules and tips for creating identifiers are outlined in the followi...  Tutorial

  • Table variables

    Table variables are similar to temporary tables and are declared using the table data type. This following book excerpt contains further explanations and examples for declaring table variables when working T-SQL programming constructs.  Tutorial

  • Local variables

    SQL Server 2005 recognizes only local and table variables. This book except outlines operations such as declaring variables, assigning values with the select, set, or update statement; and displaying values. Also find some workarounds for potential p...  Tutorial

  • Basic Transact-SQL programming constructs: 15 tips, 15 minutes

    The programming language used in Microsoft SQL Server is called Transact-SQL (T-SQL). It complies with the ANSI SQL-92 standard, and you can use this ANSI SQL-compliant language to select, update, insert and delete records from tables.  Book Excerpt