excel导入记录

use DangJian
SELECT vale1, value2 into Table2 from Table1

select COUNT(*) from tmpdangyuan where 手机号 in (select phone from T_YEWU_User)

select COUNT(1) from T_YEWU_User

delete from tmpyexf where phone in (select phone from T_YEWU_User)

--ELECT vale1, value2 into Table2 from Table1

insert into T_YEWU_User
(Name , Phone,Password,Sex ,Type ,IsBind ,IsDelete ,IsTransfer,SystemID,Dues, Balance ,IsAdmin,[IsLeave],[AutoMoney] ,[Birthday],[JoinTime],[RegularTime])
select

name, phone,'123456',1, 1,0 ,0 ,1 ,systemid ,0 ,0 ,0,0,0 ,'1947-08-23 00:00:00.000', '1967-07-01 00:00:00.000' , '1968-07-01 00:00:00.000'

from tmpyexf



select COUNT(1) from dbo.T_YEWU_User


select top 50 convert(varchar(20),convert(decimal(18,0),手机号)) from tmpdangyuan

update tmpdangyuan set phone =FLOOR(手机号)

update tmpdangyuan set tmpphone='a'+convert(varchar(20),FLOOR(手机号))

SELECT FLOOR(手机号)

select 'a'+convert(varchar(20),FLOOR(13656875943.00))

insert into tmpyexf ( phone,name,number) select convert(varchar(20),convert(decimal(18,0),手机号)),姓名, convert(varchar(20),convert(decimal(18,0),组织编码))
from tmpdangyuan

delete from tmpyexf


select * from tmpdangyuan

update tmpdangyuan set tmpphone=0, phone=''

select convert(varchar(20),convert(decimal(18,0),手机号)) as phone from tmpdangyuan

select CAST(手机号 as decimal) from tmpdangyuan




select top 116602 * from tmpdangyuan where phone =1.36148317581395E+20

delete from tmpdangyuan where 手机号=1.39589719053806E+20

select * from tmpdangyuan where 手机号=1.83587971121835E+21

posted @ 2015-11-17 17:33  叶晓丰  阅读(153)  评论(0编辑  收藏  举报