 Building a T-SQL Loop
This article discusses building a program loop using T-SQL.
Defining Variables, and IF...ELSE logic
Whether you are building a stored procedure or writing a small Query Analyzer script, you will need to know the basics of T-SQL programming. This article examines defining variables and using the IF...ELSE logic.
Processing Sequentially Through a Set of Records
This article discusses two different ways to process through a set of records one record at a time.
Setting Variables in Calling T-SQL Code While Using sp_executesql
How to use the sp_executesql SP to allow a T-SQL coder to set variables in the calling T-SQL code when executing dynamic T-SQL.
Transact-SQL
The syntax structure and a brief definition of each code element in the four most important statements in Transact-SQL.
Using the CASE Function in T-SQL
This article discusses using the CASE function in a T-SQL SELECT statement.
What's Best for DBAs? GUI or T-SQL Commands?
The pros and cons of using the SQL Server graphical administration tools versus the T-SQL administrative commands.
|
