1表名:SIMCARDINFO
字段: MOBILE, OPENTIME, STATE
类型:nvarchar(15), char(10), char(1)2表名:carterm
字段:MOBILE, BEGINTIME, TERMTYPE
类型:nvarchar(15), char(10), char(1)
数据:12345678911 2008-10-20 0
12345678912 2008-10-25 0
12345678913 2008-10-30 1查出表carterm中TERMTYPE='0'的数据后,把数据导入到表SIMCARDINFO中,
导入形式:carterm.MOBILE->SIMCARDINFO.MOBIEL
carterm.BEGINTIME->SIMCARDINFO.OPENTIME
SIMCARDINFO.STATE='1'(不变值)
实现SIMCARDINFO表中数据如下:
MOBILE OPENTIME STATE
12345678911 2008-10-20 1
12345678912 2008-10-25 1
字段: MOBILE, OPENTIME, STATE
类型:nvarchar(15), char(10), char(1)2表名:carterm
字段:MOBILE, BEGINTIME, TERMTYPE
类型:nvarchar(15), char(10), char(1)
数据:12345678911 2008-10-20 0
12345678912 2008-10-25 0
12345678913 2008-10-30 1查出表carterm中TERMTYPE='0'的数据后,把数据导入到表SIMCARDINFO中,
导入形式:carterm.MOBILE->SIMCARDINFO.MOBIEL
carterm.BEGINTIME->SIMCARDINFO.OPENTIME
SIMCARDINFO.STATE='1'(不变值)
实现SIMCARDINFO表中数据如下:
MOBILE OPENTIME STATE
12345678911 2008-10-20 1
12345678912 2008-10-25 1
select MOBILE,BEGINTIME,1
from carterm
where TERMTYPE='0'
兄弟帮我看看,谢谢~
http://topic.csdn.net/u/20090205/13/066259ca-ba82-4cb1-8ef3-37a009d22dd1.html