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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
