擅长:python、mysql、java
<p>您可以在一个批处理语句中执行此操作:</p>
<pre><code>declare @key as int;
insert into users (username)
values ('malcom.reynolds');
set @key = (select scope_identity());
insert into spaceships (name, owner)
values ('Serenity', @key)
</code></pre>