select srctermid as phone
,sp_msgsrc=cast('固定的值' as verchar,10))
,serviceid
,serviceid_mx=cast(null as varchar(10)) --要字段类型
,trench=cast(null as varchar(10)) --要字段类型
,flag,createtime into test1
from custdb where flag='1' or flag='0'
,sp_msgsrc=cast('固定的值' as verchar,10))
,serviceid
,serviceid_mx=cast(null as varchar(10)) --要字段类型
,trench=cast(null as varchar(10)) --要字段类型
,flag,createtime into test1
from custdb where flag='1' or flag='0'
space(10) as sp_msgsrc,
serviceid,
null as serviceid_mx ,
null as trench ,
flag,createtime
into test1 from custdb where flag='1' or flag='0'
,convert(varchar(10),sp_msgsrc) sp_msgsrc
,convert(varchar(20),null) serviceid
,convert(varchar(20),null) serviceid_mx ,
,convert(varchar(20),null) trench
,flag
,createtime
into test1
from custdb
where flag='1' or flag='0'