Post reply

SQL to T-SQL conversion

  • February 6, 2007 at 1:26 am

    #122875

    Hi guys,

    I'm newbie in SQL Server and I have a simple question.

    I instaled MSDE on my machine and then projected my database on SQL Server.

    All I interested in is a way to converse SQL statement

    SELECT DISTINCTROW ...

    FROM ...

    ORDER BY ...

    How to make that conversion?

  • February 6, 2007 at 2:12 am

    #687937

    Check out DISTINCT keyword in Books Online. Also look at the SELECT keyword too! These will help you with the basics.


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • February 6, 2007 at 6:20 am

    #688002

    What is that you are trying to do.

    You can use the basic syntax

    SELECT DISTINCT <ColumnName>

    FROM

    <TableName>

    ORDER BY

    <ColumnName> <SortOrder>

     

     

    Prasad Bhogadi
    www.inforaise.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply