Posted on 2007-10-01
Last Modified: 2010-05-18
What is new regarding pl/sql in sql server 2005.
Question by:Mehram
    LVL 14

    Accepted Solution

    this is more generic question
    you can check the new features here...
    LVL 14

    Expert Comment

    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.
    LVL 75

    Assisted Solution

    by:Aneesh Retnakaran
    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

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now