select * from table union all '0','0','0','0'--按列多少定 union all '0','0','0','0'
select * from table union all select '0','0','0','0'--按列多少定 union all select '0','0','0','0'
可以吗?其实2楼的0前没有加select
select * from table union all '0','0','0','0'--按列多少定 union all '0','0','0','0'
select * from table union all '0' as 第一个字段的名字,'0'as 第二个字段的名字 union all '0' as 第一个字段的名字,'0'as 第二个字段的名字 如 表 有A,B 字段select * from table union all select '0' as A,'0' as B union all select '0' as A,'0' as B
select * from a union select all '0' from a union all select top 1 '0' from a
union all
'0','0','0','0'--按列多少定
union all
'0','0','0','0'
union all
'0','0','0','0'--按列多少定
union all
'0','0','0','0'
select * from table
union all
'0' as 第一个字段的名字,'0'as 第二个字段的名字
union all
'0' as 第一个字段的名字,'0'as 第二个字段的名字
如 表 有A,B 字段select * from table
union all
select '0' as A,'0' as B
union all
select '0' as A,'0' as B
union select all '0' from a
union all select top 1 '0' from a
select *,'0','0' from Table