SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    oracle to SQLServer query (returning columns that don't exist)

    I'm converting a 782 line query from Oracle specific to SQLServer specific.

    I've already figured out several syntactical differences and have worked these out. the only one that has me stumped right now is the following:

    select name, age, 0 employer
    from abcStorage;

    the zero in front of the column "employer" I guess makes these values nulls, but on top of that it doesn't exist in the table.
    HOW DO I DO THIS IN TRANSACT-SQL WHICH IS USED IN SQL SERVER?


    THANKS!

  2. #2
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    answer!



    page 105 of
    Special Edition USING SQL copyright 2000

    you would rewrite that as:
    0 as Employer,




    dlg


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •