我需要将sql server中saletable的数据导入到access中的record表中,record表中有一个record_id自动编号字段(主键),请问使用sql server“导入导出数据”功能,下面这段语句该怎么修改?select convert(char(10),日期,120) as 日期, convert(char(8),时间,114) as 时间,工号, 流水号,单序号,金额,收银员,备注,原机号, 原流水号,原单序号 into record(record_riqi,record_shijian, record_gonghao ,record_liushuihao,record_danxuhao,record_jine ,record_shouyinyuan,record_beizhu,record_yuanjihao ,record_yuanliushuihao,record_yuandanxuhao) from temp.dbo.saletable
select id=identity(int,1,1),convert(char(10),日期,120) as 日期, convert(char(8),时间,114) as 时间,工号, 流水号,单序号,金额,收银员,备注,原机号, 原流水号,原单序号 into record(id,record_riqi,record_shijian, record_gonghao ,record_liushuihao,record_danxuhao,record_jine ,record_shouyinyuan,record_beizhu,record_yuanjihao ,record_yuanliushuihao,record_yuandanxuhao) from temp.dbo.saletable
另外,应该这样: select id=identity(int,1,1),convert(char(10),日期,120) as 日期, convert(char(8),时间,114) as 时间,工号, 流水号,单序号,金额,收银员,备注,原机号, 原流水号,原单序号 into record from temp.dbo.saletable
select
convert(varchar(30),getdate(),120),
convert(varchar(10),getdate(),108)/*
2007-11-07 10:35:44
10:35:44
*/
select convert(char(8),getdate(),114)
带毫秒数:
select convert(char(12),getdate(),114)
convert(char(8),时间,114) as 时间,工号,
流水号,单序号,金额,收银员,备注,原机号,
原流水号,原单序号
into record(record_riqi,record_shijian, record_gonghao
,record_liushuihao,record_danxuhao,record_jine
,record_shouyinyuan,record_beizhu,record_yuanjihao
,record_yuanliushuihao,record_yuandanxuhao)
from temp.dbo.saletable
convert(char(8),时间,114) as 时间,工号,
流水号,单序号,金额,收银员,备注,原机号,
原流水号,原单序号
into record(id,record_riqi,record_shijian, record_gonghao
,record_liushuihao,record_danxuhao,record_jine
,record_shouyinyuan,record_beizhu,record_yuanjihao
,record_yuanliushuihao,record_yuandanxuhao)
from temp.dbo.saletable
另外,应该这样:
select id=identity(int,1,1),convert(char(10),日期,120) as 日期,
convert(char(8),时间,114) as 时间,工号,
流水号,单序号,金额,收银员,备注,原机号,
原流水号,原单序号
into record
from temp.dbo.saletable
select convert(char(10),getdate(),114)
2004/09/12 select CONVERT(varchar(12) , getdate(), 112 )
20040912 select CONVERT(varchar(12) , getdate(), 102 )
2004.09.12 select CONVERT(varchar(12) , getdate(), 101 )
09/12/2004 select CONVERT(varchar(12) , getdate(), 103 )
12/09/2004 select CONVERT(varchar(12) , getdate(), 104 )
12.09.2004 select CONVERT(varchar(12) , getdate(), 105 )
12-09-2004 select CONVERT(varchar(12) , getdate(), 106 )
12 09 2004 select CONVERT(varchar(12) , getdate(), 107 )
09 12, 2004 select CONVERT(varchar(12) , getdate(), 108 )
11:06:08 select CONVERT(varchar(12) , getdate(), 109 )
09 12 2004 1 select CONVERT(varchar(12) , getdate(), 110 )
09-12-2004 select CONVERT(varchar(12) , getdate(), 113 )
12 09 2004 1 select CONVERT(varchar(12) , getdate(), 114 )
11:06:08.177