Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Embedded SQL Question

  1. #11
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Re: Embedded SQL Question

    And keep in mind that GO kills any local variables that have been declared
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  2. #12
    Join Date
    Mar 2009
    Location
    Cumming, Georgia USA
    Posts
    1,891

    Default Re: Embedded SQL Question

    Yes, changing from DF Auto Increment to Sequences and Constraints in order to port some slow batch processes to SQL for speed.

  3. #13
    Join Date
    Feb 2009
    Location
    Peoria, IL
    Posts
    5,491

    Default Re: Embedded SQL Question

    Come to DISD and I'll show you have to use Auto Increment with Sequences
    Chuck Atkinson

    "No matter how confounding the case, Bob Worsley always finds the quaesitum."

  4. #14
    Join Date
    Mar 2009
    Location
    Cumming, Georgia USA
    Posts
    1,891

    Default Re: Embedded SQL Question

    Already have it working using the sequence in a Default constraint.

  5. #15
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: Embedded SQL Question

    Come to DISD anyway! Lots of great presentations this year - not to mention getting to meet the rich & famous (like Dennis & Stephen).
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

  6. #16

    Default Re: Embedded SQL Question

    Quote Originally Posted by Garret Mott View Post
    not to mention getting to meet the rich & famous (like Dennis & Stephen).
    That actually _is_ why I am going

    --
    Wil

  7. #17
    Join Date
    Mar 2009
    Location
    Cumming, Georgia USA
    Posts
    1,891

    Default Re: Embedded SQL Question

    I met them back in the Dark Ages in Carson City.

  8. #18
    Join Date
    Feb 2009
    Location
    Dallas, TX USA
    Posts
    1,533

    Default Re: Embedded SQL Question

    Would love to see ya Sam, some really good topics this year at DISD!
    Mark

  9. #19
    Join Date
    Mar 2009
    Location
    Cumming, Georgia USA
    Posts
    1,891

    Default Re: Embedded SQL Question

    It would be good to see you also. I think it was Carson City the last time I saw you. Does not look like I will be able to make it. It is still up in the air, but probably not. Hope all of you have a great time.

Page 2 of 2 FirstFirst 12

Posting Permissions

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