• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

New SQL SERVER 2005

What is new regarding pl/sql in sql server 2005.
0
Mehram
Asked:
Mehram
  • 2
2 Solutions
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now