home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,361 of 19,505   
   Gene Wirchenko to esquel@sommarskog.se   
   Re: problem from proc call and autoincre   
   13 Jun 11 07:28:42   
   
   From: genew@ocis.net   
      
   On Mon, 13 Jun 2011 07:23:03 +0000 (UTC), Erland Sommarskog   
    wrote:   
      
   >white_ideal (whiteideal@gmail.com) writes:   
   >> 1. how to get the autoincreasing identity immediately after inserting   
   >> a row? I how you can give me the answer within mysql and sqlserver.   
   >   
   >In SQL Server, use scope_identity(), which must be in the same batch as the   
   >INSERT statement.   
   >   
   >For MySQL, you need to ask in an MySQL forum.   
   >   
   >> 2. why the following code is error with "invalid cursor state"?   
   >>           the source code is like this.   
   >   
   >I will have to admit that I have never seen this OTL before.   
                                                     ^^^   
        What is this abbrev, please?   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca