Chapter 13. Advanced T-SQL

By now you really are becoming proficient in SSE and writing code to work with the data and the objects within the database. Already you have seen some T-SQL code and encountered some scenarios that have advanced your skills as a T-SQL developer. You can now look at more advanced areas of T-SQL programming to round off your knowledge and really get you going with queries that do more than the basics.

This chapter will cover the occasions when you need a query within a query, known as a subquery. This is ideal for producing a list of values to search for or for producing a value from another table to set a column or a variable with. It is also possible to create a transient table of data to use within a query, known as ...

Get Beginning SQL Server 2008 Express for Developers: From Novice to Professional now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.