Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

Transact SQL


1. 

Microsoft® SQL Server® 2012 T-SQL Fundamentals

Microsoft® SQL Server® 2012 T-SQL Fundamentals

By: 

Publisher: Microsoft Press

Publication Date: 05-JUL-2012

Insert Date: 05-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator....

2. 

Beginning T-SQL 2012

Beginning T-SQL 2012

By: Scott Shaw; Kathi Kellenberger

Publisher: Apress

Publication Date: 04-JUL-2012

Insert Date: 03-JUL-2012

Slots: 1.0

Table of Contents • Start Reading

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft's SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL 2012 starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques. Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent...

3. 

Beginning Transact-SQL with SQL Server 2000 and 2005

Beginning Transact-SQL with SQL Server 2000 and 2005

By: 

Publisher: Wrox

Publication Date: 31-OCT-2005

Insert Date: 21-APR-2012

Slots: 1.0

Table of Contents • Start Reading

Beginning Transact-SQL with SQL Server 2000 and 2005 Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases. Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of...

4. 

Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008

Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008

By: 

Publisher: Wrox

Publication Date: 10-DEC-2008

Insert Date: 23-MAR-2011

Slots: 1.0

Table of Contents • Start Reading

If you have never programmed with T-SQL but have some background programming knowledge and experience, Beginning T-SQL with Microsoft SQL Server 2005 and 2006 will provide you with an overview of SQL Server query operations and tools used with T-SQL, Microsoft's implementation of the SQL database query language. Review basic query language commands and syntax, learn how to design and build applications, and understand how to optimize query performance. Improve your skills with the most up-to-date T-SQL guide, which provides hands-on examples and instructions to guide you through the...

5. 

Transact-SQL Desk Reference

Transact-SQL Desk Reference

By: 

Publisher: Prentice Hall

Publication Date: 10-NOV-2003

Insert Date: 07-DEC-2004

Slots: 1.0

Table of Contents • Start Reading

This is the SQL reference you'll reach for first, every time! If you're an SQL programmer, you can easily picture how useful a comprehensive, single-volume Transact-SQL command reference manual would be in streamlining your work. And if that book was rich in examples, was written with users of all levels of expertise in mind, and was even designed to fit comfortably on your desktop, you'd probably buy it right away, wouldn't you? Well, look no further—Transact-SQL Desk Reference, by noted programming instructor Deac Lancaster, is exactly the book you need. As it turns out, Transact-SQL...

6. 

Transact-SQL Cookbook

Transact-SQL Cookbook

By: ;

Publisher: O'Reilly Media, Inc.

Publication Date: 19-MAR-2002

Insert Date: 27-SEP-2002

Slots: 1.0

Table of Contents • Start Reading

This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution. SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL...

7. 

Sams Teach Yourself Transact-SQL in 21 Days, Second Edition

Sams Teach Yourself Transact-SQL in 21 Days, Second Edition

By: Lowell Mauer; David Solomon; Bennett McEwan

Publisher: Sams

Publication Date: 08-MAR-2001

Insert Date: 25-SEP-2002

Slots: 1.0

Table of Contents • Start Reading

Sams Teach Yourself Transact-SQL in 21 Days, 2E will teach programmers how to develop Transact-SQL queries. There will be a focus on providing methods for improving productivity without a reducing performance. Specifically, the reader will:Learn Transact-SQL syntax Learn how to add, delete, and modifying data using Transact-SQL Understand coding standards Review variations from ANSI-standard SQL Be presented with basic server operations. Recognize performance issues with queries. This book will also include:Constructs such as CUBE, ROLLUP, CASE, and JOIN. Techniques to solve complex problems...