sqlserver
这么慢那么美
只有想不到的没有做不到的
展开
-
去掉电话号码的区号
IF NOT OBJECT_ID([tb]) IS NULL DROP TABLE [tb]GOCREATE TABLE [tb]([name] NVARCHAR(10),[phone] NVARCHAR(40))INSERT [tb]SELECT a,N010-12345678/0571-86919111 UNION ALLSELECT b,N02原创 2010-04-29 22:15:00 · 1054 阅读 · 0 评论 -
笔记
当天select distinct( a. Agent_code ) as Agent_code, b. Agent_fullname from welldata_result a inner join welldata_agent b on a.agent_code=b.agent_codewhere TIMESTAMPDIFF(day, Risk_time,now())=2(2010-06-30 ,2010-07-02)上一个星期select * from ht_invoice_i原创 2010-07-02 18:06:00 · 536 阅读 · 0 评论