May 4, 2010 at 6:01 am
Hi ! I am in the middle of a Table Expression chapter in a T-SQL book, I can't Understand what is the real life implementation of the Table or View etc. The chapter consists of :
Derived Tables
Common Table Expressions
Views
Inline Table-Valued Functions
The APPLY Operator
Can anyone help me and make me understood or forward some documents or Links where I can downloads materials regarding this topics.
Please help me...
Thanks
Subhro
May 4, 2010 at 6:26 am
Sounds like you're reading Itzik Ben-Gan's book. Excellent resource.
Derived tables are not the same thing as tables. A derived table is a way to use a query construct, such as a view, to act like a table. If you're really just getting started, skip back a few chapters and work your way back up to this one.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 4, 2010 at 6:37 am
Thanks For the Resources.
Subhro
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply