27,579
社区成员
发帖
与我相关
我的任务
分享
insert into a(col1,col5) select '2','456'
if OBJECT_ID ('a') is not null
drop table a
go
create table a (col1 int,col2 int,col3 int,col4 int,col5 int)
go
insert into a select 2,'','','',456
go
select * from a
col1 col2 col3 col4 col5
----------- ----------- ----------- ----------- -----------
2 0 0 0 456
(1 行受影响)
insert into a(col1,col5) select '2','456'
declare @t table(col1 int,col2 varchar(10))
insert @t select '12','13'
union all select 12,13
select * from @t
col1 col2
----------- ----------
12 13
12 13
(2 行受影响)
但不管怎样,两种都行,SQL会隐式转换.insert into a(col1,col5) select 2,456
看楼主的题目,不是楼上那样,就是这样了