MSDN Webcast: Using Transact-SQL for Recursive Queries in SQL Server 2005 (Level 300)

Download Now
(you must be registered)

Date:

23-01-2007
Vendor:

Microsoft
Registration:

Required
Type:

Webcasts
File size:

Not specified
Format:

PDF, Acrobat Reader
Pages:

Not specified

Publisher’s description

Microsoft SQL Server 2005 is the first version of SQL Server that supports recursive queries and implementing a standard recursive Common Table Expression (CTE). This webcast explores recursive CTEs and demonstrates how to use them to answer common requests against graph structures. Using an employee organizational chart as an example of a graph structure, the presenter explains how common requests against graph structures include sub-graphs, all subordinates of a given manager; paths, the management chain of a given employee; and presentation, the sorting and indentation of information.

Hewlett Packard
Save up to 50% on an extended HP PC warranty.

Upload your whitepaper now

Latest Videos

Play now

Malcolm Turnbull's ghost twitterer
At the Sydney Media140 conference several weeks ago, Opposition Leader Malcolm Turnbull admitted he doesn't pe… Watch it now
Play now

Google Chrome OS demonstration
Vice President of Product Marketing Sundar Pichai gives a virtual tour of Google's new operating system, Chrom… Watch it now
Play now

Surf the Net like it's 1991 with Gopher
The old Gopher protocol is not dead. In fact, it even has Twitter! Here's how to access it.… Watch it now
More videos »

Blogs

Sun shining on Ajnaware
Graham Dawson talks about the future of iPhone app development and augmented reality.
Holiday IT to-do lists
The fast-approaching holiday season is a great time to update your IT systems while everything's quiet.
Chapman's rough end of the pineapple
If I was Alan Chapman, the acting executive director of the Queensland Government Chief Information Office, I'd be really irate right now.
More blogs »

Reader Services

Essentials

Best Servers
Check out the best servers here!
Top Ten Servers
Want to find out what servers are in the top ten? Check here!
Broadband Plan Finder
Not sure which broadband plan to choose? Try our Broadband Plan Finder.
Mobile Phone Plan Finder
Pick the best mobile phone plan deal with our Mobile Phone Plan Finder.
Broadband speedtest
How fast is your Internet connection? Calculate the speed here.

1) Apple iPhone 3GS 32GB	35 plans	16%
2) Apple iPhone 3GS 16GB	35 plans	3%
3) Blackberry Curve 8520	6 plans	1%
4) Apple iPhone 8GB	41 plans	1%
5) Samsung Galaxy Icon	6 plans	1%

1) Apple mobile phones	19%
2) Nokia mobile phones	7%
3) Sony Ericsson mobile phones	3%
4) Samsung mobile phones	4%
5) Blackberry mobile phones	1%

MSDN Webcast: Using Transact-SQL for Recursive Queries in SQL Server 2005 (Level 300)