Tricks of the Windows Gam…ming Gurus (2nd Edition)/Disc2.iso/shared/oledb/sqloledb.dll/string.txt

Text File | 1998-06-24 | 19KB | 588 lines

338    alter
339    add
342    create proc
345    Syntax error in translation file %s
346    set implicit_transactions off
347    set implicit_transactions on
348    as
349    null
350    select
351    where
353    SET ROWCOUNT
354    SET NO_BROWSETABLE
355    BEGIN TRAN
356    SET TEXTSIZE
361    char
362    varchar
363    text
364    nchar
365    nvarchar
366    ntext
367    binary
368    varbinary
369    image
370    int
371    smallint
372    tinyint
373    float
374    real
375    numeric
376    money
377    datetime
378    bit
379    timestamp
380    uniqueidentifier
381    smallmoney
382    smalldatetime
397    from
398     holdlock
399     where 1=2
400    create;drop;select;grant;revoke;alter;truncate;update;reconfigure;load;disk;
402    EXEC
403    IF @@TRANCOUNT > 0 COMMIT TRAN
404    IF @@TRANCOUNT > 0 ROLLBACK TRAN
405    select USER_NAME() select usertype,type,name from systypes where usertype>=
406    'INTERVAL %c''%lu'' YEAR(%u)'
407    'INTERVAL %c''%lu'' MONTH(%u)'
408    'INTERVAL %c''%lu'' DAY(%u)'
409    'INTERVAL %c''%lu'' HOUR(%u)'
410    'INTERVAL %c''%lu'' MINUTE(%u)'
411    'INTERVAL %c''%lu%s'' SECOND(%u,%u)'
412    'INTERVAL %c''%lu-%02lu'' YEAR(%u) TO MONTH'
413    'INTERVAL %c''%lu %02lu'' DAY(%u) TO HOUR'
414    'INTERVAL %c''%lu %02lu:%02lu'' DAY(%u) TO MINUTE'
415    'INTERVAL %c''%lu %02lu:%02lu:%02lu%s'' DAY(%u) TO SECOND(%u)'
416    'INTERVAL %c''%lu:%02lu'' HOUR(%u) TO MINUTE'
417    'INTERVAL %c''%lu:%02lu:%02lu%s'' HOUR(%u) TO SECOND(%u)'
418    'INTERVAL %c''%lu:%02lu%s'' MINUTE(%u) TO SECOND(%u)'
419     dbcc traceon(208)
420     set quoted_identifier
421     set ansi_nulls off set ansi_padding off set ansi_warnings off
423    table
424    %04d-%02u-%02u %02u:%02u:%02u.%03lu
439    drop
440    SET PARSEONLY ON
441     SET PARSEONLY OFF
442    SET NOEXEC ON
443     SET NOEXEC OFF
458    '%04d%02u%02u %02u:%02u:%02u.%03lu'
459     select 'English','us_english' union select alias,name from master..syslanguages
460    us_english;franτais;deutsch;
461    select name from master..sysdatabases
464    select ISNULL(language,'us_english') from master..syslogins where suid=SUSER_ID()
466    select dbname from master..syslogins where suid=SUSER_ID()
467    select name from master..sysdatabases where name like '%s' and name <> 'model'
468    select table_qualifier=convert(varchar,'%s'),table_owner=u1.name,table_name=o.name,table_type=rtrim(substring('SYSTEM TABLE            TABLE       VIEW       ',(ascii(o.type)-83)*12+1,12)),remarks=convert(varchar(254),null)
469    from %s..sysusers u,%s..sysusers u1,%s..sysobjects o where o.name like '%s' and u1.name like '%s' and charindex(substring(o.type,1,1),'%s')!=0 and u1.uid=o.uid and(u.suid=suser_id()or(suser_id()=1 and u.uid=1))
470    and(suser_id()=1 or o.uid=u.uid or((select max(((sign(uid)*abs(uid-16383))*2)+(protecttype&1))from %s..sysprotects p where p.id=*o.id and(p.uid=0 or p.uid=*u.uid or p.uid=*u.gid)and(action in (193,224)))&1)=1)union
471    order by table_type, table_qualifier, table_owner, table_name
472    'SYSTEM TABLE'
473    'TABLE'
474    'VIEW'
475    select '%s' from %s..sysusers where suid=suser_id()
476    select c.name from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config in(123,1123) and f.value=c1.id and c1.csid=c.id
478    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
479    SET TRANSACTION ISOLATION LEVEL READ COMMITTED
481    SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
483    identity
484     , =
485    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
486     char      binary      decimal       integer smallint float real double varchar      date     time     timestamp longvarchar varbinary      longvarbinary tinyint bit numeric
487     char(255);binary(255);decimal(38,4);int;    smallint;float;real;float; varchar(255);datetime;datetime;datetime; text;       varbinary(255);image;        tinyint;bit;numeric(38,4);
488     char(255);binary(255);money;        int;    smallint;float;real;float; varchar     ;datetime;datetime;datetime; text;       varbinary     ;image;        tinyint;bit;
489     set numeric_roundabort on
510    avg
511    cnt
512    max
513    min
514    sum
515    order
516    SET FMTONLY ON
517     SET FMTONLY OFF
540    BREAK,BROWSE,BULK,CHECKPOINT,CLUSTERED,COMMITTED,COMPUTE,CONFIRM,CONTROLROW,DATABASE,DBCC,DISK,DISTRIBUTED,DUMMY,DUMP,ERRLVL,ERROREXIT,EXIT,FILE,FILLFACTOR,FLOPPY,HOLDLOCK,IDENTITY_INSERT,IDENTITYCOL,IF,KILL,LINENO,LOAD,MIRROREXIT,
541    NONCLUSTERED,OFF,OFFSETS,ONCE,OVER,PERM,PERMANENT,PLAN,PRINT,PROC,PROCESSEXIT,RAISERROR,READ,READTEXT,RECONFIGURE,REPEATABLE,RETURN,ROWCOUNT,RULE,SAVE,SERIALIZABLE,SETUSER,SHUTDOWN,STATISTICS,
542    TAPE,TEMP,TEXTSIZE,TRAN,TRIGGER,TRUNCATE,TSEQUEL,UNCOMMITTED,UPDATETEXT,USE,WAITFOR,WHILE,WRITETEXT
1106    SQLOLEDB.DLL
1117    sp_server_info 1
1125    select substring('NY',status/1024&1+1,1) from master..sysdatabases where name=DB_NAME()
10110    21S01
10111    21S01
10121    07008
10122    07008
10169    22003
10207    22018
10208    42S22
10209    42S02
10211    22007
10212    22007
10214    21S01
10221    22003
10222    23000
10230    42000
10231    42000
10233    22003
10234    23000
10235    22003
10236    22018
10237    22003
10238    22003
10239    22003
10240    42S02
10241    22003
10242    22007
10243    22007
10245    22003
10246    22018
10247    22003
10248    22018
10249    22003
10250    22018
10257    22018
10267    25000
10268    42S02
10273    23000
10274    23000
10278    25000
10296    22007
10297    22007
10306    22018
10311    22025
10410    22018
10513    21000
10516    23000
10518    22007
10519    22018
10520    22003
10521    22003
10522    22003
10523    22003
10524    22003
10525    22003
10530    22018
10531    23000
10536    22003
10548    23000
10551    44000
10612    25000
10629    25000
10912    08004
10917    08004
10920    01000
10927    01000
11008    22003
11011    22019
11206    40001
11212    40001
11506    23000
11509    23000
11907    42S02
11912    42S22
11914    42S11
12502    42S02
12602    23000
12616    23000
12626    40001
12627    23000
12628    23000
12706    42S21
12707    42S02
12715    42S01
12728    42S21
12729    42S02
12741    08004
13002    42S12
13310    40001
13605    23000
13606    23000
13607    01000
13608    01000
13623    01000
13702    42S02
13704    42S12
13719    42S12
13903    25000
13904    25000
13907    25000
13909    25000
14003    28000
14018    08004
14314    42S12
14315    42S02
14402    42S02
14410    21S02
14502    21S02
14503    21S02
14507    42S21
14510    42S21
14702    42S02
14903    42S02
14925    42S22
15702    01000
15704    01000
16227    42S12
16402    25000
17113    40001
18115    22018
18116    22003
18135    22012
18153    22001
18154    01003
26903    HY109
26917    34000L
26930    HY009
26931    24000
26932    24000
26935    01001
27810    08004
28451    08004
28459    08004
28460    28000
40000    Cannot drop the index
40001    Microsoft SQL Server Login
40002    table
40003    owner
40004    database
40005    stored procedure
40006    (local)
40007    Microsoft SQL Server Login
40008    Help is not available
40017    Filling listbox requires a valid Login Id and Password
40018    Filling listbox failed:\nSQLState: '%s'\n SQL Server Error: %ld\n%s
40019    Connection failed:\nSQLState: '%s'\nSQL Server Error: %ld\n%s\n
40020    &Server:
40021    (Default)
40022    Unknown Translator
40023    Select Log File
40024    Log Files(*.log)|*.log|All Files(*.*)|*.*|
40025    Query Logging Threshold field must be numeric
40026    At %s the following query executed in %lu milliseconds
40027    Error %d occurred. No description was returned by server '%s'.
40114    07001Wrong number of parameters
40115    07006Restricted data type attribute violation
40116    07S01Invalid use of default parameter
40117    08001Client unable to establish connection
40118    08004Server rejected the connection
40119    08S01Connection failure
40120    21S01Insert value list does not match column list
40121    21S02Degree of derived table does not match column list
40122    22001String data, right truncation
40123    22002Indicator variable required but not supplied
40124    22003Numeric value out of range
40125    22018Invalid character value for cast specification.
40126    22007Invalid date format
40127    22007Invalid time format
40128    22007Invalid timestamp format
40129    22026String data, length mismatch
40130    24000Invalid cursor state
40131    25000Invalid transaction state
40132    28000Invalid authorization specification
40133    28000Invalid authorization specification; Access to selected database has been denied
40134    28000Invalid authorization specification; Language specified is not supported
40135    34000Invalid cursor name
40136    42000Syntax error or access violation
40137    3C000Duplicate cursor name
40138    HY018Server declined cancel request
40140    IM006Packet size change not supported by server, default used
40141    IM008Dialog failed
40142    IM009Unable to load translation DLL
40143    IM009Translation module is not valid
40144    HY000General error
40146    HY000The stored procedure required to complete this operation could not be found on the server (they were supplied with the ODBC setup disk for the SQL Server driver).  Please contact your system administrator.
40147    HY000Unknown token received from SQL Server
40148    HY000Operation not allowed while results are pending
40149    HY000Unable to load communication module.  Driver has not been correctly installed.
40150    HY000Communication module is not valid.  Driver has not been correctly installed.
40151    HY000Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed.
40152    HY000Connection is busy with results for another command
40153    HY000Failure during closing of connection
40154    HY000Protocol error in TDS stream
40155    HY000TDS buffer length too large
40156    HY000Non-default parameter not allowed after default parameter
40157    HY001Memory allocation failure
40158    07009Invalid Descriptor Index
40159    HY003Invalid application buffer type
40160    HY008Operation canceled
40161    HY009Invalid use of null pointer
40162    HY010Function sequence error
40163    HY011Operation invalid at this time
40164    HY015No cursor name available
40165    HY090Invalid string or buffer length
40166    HY091Invalid descriptor field identifier
40167    HY092Invalid attribute/option identifier
40168    07009Invalid parameter number
40169    HY021Inconsistent descriptor information
40170    HY021Invalid scale value
40171    HY096Invalid information type
40172    HY104Invalid precision value
40173    HY105Invalid parameter type
40174    HY106Fetch type out of range
40175    HY107Row value out of range
40176    HY109Invalid cursor position
40177    HY111Invalid bookmark value
40178    HYC00Optional feature not implemented
40179    HYT00Timeout expired
40180    08003Connection does not exist
40184    HY019Non-character and non-binary data sent in pieces
40190    07005Prepared statement is not a cursor-specification
40192    HY020Attempt to concatenate to a null or default value
40193    HY000Too many columns in select list
40194    HY016Cannot modify an implementation row descriptor
40195    HY004Invalid SQL data type
40197    22015Interval field overflow
40198    HY007Associated statement is not prepared
40199    HY024Invalid attribute value
40201    HY000Connection is not enabled for BCP
40202    HY000Unable to load DBLib
40203    HY000ODBCBCP/Driver version mismatch
40205    HY000Unicode conversion failed
40212    HY000Attempt to bulk-copy a NULL value into a Server column which does not accept NULL values
40224    HY000Attempt to bulk-copy an oversized column to the SQL Server
40227    HY000All bound columns are read-only
40228    HY000Cannot initialize SSPI package
40229    HY000Cannot generate SSPI context
40233    HY000The row length exceeds SQL Server's maximum allowable size
40234    HY000Unicode conversion failed.  Code page of server not on client
40350    25S11Enlistment is not possible due to pending transaction
40351    25S12Distributed transaction error
40400    01000General warning
40401    01000Ongoing transaction has been committed
40402    01000The catalog stored procedures installed on server %s are version %s; version %02d.%02d.%4.4d or later is required to support IDBSchemaRowset.  Please contact your system administrator.
40403    01000Access to database configured in the DSN has been denied. Default used.
40404    01000Language configured in the DSN is not supported. Default used.
40405    01000Procedure executed with 'EXEC'.  No output parameters returned.
40406    01000An error has occurred during an attempt to access the log file, logging disabled.
40407    01000Connected to backup server
40408    01000SQL Debugging disabled
40409    01000Translation options conflict with client/server character sets
40410    01004String data, right truncation
40450    01S00Invalid connection string attribute
40451    01S01Error in row
40452    01S02Option value changed
40453    01S02Packet size change not honored by server, server size used
40454    01S02Packet size changed
40455    01S02Cursor type changed
40456    01S02Cursor concurrency changed
40457    01S02Login timeout changed
40458    01001Cursor operation conflict
40459    01S05Cancel treated as FreeStmt/Close
40460    01S06Attempt to fetch before the result returned the first rowset
40461    01S07Fractional truncation
40500    Data Source Name
40501    Driver
40502    Server
40503    Login ID
40504    Password
40505    AppName
40506    WorkStation ID
40509    Database
40510    Language
40550    Unknown NetErr.
40551    Insufficient memory.
40552    Access denied.
40553    Connection is busy.
40554    Connection broken.
40555    Connection limit exceeded.
40556    Specified SQL server not found.
40557    The network has not been started.
40558    Insufficient network resources.
40559    Network is busy.
40560    Network access denied.
40561    General network error. Check your network documentation.
40562    Incorrect connection mode.
40563    Name not found in directory service.
40564    Invalid connection.
40565    Error reading or writing network data.
40566    Too many open file handles.
40567    SQL Server does not exist or access denied.
40619    Current Catalog
40620    Active Sessions
40621    Asynchable Commit
40622    Pass By Ref Accessors
40623    Catalog Location
40624    Catalog Term
40625    Catalog Usage
40626    Column Definition
40627    NULL Concatenation Behavior
40628    Data Source Name
40629    Read-Only Data Source
40630    DBMS Name
40631    DBMS Version
40632    GROUP BY Support
40633    Heterogeneous Table Support
40634    Identifier Case Sensitivity
40635    Lock Modes
40636    Maximum Index Size
40637    Maximum Row Size
40638    Maximum Row Size Includes BLOB
40639    Maximum Tables in SELECT
40640    Multiple Storage Objects
40641    Multi-Table Update
40642    Notification Phases
40643    NULL Collation Order
40644    OLE Object Support
40645    ORDER BY Columns in Select List
40646    Prepare Commit Behavior
40647    Prepare Abort Behavior
40648    Procedure Term
40649    OLE DB Version
40650    Provider Name
40651    Provider Version
40652    Quoted Identifier Sensitivity
40653    Schema Term
40654    Schema Usage
40655    SQL Support
40656    Structured Storage
40657    Subquery Support
40658    Isolation Levels
40659    Isolation Retention
40660    Table Term
40661    User Name
40662    Transaction DDL
40663    Asynchable Abort
40664    Data Source Object Threading Model
40665    Multiple Parameter Sets
40666    Output Parameter Availability
40667    Persistent ID Type
40668    Column Recalculated Notification
40669    Column Set Notification
40670    Row Activate Notification
40671    Row Delete Notification
40672    Row First Change Notification
40673    Row Insert Notification
40674    Row Release Notification
40675    Row Resynchronization Notification
40676    Rowset Release Notification
40677    Rowset Fetch Position Change Notification
40678    Row Undo Change Notification
40679    Row Undo Delete Notification
40680    Row Undo Insert Notification
40681    Row Update Notification
40682    Rowset Conversions on Command
40683    Multiple Results
40691    ISequentialStream
40694    Preserve on Abort
40695    Blocking Storage Objects
40696    Use Bookmarks
40697    Skip Deleted Bookmarks
40698    Bookmark Type
40699    Cache Deferred Columns
40700    Fetch Backwards
40701    Hold Rows
40702    Append-Only Rowset
40703    Scroll Backwards
40704    Column Privileges
40705    Command Time Out
40706    Preserve on Commit
40707    Defer Column
40708    Delay Storage Object Updates
40709    Immobile Rows
40710    Literal Bookmarks
40711    Literal Row Identity
40712    Maximum Open Rows
40713    Maximum Pending Rows
40714    Maximum Rows
40718    Others' Inserts Visible
40719    Others' Changes Visible
40720    Own Inserts Visible
40721    Own Changes Visible
40722    Quick Restart
40723    Reentrant Events
40724    Remove Deleted Rows
40725    Report Multiple Changes
40726    Row Privileges
40727    Row Threading Model
40728    Server Cursor
40729    Objects Transacted
40730    Updatability
40731    Strong Row Identity
40732    IAccessor
40733    IColumnsInfo
40734    IColumnsRowset
40735    IConnectionPointContainer
40736    Notification Granularity
40737    IRowset
40738    IRowsetChange
40739    IRowsetIdentity
40740    IRowsetInfo
40741    IRowsetLocate
40743    IRowsetResynch
40744    IRowsetScroll
40745    IRowsetUpdate
40746    ISupportErrorInfo
40747    Change Inserted Rows
40748    Return Pending Inserts
40749    IConvertType
40750    Maximum Open Chapters
40751    Maximum OR Conditions
40752    Maximum Sort Columns
40753    Sort on Index
40755    Cache Authentication
40756    Encrypt Password
40757    Integrated Security
40758    Mask Password
40759    Password
40760    Persist Encrypted
40761    Persist Security Info
40762    User ID
40764    Data Source
40765    Window Handle
40766    Impersonation Level
40767    Location
40768    Mode
40769    Prompt
40770    Protection Level
40771    Connect Timeout
40772    Locale Identifier
40773    Extended Properties
40774    Autocommit Isolation Levels
40775    Autoincrement
40776    Default
40778    Fixed Length
40779    Nullable
40780    Primary Key
40781    Unique
40783    Clustered
40784    Fill Factor
40788    Primary Key
40792    Unique
40793    Temporary Table
40795    Current Languge
40796    Network Address
40797    Network Library
40798    Use Procedure for Prepare
40799    Auto Translate
40800    Packet Size
40801    Application Name
40802    Workstation ID
40803    Replication server name connect option
40804    Server to Server RPC server name
40805    Override the NIC in the loginrec
40811    Maximum BLOB Length
40812    Fastload Options
40813    Keep Nulls
40814    Keep Identity
40820    Enable Fastload
40825    Quoted Catalog Names
40826    Provider Friendly Name
40827    Connection Status
40828    Bookmark Information
40829    Server Name
40830    Initial Catalog
40831    Initial File Name
40832    Multiple Connections
40833    Access Order
40834    IMultipleResults
40835    Lock Mode
40836    Server Data on Insert
40837    Unique Rows
40901    HY000The data source can not be used, because it DBMS version is less than 6.0.0.
40902    Microsoft OLE DB Provider for SQL Server
40903    The requested properties cannot be supported.
40904    Operation Canceled
40905    Nested variants are not supported as parameters.
40906    At least one parameter contained a type that was not supported.
40907    Unable to determine parameter type for at least one variant parameter.
40908    Cannot start transaction because more than one connection is in use.
40909    Cannot create new connection because in manual transaction mode.
40910    Can not start transaction while in firehose mode.