Murach's SQL Server 2005 for Developers
How to code scripts

This chapter shows you how to code scripts consisting of multiple Transact-SQL statements that are executed in sequence.
Chapter 13 How to code scripts
An introduction to scripts 366
How to work with scripts 366
The Transact-SQL statements for script processing 368
How to work with variables and temporary tables 370
How to work with scalar variables 370
How to work with table variables 372
How to work with temporary tables 374
A comparison of the five types of Transact-SQL table objects 376
How to control the execution of a script 378
How to perform conditional processing 378
How to test for the existence of a database object 380
How to perform repetitive processing 382
How to handle errors 384
Advanced scripting techniques 386
How to use the system functions 386
How to change the session settings 388
How to use dynamic SQL 390
A script that summarizes the structure of a database 392
How to use the SQLCMD utility 396
Perspective 398
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.