create table cjf
( aa int
)
insert into cjf
values(1)
go
insert into cjf
values(2)
go
insert into cjf
values(2)
好像没有其它的方法吧?
( aa int
)
insert into cjf
values(1)
go
insert into cjf
values(2)
go
insert into cjf
values(2)
好像没有其它的方法吧?
MSSQL应该可以象orcale那样多个values一起提交吧!我在某本书见过可以的呀,难道我被唬了?!!
( aa int
)declare @t int
set @t=1
while @t<=1000
begin
insert into cjf
values
(@t)
set @t=@t+1
end
因为多个记录是由客户端提交上来的,不是从其他表读出,所以无法用select ...insert...语句
insert into cjf (SELECT 1 AS A UNION SELECT 2 AS B UNION SELECT 3 AS C UNION SELECT 4 AS D)
试试
如不行就是cjf 和 SELECT 1 的字段和字段类型不对,就是这种思路了,试试看,一定能行的,我做过实验,在SQL SERVER 2000下