• Both Have SQL = "Structured Query Language" in their names;

    As Far as I know, T-SQL (Transact SQL) is the nickname for Microsoft's version of SQL, as opposed to PL SQL(Oracle's Procedural Language/Structured Query Language) for example.

    bot have different adherences to the ANSI standards for SQL, and both have numerous proprietary extensions to the language as well

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!