Groups > comp.databases.ms-sqlserver > #446

Re: problem from proc call and autoincreasing key in using otl

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: problem from proc call and autoincreasing key in using otl
Date	2011-06-13 07:28 -0700
Organization	A noiseless patient Spider
Message-ID	<5k7cv6hqdgpe2tpumpthql120cict2gob5@4ax.com> (permalink)
References	<3c4bb9a9-97ed-4a95-9982-2afd993017bd@34g2000pru.googlegroups.com> <Xns9F035F76A937CYazorman@127.0.0.1>

Show all headers | View raw

On Mon, 13 Jun 2011 07:23:03 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> 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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-12 17:08 -0700
  Re: problem from proc call and autoincreasing key in using otl Erland Sommarskog <esquel@sommarskog.se> - 2011-06-13 07:23 +0000
    Re: problem from proc call and autoincreasing key in using otl Gene Wirchenko <genew@ocis.net> - 2011-06-13 07:28 -0700
      Re: problem from proc call and autoincreasing key in using otl Erland Sommarskog <esquel@sommarskog.se> - 2011-06-13 23:59 +0200
        Re: problem from proc call and autoincreasing key in using otl Henk van den Berg <me@myplace.net> - 2011-06-14 08:35 +0200
  Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-13 15:13 -0700
    Re: problem from proc call and autoincreasing key in using otl Erland Sommarskog <esquel@sommarskog.se> - 2011-06-14 23:39 +0200
      Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-14 15:36 -0700
        Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-14 17:33 -0700
  Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-14 17:34 -0700

csiph-web