create proc InsertIntoNewsImage
@nimagefalsename varchar(50),
@nimagetruename varchar(50)
as
declare @nid int
set @nid = select @@IDENTITY
insert into newsImage(nid,nimagefalsename,nimagetruename) values(@nid,@nimagefalsename,@nimagetruename)
@nimagefalsename varchar(50),
@nimagetruename varchar(50)
as
declare @nid int
set @nid = select @@IDENTITY
insert into newsImage(nid,nimagefalsename,nimagetruename) values(@nid,@nimagefalsename,@nimagetruename)
@nimagefalsename varchar(50),
@nimagetruename varchar(50)
as
declare @nid int
set @nid = @@IDENTITY
insert into newsImage(nid,nimagefalsename,nimagetruename) values(@nid,@nimagefalsename,@nimagetruename)
declare @nid int
set @nid = select @@IDENTITY
insert into newsImage(nid,nimagefalsename,nimagetruename) values(@nid,@nimagefalsename,@nimagetruename)
-->insert into newsImage(nimagefalsename,nimagetruename) values(@nimagefalsename,@nimagetruename)
如果想实现自动增长可以使用如下语句
insert into newsImage(nid,nimagefalsename,nimagetruename) select sum(nid)+1,@nimagefalsename,@nimagetruename from newsImage