Murach's SQL Server 2008 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 392
How to work with scripts 392
The Transact-SQL statements for script processing 394
How to work with variables and temporary tables 396
How to work with scalar variables 396
How to work with table variables 398
How to work with temporary tables 400
A comparison of the five types of Transact-SQL table objects 402
How to control the execution of a script 404
How to perform conditional processing 404
How to test for the existence of a database object 406
How to perform repetitive processing 408
How to handle errors 410
Advanced scripting techniques 412
How to use the system functions 412
How to change the session settings 414
How to use dynamic SQL 416
A script that summarizes the structure of a database 418
How to use the SQLCMD utility 422
t


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

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



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.