Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Toronto,Canada
    Posts
    27

    Unanswered: Exists and Not exists

    Do we have Exists and Not Exists feature in Sybase isql? If yes, do they work same way as in Oracle or there any syntactical difference

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    T-SQL (the language), not isql (the interactive sql tool)

    Code:
    if [not] exists(select ... from ... where)
       begin
       ...
       end
    else
       begin
       ...
       end

Posting Permissions

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