• February 07, 2007 07 Feb'07

    Unconditional and scheduled execution

    Unconditional execution (the GoTo Statement) in T-SQL forces the server to continue the execution from a label within a stored procedure or batch. Scheduled execution (the WaitFor Statement) allows the developer to schedule a time for the remaining ...  Continue Reading

  • February 07, 2007 07 Feb'07

    Character string data types

    There are four different character data types that store character strings: char, varchar, varchar(max), and text. There are also four character data types for storing unicode data: nchar, nvarchar, nvarchar(max) and ntext. This book excerpt on ...  Continue Reading

  • February 07, 2007 07 Feb'07

    Cursor related statements

    This book excerpt illustrates cursor statements, including the open statement, fetch statement, @@fetch_status, close statement and the deallocate statement for T-SQL cursors.  Continue Reading

  • February 07, 2007 07 Feb'07

    Special data types-Part 1

    In book excerpt, special data types are defined, including: timestamp, uniqueidentifier, and cursor and xml data types, a major new feature in SQL Server 2005. User defined data types are also explained, which can be defined in Transact-SQL or .NET.  Continue Reading

  • February 07, 2007 07 Feb'07

    Transact SQL cursors

    T-SQL cursors are used to repeat custom processing for each row of the cursor. The following excerpt outlines how to process a cursor for Transact-SQL Server and gives an example.  Continue Reading

  • February 07, 2007 07 Feb'07

    Date, time and number data types in SQL Server

    In this book excerpt on basic T-SQL programming constructs, date and time, integer numbers, approximate numbers, exact numbers, monetary and binary data types are defined and examples given.  Continue Reading

  • February 07, 2007 07 Feb'07

    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.  Continue Reading

  • February 07, 2007 07 Feb'07

    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...  Continue Reading

  • February 07, 2007 07 Feb'07

    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 ...  Continue Reading

  • February 07, 2007 07 Feb'07

    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 ...  Continue Reading

  • February 07, 2007 07 Feb'07

    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.  Continue Reading

  • February 07, 2007 07 Feb'07

    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 ...  Continue Reading

  • February 07, 2007 07 Feb'07

    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 ...  Continue Reading

  • February 07, 2007 07 Feb'07

    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.  Continue Reading

  • February 07, 2007 07 Feb'07

    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...  Continue Reading

  • February 06, 2007 06 Feb'07

    Security testing for compliance -- just how much do you need?

    Because of government demands, testing your databases and related SQL Server applications for security flaws is no longer simply on the IT wish list. But how much testing is really necessary? IT security specialist Kevin Beaver notes key systems to ...  Continue Reading