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

  • 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.  Tutorial

  • 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.  Tutorial

  • 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.  Tutorial

  • 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.  Tutorial

  • 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 s...  Tutorial

  • 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 T-SQL...  Tutorial

  • T-SQL Learning Guide

    Transact-SQL (T-SQL) is no stranger to the SQL Server developer or DBA, but that's no excuse not to become more familiar. Improve your T-SQL skills with these T-SQL overviews, best practices and stored procedures.  Learning Guide

  • Visual Studio debug windows

    Visual Studio provides you with many informative debug windows, which you can review in this T-SQL stored procedure debugging feature.  Feature

  • How to run the stored procedure

    By stepping into a stored procedure, you are essentially telling Visual Studio to start running the procedure line by line.  Feature

  • Where to start debugging the stored procedure

    Learn how to prepare to debug a stored procedure from Visual Studio 2005.  Feature

Back to top