Working wth Variables in Database Interactions with Transact-SQL (Page 1 of 4 )
Quite some time ago, I started a lengthy series on "Database Interactions with PL/SQL." It continues to this day. I have received a lot of feedback from several readers throughout the world. I want to thank all of them for suggesting new topics for me to cover.
You can find the series here. I've received many requests for more information about Transact-SQL programming, but I waited until now to write more because I wanted to upgrade to the latest Microsoft SQL Server 2005 programming first. And now, I am contributing another huge series (though the grouping or titles could be different) totally dedicated to Transact-SQL programming, beginning with the basics and proceeding through the latest and advanced features.
I am assuming that the readers of this series will have some knowledge of RDBMS, SQL and some very fundamental grounding in Transact-SQL (T-SQL) such as data types, variable declarations, control structures (such as conditional statements and loops), executing scripts and so forth. I am trying to keep all of the articles of this series as simple as possible to give beginners a very good start. All of the examples in this series can be executed on the fly just by using copy and paste (unless otherwise specified).
For simplicity, I am still using the classic Northwind database. For installation instructions, you can check out http://www.totaltraining.com/supt/pdf/NorthwindDB.pdf. You can download and attach it for free.
In this article, I shall introduce you to retrieving information from a SQL server database using Transact-SQL variables. The examples in this series were tested on Microsoft SQL Server 2005 on Windows Server 2003 Enterprise Edition (and Windows XP Professional Edition). I didn't really test the examples with any other or previous editions (as I am concentrating on Microsoft SQL Server 2005). If you have any problems with executing the code, please post in the discussion area.
Next: Retrieving data from a database using a T-SQL script >>
More MS SQL Server Articles
More By Jagadish Chaterjee
