Showing posts with label SQL SERVER. Show all posts
Showing posts with label SQL SERVER. Show all posts

Thursday, January 15, 2009

如何由MS SQL ENTERPISE 用手動輸入 NULL 值

MS SQL ENTERPISE 進TABLE 修改時,需要INSERT NULL VALUE, 用 CTRL +'0' 即可

Wednesday, July 25, 2007

SQL SERVER 資料copy 至excel 會亂碼

SQL SERVER : MS SQL 2000 CHT
excel : Windows XP+office 2000 std (hk)
Cause: copy and paste有中文時,某此字會亂碼,經查有 "等符號會造成問題
sol: 在貼上時,選"選擇性貼上",以純文字貼上,即可,如選unicode 會有問題.