一個上午的白工

僅因為 SQL 2008 的 CTP 時,Geography 類型的經緯度的標示是(緯度 經度),但 RC0 之後改為(經度 緯度),今天早上所有的文章重新校對,程式重寫,畫面重抓…一個上午就不見了咬牙切齒

想..微軟自家寫程式的人翻得更兇吧…氣也就消了一大半傷心

3 Comments

  1. Posted 2008 年 08 月 11 日 at 07:24:26 | Permalink | 回覆

    现在从RC0升级到RTM,好像没有什么变化了,幸好啊!另外不知道是不是在RC0中的Merge语法变了,我运行呢一下http://byronhu.spaces.live.com/blog/cns!BF14192BD27975CB!468.entry 中您写的Merge示例,已经是报语法错误了。

  2. 百敬
    Posted 2008 年 08 月 11 日 at 08:38:41 | Permalink | 回覆

    這也是 CTP 與 RC0 的一個差異,但要做的白工實在太多,沒空校對 Blog…
     
    USE tempdbGOCREATE TABLE tbSource(C1 INT PRIMARY KEY,C2 NVARCHAR(10))GOINSERT tbSource VALUES(1,N’甲’),(2,N’乙’)GOSELECT * INTO tbDest FROM tbSource
    DELETE tbSource WHERE c1=1UPDATE tbSource SET c2=N’乙2′ WHERE C1=2INSERT tbSource VALUES(3,N’丙’) GO
    MERGE tbDest D  USING tbSource s  ON D.c1 = S.c1  WHEN MATCHED THEN –修改    UPDATE SET D.c2 = S.c2  WHEN NOT MATCHED BY SOURCE  THEN  –刪除     DELETE  WHEN NOT MATCHED BY TARGET THEN  –新增    INSERT VALUES(c1, c2)    OUTPUT $action, INSERTED.c1 [New c1],                     INSERTED.c2 [New c2],                     DELETED.c1  [Original c1],                    DELETED.c2  [Original c2];

  3. Unknown
    Posted 2008 年 09 月 27 日 at 13:39:39 | Permalink | 回覆

    Hi,Do you need advertising displays, digital signages, mp4 advertisement players, SD card players and advertisement LCD displays? Please go Here:www.amberdigital.com.hk(Amberdigital).we have explored and developed the international market with professionalism. We have built a widespread marketing network, and set up a capable management team dedicated to provide beyond-expectation services to our customers.
    amberdigital Contact Us
    website:www.amberdigital.com.hk
    alibaba:amberdigital.en.alibaba.com[cabiedejafddhf]

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: