MS SQL Server
  Home arrow MS SQL Server arrow A Brief Introduction to Transact-SQL
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Silverlight  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
ASP Web Hosting  
ASP.NET Web Hosting 
Windows Web Hosting
 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MS SQL SERVER

A Brief Introduction to Transact-SQL
By: Barzan "Tony" Antal
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 8
    2007-12-18

    Table of Contents:
  • A Brief Introduction to Transact-SQL
  • Usage of Variables
  • Control of Flow Mechanisms
  • Looping Sequences

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    A Brief Introduction to Transact-SQL


    (Page 1 of 4 )

    Transact-SQL is Microsoft’s and Sybase’s proprietary extension to the conventional SQL (structured query language). Transact-SQL is sometimes abbreviated as T-SQL. This enhancement brought procedural programming language functionalities, such as local variables, control-of-flow constructs, and additional functions for various needs.

    The purpose of this two-part article is to give a brief overview on the usage of T-SQL. If you are already familiar with any SQL flavor, whether it's MySQL, Oracle, or perhaps SQL-92, that’s a huge benefit. However, throughout this article I will assume that you have at least some knowledge regarding relational databases.

    We’re going to cover the following programming concepts:

    • Usage of variables (data types, etc.)

    • Conditional statements (IF…ELSE, BEGIN…END)

    • Usage of CASE command

    • Usage of WHILE loops

    • CONTINUE command

    • BREAK command

    • GOTO command

    • RETURN command

    • WAITFOR command

    • Usage of cursors

    • Usage of functions

    • Creating functions of your own


    Now that I’ve given you a sense of what to expect, let’s begin!

    More MS SQL Server Articles
    More By Barzan "Tony" Antal


       · You've just finished reading the first part of my T-SQL series. Please don't forget...
     

    MS SQL SERVER ARTICLES

    - Windows Server 2008 as a Workstation OS
    - An Overview of Windows Server 2008 R2
    - LINQ to MySQL, Oracle and PostgreSQL Provide...
    - Completing the Introduction to Transact-SQL
    - A Brief Introduction to Transact-SQL
    - Lookups and Blocking Bad Data
    - Field Validation Rules for Blocking Bad Data
    - Using Masks to Block Bad Data
    - Blocking Bad Data
    - Using @@ROWCOUNT and TABLE Variables for Dat...
    - How to Use Variables, IF and CASE in Databas...
    - Creating Important Aspects of Notification S...
    - Working wth Variables in Database Interactio...
    - Delving Deeper into Notification Services
    - Notification Services





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway
    Stay green...Green IT