Question

asp.net 插入问题

我要给数据库中的一个表插入一条记录然后返回刚插入记录的id，然后将这个id插入到第二个表中。（第一个表的id是自增长的）求sql语句……
向第一个表插入数据并返回id的sql语句我已经写了
insert into Registration(UserName,Sex,Phone,Email,IdentityCard,Random,[Time],ProId,Remark)
values ('554','766','766','tyjt','79i7yiy','154629','kghkg',3,'utk')
select @@IDENTITY as Id

Answer 1

插入语句:
insert into Registration(UserName,Sex,Phone,Email,IdentityCard,Random,[Time],ProId,Remark)
values ('554','766','766','tyjt','79i7yiy','154629','kghkg',3,'utk')
output inserted.id
这样可以获得插入的id值.你在程序代码中把这个值读到另一变量里,就可以再操作它了.

Answer 2

插入后用
SELECT @@IDENTITY AS 'Identity '

Answer 3

declare @ReturnValue int;
insert into Registration(UserName,Sex,Phone,Email,IdentityCard,Random,[Time],ProId,Remark)
values ('554','766','766','tyjt','79i7yiy','154629','kghkg',3,'utk')
set @ReturnValue = @@IDENTITY;

insert into Registration(Registrationid)values(@ReturnValue );

Answer 4

用这样的语句 SELECT column_name(s)
INTO new_table_name [IN externaldatabase]
FROM old_tablename

Answer 5

灌水