Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

by Forta, Ben

• ISBN13: 9780672328671
• ISBN10: 0672328674
• Edition: 1st
• Format: Paperback
• Copyright: 2007-08-02
• Publisher: Sams Publishing

Summary

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutesoffers straightforward, practical answers when you need fast results. By working through 10-minute lessons, yours"ll learn everything you need to know to take advantage of Microsoft SQL Serverrs"s T-SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more. Yours"ll learn what you need to know methodically, systematically, and simplyin highly focused lessons designed to make you immediately and effortlessly productive. Tips point out shortcuts and solutions Cautions help you avoid common pitfalls Notes explain additional concepts, and provide additional information 10 minutes is all you need to learn how tohellip; Use T-SQL in the Microsoft SQL Server environment Construct complex T-SQL statements using multiple clauses and operators Filter data so you get the information you need quickly Retrieve, sort, and format database contents Join two or more related tables Make SQL Server work for you with globalization and localization Create subqueries to pinpoint your data Automate your workload with triggers Create and alter database tables Work with views, stored procedures, and more Register your book at www.samspublishing.com/register to download examples and source code from this book. Category: Databases/Microsoft SQL Server Covers: Microsoft SQL Server T-SQL User Level: Beginning-Intermediate $19.99 USA / $22.99 CAN / pound;10.99 Net UK

Author Biography

Ben Forta is Adobe Systems’s Senior Technical Evangelist and has over 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the bestselling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into more than a dozen languages), MySQL Crash Course, ColdFusion Web Application Construction Kit and Advanced ColdFusion Development (both published by Que), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, WAP, Windows 2000, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs, and is a frequent lecturer and columnist on Internet and database technologies. Born in London, England, and educated in London, New York, and Los Angeles, Ben now lives in Oak Park, Michigan with his wife Marcy and their seven children. Ben welcomes your email at [e-mail], and invites you to visit his website at http://www.forta.com/.

Table of Contents

Understanding SQL	p. 5
Introducing SQL Server	p. 13
Working with SQL Server	p. 19
Retrieving data	p. 27
Sorting retrieved data	p. 37
Filtering data	p. 45
Advanced data filtering	p. 53
Using wildcard filtering	p. 61
Creating calculated fields	p. 69
Using data manipulation functions	p. 79
Summarizing data	p. 91
Grouping data	p. 101
Working with subqueries	p. 111
Joining tables	p. 123
Creating advanced joins	p. 137
Combining queries	p. 149
Full-text searching	p. 157
Inserting data	p. 171
Updating and deleting data	p. 181
Creating and manipulating tables	p. 187
Using views	p. 199
Programming with T-SQL	p. 209
Working with stored procedures	p. 223
Using cursors	p. 235
Using triggers	p. 243
Managing transaction processing	p. 251
Working with XML	p. 259
Globalization and localization	p. 269
Managing security	p. 279
Improving performance	p. 287
Getting started with SQL Server and T-SQL	p. 291
The example tables	p. 295
T-SQL statement syntax	p. 303
SQL datatypes	p. 309
T-SQL reserved words	p. 315
Table of Contents provided by Blackwell. All Rights Reserved.

Excerpts

= 0) {slash = '\\';} else {slash = '/';}openLoc = figLoc.substring(0, figLoc.lastIndexOf(slash) + 1);while (pPage.substring(0,3) == '../') {openLoc = openLoc.substring(0, openLoc.lastIndexOf(slash, openLoc.length - 2)+ 1);pPage = pPage.substring(3, pPage.length + 1);}popUpWin =window.open('','popWin','resizable=1,scrollbars=1,location=0,toolbar=0,width=525,height=394');figDoc = popUpWin.document;zhtm= ' ' + pPage + ' ';zhtm += ' ';zhtm += ' ';zhtm += ' ';zhtm += '' + pPage.substring(pPage.lastIndexOf('/') + 1, pPage.length) + '';zhtm += ' ';figDoc.write(zhtm);figDoc.close();}// modified 3.1.99 RWE v4.1 --> Introduction IntroductionMicrosoftreg; SQL Server has become one of the most popular database management systems in the world. From small development projects to some of the best-known and most prestigious sites on the Web, SQL Server has proven itself to be a solid, reliable, fast, and trusted solution to all sorts of data-storage needs.This book is based on my best-selling book Sams Teach Yourself SQL in 10 Minutes, which has become one of the most-used SQL tutorials in the world, with an emphasis on teaching what you really need to know, methodically, systematically, and simply. But as popular and as successful as that book is, it does have some limitations:In covering all the major DBMSs, coverage of DBMS-specific features and functionality had to be kept to a minimum.To simplify the SQL taught, the lowest common denominator had to be found; SQL statements that would (as much as possible) work with all major DBMSs. This requirement necessitated that better DBMS-specific solutions not be covered.Although basic SQL tends to be rather portable between DBMSs, more advanced SQL most definitely is not. As such, that book could not cover advanced topics, such as triggers, cursors, stored procedures, access control, transactions, and more in any real detail.And that is where this book comes in. Sams Teach Yourself Microsoft reg; SQL Server T-SQL in 10 Minutes builds on the proven tutorials and structure of Sams Teach Yourself SQL in 10 Minutes, without getting bogged down with anything but Transact-SQL (T-SQL, for short). It starts with simple data retrieval and works on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more. You'll learn what you need to know methodically, systematically, and simply in highly focused lessons designed to make you immediately and effortlessly productive.Note: Written for SQL Server 2005 -This book was written with SQL Server 2005 in mind, and covers features and technologies n