02 TSQL v4

Information about 02 TSQL v4

Published on November 29, 2007

Author: brod

Source: authorstream.com

Content

UTS Short Course SQL Server 2005 for Developers :  UTS Short Course SQL Server 2005 for Developers Course Website:  Course Website http://us.ssw.com.au/ssw/events/2007SQL/ Course Timetable Course Materials About Justin:  About Justin Senior Software Architect for www.ssw.com.au – C# Developer working in ASP.NET and Winforms. Java background using Swing with Hibernate Working with new technologies WPF, WCF and Visual Studio Team System 2008 Email: [email protected] Blog: http://kingjustin.com Session 2: T-SQL Enhancements:  Session 2: T-SQL Enhancements What Will We Cover?:  What Will We Cover? New Data Types DDL Triggers Ranking Functions CTE (Common Table Expressions) TOP %, XML Queries Exception Handling PIVOT/UNPIVOT Session 2: T-SQL Enhancements New Data Types :  New Data Types XML – Use Xquery to query, first class data type e.g Create Table candidates(id int, Resume XML); Select Id, Resume.query(‘\\Education’) FROM Candidates; varchar(max)/nvarchar(max) Large, recommended over TEXT going forward (2gig data in single column) and can index. Comparisons, triggers, concatenation, aggregates. Previously 8K limit for entire table (3 X varchar(3000) so would go TEXT columns) Varbinary(max) – replacement for image columns , up to 2GIG   Can create CLR types as well. DDL Triggers:  DDL Triggers Ranking Functions:  Ranking Functions PIVOT:  PIVOT CTE (Common Table Expression) Before:  CTE (Common Table Expression) Before CTE (Common Table Expressions) After:  CTE (Common Table Expressions) After More features:  More features Session 2 Lab :  Session 2 Lab T-SQL Enhancements Download from Course Materials Site (to copy/paste scripts) or type manually: http://us.ssw.com.au/ssw/events/2007SQL/ Where Else Can I Get Help?:  Free chats and TechEd webcasts List of newsgroups Microsoft community sites Community events and columns Where Else Can I Get Help? www.microsoft.com/technet/community

Related presentations


Other presentations created by brod

So You Think Can Sell Candy Quiz
05. 11. 2007
0 views

So You Think Can Sell Candy Quiz

Follow the Yellow Brick Road
19. 02. 2008
0 views

Follow the Yellow Brick Road

08 turkey
23. 11. 2007
0 views

08 turkey

EAF0112
03. 10. 2007
0 views

EAF0112

lect 18 groundwater
09. 10. 2007
0 views

lect 18 groundwater

Stress BSPIN
03. 12. 2007
0 views

Stress BSPIN

hugh mc enaney
04. 12. 2007
0 views

hugh mc enaney

Administrative Notes
06. 12. 2007
0 views

Administrative Notes

Muertos
05. 11. 2007
0 views

Muertos

Disney01
12. 11. 2007
0 views

Disney01

BMI1 FS05 Class09 MRI Theory
14. 11. 2007
0 views

BMI1 FS05 Class09 MRI Theory

inv button animal
16. 11. 2007
0 views

inv button animal

COP4331 Debugger
27. 11. 2007
0 views

COP4331 Debugger

osofsky slides
05. 11. 2007
0 views

osofsky slides

robot Final
31. 12. 2007
0 views

robot Final

Citizens Academy
01. 01. 2008
0 views

Citizens Academy

fast flux 0 2
28. 11. 2007
0 views

fast flux 0 2

Wyse 42706
07. 01. 2008
0 views

Wyse 42706

003
21. 11. 2007
0 views

003

c2 Criptografia
05. 01. 2008
0 views

c2 Criptografia

Mars Orbit Rendezvous
06. 11. 2007
0 views

Mars Orbit Rendezvous

CopyrightClass04 s08
27. 02. 2008
0 views

CopyrightClass04 s08

1142
28. 02. 2008
0 views

1142

frangi
03. 01. 2008
0 views

frangi

BGU HIT
04. 03. 2008
0 views

BGU HIT

0405BioterrorismMatt hews
11. 03. 2008
0 views

0405BioterrorismMatt hews

CNIBLibraryServices
12. 03. 2008
0 views

CNIBLibraryServices

CarTracker
14. 03. 2008
0 views

CarTracker

Lisbon presentation final
18. 03. 2008
0 views

Lisbon presentation final

c05p00026
27. 03. 2008
0 views

c05p00026

Harwood
30. 03. 2008
0 views

Harwood

Beech Acres Coaching Model
13. 04. 2008
0 views

Beech Acres Coaching Model

AFD 071010 047
05. 11. 2007
0 views

AFD 071010 047

Rapanos FinalVersion
03. 01. 2008
0 views

Rapanos FinalVersion

serey
19. 11. 2007
0 views

serey

prednaska03
28. 11. 2007
0 views

prednaska03

RicardoGralhoz Seminario2
29. 12. 2007
0 views

RicardoGralhoz Seminario2

The Santa Ana Mountains
02. 10. 2007
0 views

The Santa Ana Mountains

hokudai
15. 11. 2007
0 views

hokudai

Korbel Volker visit Moscow
27. 09. 2007
0 views

Korbel Volker visit Moscow

v comm
30. 12. 2007
0 views

v comm

howell
13. 11. 2007
0 views

howell

cismsem1
02. 11. 2007
0 views

cismsem1

elterninfo rom 2007
01. 10. 2007
0 views

elterninfo rom 2007

Saddleworth Rangers Tour
27. 12. 2007
0 views

Saddleworth Rangers Tour

nnbar cpt
17. 12. 2007
0 views

nnbar cpt