Results 1 to 4 of 4

Thread: select @@identity

  1. 11-06-2000, 01:45 PM #1
    resh Guest

    select @@identity


    i am getting an 'Incorrect syntax' error while setting @@identity into a variable

    declare @vcount int
    set @vcount =Select @@identity

    can someone help me?

    regards,
    Reply With Quote Reply With Quote
  2. 11-06-2000, 02:43 PM #2
    Jim W Guest

    select @@identity (reply)

    Try set @vcount = @@identity

    or

    select @vcount = @@identity




    ------------
    resh at 11/6/00 1:45:38 PM


    i am getting an 'Incorrect syntax' error while setting @@identity into a variable

    declare @vcount int
    set @vcount =Select @@identity

    can someone help me?

    regards,
    Reply With Quote Reply With Quote
  3. 11-06-2000, 02:44 PM #3
    Jim W Guest

    select @@identity (reply)

    Try set @vcount = @@identity

    or

    select @vcount = @@identity




    ------------
    resh at 11/6/00 1:45:38 PM


    i am getting an 'Incorrect syntax' error while setting @@identity into a variable

    declare @vcount int
    set @vcount =Select @@identity

    can someone help me?

    regards,
    Reply With Quote Reply With Quote
  4. 11-06-2000, 02:44 PM #4
    Jim W Guest

    select @@identity (reply)

    Try set @vcount = @@identity

    or

    select @vcount = @@identity




    ------------
    resh at 11/6/00 1:45:38 PM


    i am getting an 'Incorrect syntax' error while setting @@identity into a variable

    declare @vcount int
    set @vcount =Select @@identity

    can someone help me?

    regards,
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules