insert into #DepartMent select '组长' union all select '助理' union all select '总经理' union all select '员工' union all select '副总经理' union all select '主管' 与insert into table(a,b...) values ('组长','助理' ...) 有什么区别
insert into #DepartMent select '组长' union all select '助理' union all select '总经理' union all select '员工' union all select '副总经理' union all select '主管' 这个 等价于 select '组长' a into #DepartMent union all select '助理' union all select '总经理' union all select '员工' union all select '副总经理' union all select '主管' 构造表+记录 第二个是往已存在表中插入一条记录
insert into #DepartMent select '组长' union all select '助理' union all select '总经理' union all select '员工' union all select '副总经理' union all select '主管' 是插入多行,但每行只插入一列数据... select '组长' union all select '助理' union all select '总经理' union all select '员工' union all select '副总经理' union all select '主管' 就是插入一列多行的数据与insert into table(a,b...) values ('组长','助理' ...) 插入一行多列的数据....
SQL code insert into #DepartMent select '组长' union all select '助理' union all select '总经理' union all select '员工' union all select '副总经理' union all select '主管' 这是插入一个表,相当于insert #DepartMent select * from tb 与insert into table(a,b...) values ('组长','助理' ...)这条语句只是插入一条数据
union all select '助理'
union all select '总经理'
union all select '员工'
union all select '副总经理'
union all select '主管'
这个 等价于
select '组长' a into #DepartMent
union all select '助理'
union all select '总经理'
union all select '员工'
union all select '副总经理'
union all select '主管'
构造表+记录
第二个是往已存在表中插入一条记录
union all select '助理'
union all select '总经理'
union all select '员工'
union all select '副总经理'
union all select '主管' 是插入多行,但每行只插入一列数据...
select '组长'
union all select '助理'
union all select '总经理'
union all select '员工'
union all select '副总经理'
union all select '主管'
就是插入一列多行的数据与insert into table(a,b...) values ('组长','助理' ...)
插入一行多列的数据....
SQL code
insert into #DepartMent select '组长'
union all select '助理'
union all select '总经理'
union all select '员工'
union all select '副总经理'
union all select '主管'
这是插入一个表,相当于insert #DepartMent select * from tb
与insert into table(a,b...) values ('组长','助理' ...)这条语句只是插入一条数据