K'隨手記

以下是SQLSERVER 2000安裝以後內建的說明文件定義的保留字
Reserved Keywords
Here are the reserved keywords for Embedded SQL for C (ESQL/C). Keywords reserved for Transact-SQL are also reserved for ESQL/C. The application can use these keywords in string literals in SQL statements if the literal is enclosed in single quotes.

APPLICATION

FETCH

OPTCCVAL

CALL

FETCHBUFFER

OPTION

CLOSE

FOUND

QUERYTIME

CONCURRENCY

GET

READONLY

CONNECT

HOST

SCROLLOPTION

CONNECTION

IMMEDIATE

SECTION

CUR_BROWSE

INCLUDE

SQLCA

CUR_STANDARD

INDICATOR

SQLDA

CURRENT

KEYSET

SQLERROR

CURSOR

LOCKCC

SQLWARNING

CURSORTYPE

LOGINTIME

USER

DESCRIBE

MIXED

USING

DESCRIPTOR

NOT

WHENEVER

DISCONNECT

OF

WORK

DYNAMIC

OPEN

 

FORWARD

OPTCC

 

如果想快速將SQLSERVER 7.0~ SQLSERVER2000帳號與密碼在不同的主機移轉，可使用微軟KB246133的做法迅速移轉帳號。


1.透過 Query Analyzer使用下列語法建立sp_hexadecimal、sp_help_revlogin兩個預儲程序

由於客戶的主機一直當機且反應系統反應緩慢，檢查了資料庫發現了好多個相同的問題，如圖示
 
經過谷歌大師搜尋一番查到下列文章...