New SQL SERVER 2005

What is new regarding pl/sql in sql server 2005.
MehramAsked:
Who is Participating?
 
Jai STech ArchCommented:
this is more generic question
you can check the new features here...
www.microsoft.com/sql/prodinfo/features/top30features.mspx 
0
 
Jai STech ArchCommented:
Transact-SQL Enhancements
 SQL Server 2005 provides new language capabilities for developing scalable database applications. These enhancements include error handling, recursive query capabilities, relational operator PIVOT, APPLY, ROW_NUMBER and other row ranking functions, and more.
 
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
first of all, PL/SQL is the sql extension used in Oracle and in SQL Server the same is called  T-SQL (Transact SQL )
New features
new datatypes - Nvarchar(Max)/ varchar(max)/ varbinary(Max) ,XML
New exception handling Try catch
PIVOT /Unpivot , top @n  operations,  CTEs
http://sequelserver.blogspot.com/2007/05/t-sql-enhancements-in-sql-server-2005.html
http://sequelserver.blogspot.com/2007/05/enhancements-of-existing-features-in.html
http://sequelserver.blogspot.com/2007/05/new-features-common-table-expressions.html
http://sequelserver.blogspot.com/2007/05/new-features-pivot-and-unpivot.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.