• ▼MSDN Library - April 2000
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio 6.0 Documentation
  • ▶Office Developer Documentation
  • ▶Windows CE Documentation
  • ▼Platform SDK
    • ▶Getting Started
    • ▶Design Strategies and Standards
    • ▶Base Services
    • ▶Component Services
    • ▼Data Access Services
      • ▶Microsoft Data Access Components (MDAC) SDK
      • ▶Jet and Replication Objects
      • ▶Microsoft XML SDK
      • ▼Microsoft SQL Server Programmer's Toolkit
        • ▶Getting Started
        • ▶What's New
        • ▶Installing SQL Server
        • ▶SQL Server Architecture
        • ▶Administering SQL Server
        • ▶Creating and Maintaining Databases
        • ▶Accessing and Changing Data
        • ▶Optimizing Database Performance
        • ▶Replication
        • ▶Data Transformation Services
        • ▶OLAP Services
        • ▶English Query
        • ▶Repository
        • ▼Building SQL Server Applications
          • ▶Overview of Building SQL Server Applications
          • ▼Transact-SQL Reference
            • Getting Started with Transact-SQL
            • Transact-SQL Syntax Conventions
            • ▶New Features in Transact-SQL
            • + (Add) (T-SQL)
            • + (Positive) (T-SQL)
            • + (String Concatenation) (T-SQL)
            • - (Negative) (T-SQL)
            • - (Subtract) (T-SQL)
            • * (Multiply) (T-SQL)
            • / (Divide) (T-SQL)
            • % (Modulo) (T-SQL)
            • % (Wildcard - Character(s) to Match) (T-SQL)
            • (Bitwise AND) (T-SQL)
            • | (Bitwise OR) (T-SQL)
            • ^ (Bitwise Exclusive OR) (T-SQL)
            • ~ (Bitwise NOT) (T-SQL)
            • = (Equals) (T-SQL)
            • (Greater Than) (T-SQL)
            • (Less Than) (T-SQL)
            • = (Greater Than or Equal To) (T-SQL)
            • = (Less Than or Equal To) (T-SQL)
            • (Not Equal To) (T-SQL)
            • !
            • != (Not Equal To) (T-SQL)
            • !
            • -- (Comment) (T-SQL)
            • /*
            • [ ] (Wildcard - Character(s) to Match) (T-SQL)
            • [^] (Wildcard - Character(s) Not to Match) (T-SQL)
            • _ (Wildcard - Match One Character) (T-SQL)
            • @@CONNECTIONS (T-SQL)
            • @@CPU_BUSY (T-SQL)
            • @@CURSOR_ROWS (T-SQL)
            • @@DATEFIRST (T-SQL)
            • @@DBTS (T-SQL)
            • @@ERROR (T-SQL)
            • @@FETCH_STATUS (T-SQL)
            • @@IDENTITY (T-SQL)
            • @@IDLE (T-SQL)
            • @@IO_BUSY (T-SQL)
            • @@LANGID (T-SQL)
            • @@LANGUAGE (T-SQL)
            • @@LOCK_TIMEOUT (T-SQL)
            • @@MAX_CONNECTIONS (T-SQL)
            • @@MAX_PRECISION (T-SQL)
            • @@NESTLEVEL (T-SQL)
            • @@OPTIONS (T-SQL)
            • @@PACK_RECEIVED (T-SQL)
            • @@PACK_SENT (T-SQL)
            • @@PACKET_ERRORS (T-SQL)
            • @@PROCID (T-SQL)
            • @@REMSERVER (T-SQL)
            • @@ROWCOUNT (T-SQL)
            • @@SERVERNAME (T-SQL)
            • @@SERVICENAME (T-SQL)
            • @@SPID (T-SQL)
            • @@TEXTSIZE (T-SQL)
            • @@TIMETICKS (T-SQL)
            • @@TOTAL_ERRORS (T-SQL)
            • @@TOTAL_READ (T-SQL)
            • @@TOTAL_WRITE (T-SQL)
            • @@TRANCOUNT (T-SQL)
            • @@VERSION (T-SQL)
            • ABS (T-SQL)
            • ACOS (T-SQL)
            • ALL (T-SQL)
            • ALTER DATABASE (T-SQL)
            • ALTER PROCEDURE (T-SQL)
            • ALTER TABLE (T-SQL)
            • ALTER TRIGGER (T-SQL)
            • ALTER VIEW (T-SQL)
            • AND (T-SQL)
            • ANY (T-SQL)
            • APP_NAME (T-SQL)
            • ASCII (T-SQL)
            • ASIN (T-SQL)
            • ATAN (T-SQL)
            • ATN2 (T-SQL)
            • AVG (T-SQL)
            • BACKUP (T-SQL)
            • BEGIN
            • BEGIN DISTRIBUTED TRANSACTION (T-SQL)
            • BEGIN TRANSACTION (T-SQL)
            • BETWEEN (T-SQL)
            • binary and varbinary (T-SQL)
            • bit (T-SQL)
            • BREAK (T-SQL)
            • BULK INSERT (T-SQL)
            • CASE (T-SQL)
            • CAST and CONVERT (T-SQL)
            • CEILING (T-SQL)
            • char and varchar (T-SQL)
            • CHAR (T-SQL)
            • CHARINDEX (T-SQL)
            • CHECKPOINT (T-SQL)
            • CLOSE (T-SQL)
            • COALESCE (T-SQL)
            • COL_LENGTH (T-SQL)
            • COL_NAME (T-SQL)
            • COLUMNPROPERTY (T-SQL)
            • COMMIT TRANSACTION (T-SQL)
            • COMMIT WORK (T-SQL)
            • Constants (T-SQL)
            • CONTAINS (T-SQL)
            • CONTAINSTABLE (T-SQL)
            • CONTINUE (T-SQL)
            • Control-of-Flow Language (T-SQL)
            • COS (T-SQL)
            • COT (T-SQL)
            • COUNT (T-SQL)
            • CREATE DATABASE (T-SQL)
            • CREATE DEFAULT (T-SQL)
            • CREATE INDEX (T-SQL)
            • CREATE PROCEDURE (T-SQL)
            • CREATE RULE (T-SQL)
            • CREATE SCHEMA (T-SQL)
            • CREATE STATISTICS (T-SQL)
            • CREATE TABLE (T-SQL)
            • CREATE TRIGGER (T-SQL)
            • CREATE VIEW (T-SQL)
            • CURRENT_TIMESTAMP (T-SQL)
            • CURRENT_USER (T-SQL)
            • cursor (T-SQL)
            • CURSOR_STATUS (T-SQL)
            • Cursors (T-SQL)
            • DATABASEPROPERTY (T-SQL)
            • ▶Data Types (T-SQL)
            • DATALENGTH (T-SQL)
            • DATEADD (T-SQL)
            • DATEDIFF (T-SQL)
            • DATENAME (T-SQL)
            • DATEPART (T-SQL)
            • datetime and smalldatetime (T-SQL)
            • DAY (T-SQL)
            • DB_ID (T-SQL)
            • DB_NAME (T-SQL)
            • ▶DBCC (T-SQL)
            • DEALLOCATE (T-SQL)
            • decimal and numeric (T-SQL)
            • DECLARE @local_variable (T-SQL)
            • DECLARE CURSOR (T-SQL)
            • DEGREES (T-SQL)
            • DELETE (T-SQL)
            • DENY (T-SQL)
            • DIFFERENCE (T-SQL)
            • DROP DATABASE (T-SQL)
            • DROP DEFAULT (T-SQL)
            • DROP INDEX (T-SQL)
            • DROP PROCEDURE (T-SQL)
            • DROP RULE (T-SQL)
            • DROP STATISTICS (T-SQL)
            • DROP TABLE (T-SQL)
            • DROP TRIGGER (T-SQL)
            • DROP VIEW (T-SQL)
            • DUMP (T-SQL)
            • ELSE (IF
            • END (BEGIN
            • EXECUTE (T-SQL)
            • EXISTS (T-SQL)
            • EXP (T-SQL)
            • Expressions (T-SQL)
            • FETCH (T-SQL)
            • FILE_ID (T-SQL)
            • FILE_NAME (T-SQL)
            • FILEGROUP_ID (T-SQL)
            • FILEGROUP_NAME (T-SQL)
            • FILEGROUPPROPERTY (T-SQL)
            • FILEPROPERTY (T-SQL)
            • float and real (T-SQL)
            • FLOOR (T-SQL)
            • FORMATMESSAGE (T-SQL)
            • FREETEXT (T-SQL)
            • FREETEXTTABLE (T-SQL)
            • FROM (T-SQL)
            • FULLTEXTCATALOGPROPERTY (T-SQL)
            • FULLTEXTSERVICEPROPERTY (T-SQL)
            • ▶Functions (T-SQL)
            • GETANSINULL (T-SQL)
            • GETDATE (T-SQL)
            • GO (T-SQL)
            • GOTO (T-SQL)
            • GRANT (T-SQL)
            • GROUP BY (T-SQL)
            • GROUPING (T-SQL)
            • HAVING (T-SQL)
            • HOST_ID (T-SQL)
            • HOST_NAME (T-SQL)
            • IDENT_INCR (T-SQL)
            • IDENT_SEED (T-SQL)
            • IDENTITY (Property) (T-SQL)
            • IDENTITY (Function) (T-SQL)
            • IF
            • image (T-SQL)
            • IN (T-SQL)
            • INDEXPROPERTY (T-SQL)
            • INDEX_COL (T-SQL)
            • ▶Information Schema Views (T-SQL)
            • INSERT (T-SQL)
            • int, smallint, and tinyint (T-SQL)
            • IS_MEMBER (T-SQL)
            • IS_SRVROLEMEMBER (T-SQL)
            • ISDATE (T-SQL)
            • IS [NOT] NULL (T-SQL)
            • ISNULL (T-SQL)
            • ISNUMERIC (T-SQL)
            • KILL (T-SQL)
            • LEFT (T-SQL)
            • LEN (T-SQL)
            • LIKE (T-SQL)
            • LOAD (T-SQL)
            • LOG (T-SQL)
            • LOG10 (T-SQL)
            • LOWER (T-SQL)
            • LTRIM (T-SQL)
            • MAX (T-SQL)
            • MIN (T-SQL)
            • money and smallmoney (T-SQL)
            • MONTH (T-SQL)
            • NCHAR (T-SQL)
            • nchar and nvarchar (T-SQL)
            • NEWID (T-SQL)
            • ▶Northwind Sample Database (T-SQL)
            • NOT (T-SQL)
            • ntext, text, and image (T-SQL)
            • NULLIF (T-SQL)
            • numeric (T-SQL)
            • OBJECT_ID (T-SQL)
            • OBJECT_NAME (T-SQL)
            • OBJECTPROPERTY (T-SQL)
            • OPEN (T-SQL)
            • OPENQUERY (T-SQL)
            • OPENROWSET (T-SQL)
            • Operators (T-SQL)
            • OR (T-SQL)
            • ORDER BY (T-SQL)
            • PARSENAME (T-SQL)
            • PATINDEX (T-SQL)
            • PERMISSIONS (T-SQL)
            • PI (T-SQL)
            • POWER (T-SQL)
            • Predicate (T-SQL)
            • PRINT (T-SQL)
            • ▶pubs Sample Database (T-SQL)
            • QUOTENAME (T-SQL)
            • RADIANS (T-SQL)
            • RAISERROR (T-SQL)
            • RAND (T-SQL)
            • READTEXT (T-SQL)
            • real (T-SQL)
            • RECONFIGURE (T-SQL)
            • REPLACE (T-SQL)
            • REPLICATE (T-SQL)
            • Reserved Keywords (T-SQL)
            • RESTORE (T-SQL)
            • RESTORE FILELISTONLY (T-SQL)
            • RESTORE HEADERONLY (T-SQL)
            • RESTORE LABELONLY (T-SQL)
            • RESTORE VERIFYONLY (T-SQL)
            • RETURN (T-SQL)
            • REVERSE (T-SQL)
            • REVOKE (T-SQL)
            • RIGHT (T-SQL)
            • ROLLBACK TRANSACTION (T-SQL)
            • ROLLBACK WORK (T-SQL)
            • ROUND (T-SQL)
            • RTRIM (T-SQL)
            • SAVE TRANSACTION (T-SQL)
            • Search Condition (T-SQL)
            • SELECT @local_variable (T-SQL)
            • ▶SELECT (T-SQL)
            • SESSION_USER (T-SQL)
            • SET @local_variable (T-SQL)
            • ▶SET (T-SQL)
            • SETUSER (T-SQL)
            • SHUTDOWN (T-SQL)
            • SIGN (T-SQL)
            • SIN (T-SQL)
            • smalldatetime (T-SQL)
            • smallint (T-SQL)
            • smallmoney (T-SQL)
            • SOME | ANY (T-SQL)
            • SOUNDEX (T-SQL)
            • SPACE (T-SQL)
            • SQUARE (T-SQL)
            • SQRT (T-SQL)
            • STATS_DATE (T-SQL)
            • STDEV (T-SQL)
            • STDEVP (T-SQL)
            • STR (T-SQL)
            • STUFF (T-SQL)
            • SUBSTRING (T-SQL)
            • SUM (T-SQL)
            • SUSER_ID (T-SQL)
            • SUSER_NAME (T-SQL)
            • SUSER_SID (T-SQL)
            • SUSER_SNAME (T-SQL)
            • ▼System Stored Procedures (T-SQL)
              • Object Hierarchy Syntax (T-SQL)
              • sp_add_agent_parameter (T-SQL)
              • sp_add_agent_profile (T-SQL)
              • sp_add_alert (T-SQL)
              • sp_addalias (T-SQL)
              • sp_addapprole (T-SQL)
              • sp_addarticle (T-SQL)
              • sp_add_data_file_recover_suspect_db (T-SQL)
              • sp_adddistpublisher (T-SQL)
              • sp_adddistributiondb (T-SQL)
              • sp_adddistributor (T-SQL)
              • sp_addextendedproc (T-SQL)
              • sp_addgroup (T-SQL)
              • sp_add_category (T-SQL)
              • sp_add_job (T-SQL)
              • sp_add_jobschedule (T-SQL)
              • sp_add_jobserver (T-SQL)
              • sp_add_jobstep (T-SQL)
              • sp_addlinkedserver (T-SQL)
              • sp_addlinkedsrvlogin (T-SQL)
              • sp_add_log_file_recover_suspect_db (T-SQL)
              • sp_addlogin (T-SQL)
              • sp_addmergearticle (T-SQL)
              • sp_addmergefilter (T-SQL)
              • sp_addmergepublication (T-SQL)
              • sp_addmergepullsubscription (T-SQL)
              • sp_addmergepullsubscription_agent (T-SQL)
              • sp_addmergesubscription (T-SQL)
              • sp_addmessage (T-SQL)
              • sp_add_notification (T-SQL)
              • sp_add_operator (T-SQL)
              • sp_addpublication (T-SQL)
              • sp_addpublication_snapshot (T-SQL)
              • sp_addpublisher70 (T-SQL)
              • sp_addpullsubscription (T-SQL)
              • sp_addpullsubscription_agent (T-SQL)
              • sp_addremotelogin (T-SQL)
              • sp_addrole (T-SQL)
              • sp_addrolemember (T-SQL)
              • sp_addserver (T-SQL)
              • sp_addsrvrolemember (T-SQL)
              • sp_addsubscriber (T-SQL)
              • sp_addsubscriber_schedule (T-SQL)
              • sp_addsubscription (T-SQL)
              • sp_addsynctriggers (T-SQL)
              • sp_addtabletocontents (T-SQL)
              • sp_addtask (T-SQL)
              • sp_addtype (T-SQL)
              • sp_add_targetservergroup (T-SQL)
              • sp_addumpdevice (T-SQL)
              • sp_add_targetsvrgrp_member (T-SQL)
              • sp_adduser (T-SQL)
              • sp_altermessage (T-SQL)
              • sp_apply_job_to_targets (T-SQL)
              • sp_approlepassword (T-SQL)
              • sp_article_validation (T-SQL)
              • sp_articlecolumn (T-SQL)
              • sp_articlefilter (T-SQL)
              • sp_articlesynctranprocs (T-SQL)
              • sp_articleview (T-SQL)
              • sp_attach_db (T-SQL)
              • sp_attach_single_file_db (T-SQL)
              • sp_autostats (T-SQL)
              • sp_bindefault (T-SQL)
              • sp_bindrule (T-SQL)
              • sp_bindsession (T-SQL)
              • sp_browsereplcmds (T-SQL)
              • sp_catalogs (T-SQL)
              • sp_certify_removable (T-SQL)
              • sp_change_agent_parameter (T-SQL)
              • sp_change_agent_profile (T-SQL)
              • sp_change_users_login (T-SQL)
              • sp_changearticle (T-SQL)
              • sp_changedbowner (T-SQL)
              • sp_changedistpublisher (T-SQL)
              • sp_changedistributiondb (T-SQL)
              • sp_changedistributor_property (T-SQL)
              • sp_changedistributor_password (T-SQL)
              • sp_changegroup (T-SQL)
              • sp_changemergearticle (T-SQL)
              • sp_changemergefilter (T-SQL)
              • sp_changemergepublication (T-SQL)
              • sp_changemergepullsubscription (T-SQL)
              • sp_changemergesubscription (T-SQL)
              • sp_changeobjectowner (T-SQL)
              • sp_changepublication (T-SQL)
              • sp_changesubscriber (T-SQL)
              • sp_changesubscriber_schedule (T-SQL)
              • sp_changesubstatus (T-SQL)
              • sp_change_subscription_properties (T-SQL)
              • sp_check_for_sync_trigger (T-SQL)
              • sp_column_privileges (T-SQL)
              • sp_column_privileges_ex (T-SQL)
              • sp_columns (T-SQL)
              • sp_columns_ex (T-SQL)
              • sp_configure (T-SQL)
              • sp_createstats (T-SQL)
              • sp_create_removable (T-SQL)
              • sp_cursor_list (T-SQL)
              • sp_cycle_errorlog (T-SQL)
              • sp_databases (T-SQL)
              • sp_datatype_info (T-SQL)
              • sp_dbcmptlevel (T-SQL)
              • sp_dbfixedrolepermission (T-SQL)
              • sp_dboption (T-SQL)
              • sp_dbremove (T-SQL)
              • sp_defaultdb (T-SQL)
              • sp_defaultlanguage (T-SQL)
              • sp_delete_alert (T-SQL)
              • sp_delete_backuphistory (T-SQL)
              • sp_delete_category (T-SQL)
              • sp_delete_job (T-SQL)
              • sp_delete_jobschedule (T-SQL)
              • sp_delete_jobserver (T-SQL)
              • sp_delete_jobstep (T-SQL)
              • sp_delete_notification (T-SQL)
              • sp_delete_operator (T-SQL)
              • sp_delete_targetserver (T-SQL)
              • sp_delete_targetservergroup (T-SQL)
              • sp_delete_targetsvrgrp_member (T-SQL)
              • sp_deletemergeconflictrow (T-SQL)
              • sp_denylogin (T-SQL)
              • sp_depends (T-SQL)
              • sp_describe_cursor (T-SQL)
              • sp_describe_cursor_columns (T-SQL)
              • sp_describe_cursor_tables (T-SQL)
              • sp_detach_db (T-SQL)
              • sp_drop_agent_parameter (T-SQL)
              • sp_drop_agent_profile (T-SQL)
              • sp_dropalias (T-SQL)
              • sp_dropapprole (T-SQL)
              • sp_droparticle (T-SQL)
              • sp_dropdevice (T-SQL)
              • sp_dropdistpublisher (T-SQL)
              • sp_dropdistributiondb (T-SQL)
              • sp_dropdistributor (T-SQL)
              • sp_dropextendedproc (T-SQL)
              • sp_dropgroup (T-SQL)
              • sp_droplinkedsrvlogin (T-SQL)
              • sp_droplogin (T-SQL)
              • sp_dropmergearticle (T-SQL)
              • sp_dropmergefilter (T-SQL)
              • sp_dropmergepublication (T-SQL)
              • sp_dropmergepullsubscription (T-SQL)
              • sp_dropmergesubscription (T-SQL)
              • sp_dropmessage (T-SQL)
              • sp_droppublication (T-SQL)
              • sp_droppullsubscription (T-SQL)
              • sp_dropremotelogin (T-SQL)
              • sp_droprole (T-SQL)
              • sp_droprolemember (T-SQL)
              • sp_dropserver (T-SQL)
              • sp_dropsrvrolemember (T-SQL)
              • sp_dropsubscriber (T-SQL)
              • sp_dropsubscription (T-SQL)
              • sp_droptask (T-SQL)
              • sp_droptype (T-SQL)
              • sp_dropuser (T-SQL)
              • sp_dropwebtask (T-SQL)
              • sp_dsninfo (T-SQL)
              • sp_dumpparamcmd (T-SQL)
              • sp_enumcodepages (T-SQL)
              • sp_enumcustomresolvers (T-SQL)
              • sp_enumdsn (T-SQL)
              • sp_enumfullsubscribers (T-SQL)
              • sp_executesql (T-SQL)
              • sp_expired_subscription_cleanup (T-SQL)
              • sp_fkeys (T-SQL)
              • sp_foreignkeys (T-SQL)
              • sp_fulltext_catalog (T-SQL)
              • sp_fulltext_column (T-SQL)
              • sp_fulltext_database (T-SQL)
              • sp_fulltext_service (T-SQL)
              • sp_fulltext_table (T-SQL)
              • sp_generatefilters (T-SQL)
              • sp_getbindtoken (T-SQL)
              • sp_getmergedeletetype (T-SQL)
              • sp_get_distributor (T-SQL)
              • sp_grant_publication_access (T-SQL)
              • sp_grantdbaccess (T-SQL)
              • sp_grantlogin (T-SQL)
              • sp_help (T-SQL)
              • sp_help_agent_default (T-SQL)
              • sp_help_agent_parameter (T-SQL)
              • sp_help_agent_profile (T-SQL)
              • sp_help_alert (T-SQL)
              • sp_helparticle (T-SQL)
              • sp_helparticlecolumns (T-SQL)
              • sp_help_category (T-SQL)
              • sp_helpconstraint (T-SQL)
              • sp_helpdb (T-SQL)
              • sp_helpdbfixedrole (T-SQL)
              • sp_helpdevice (T-SQL)
              • sp_helpdistpublisher (T-SQL)
              • sp_helpdistributiondb (T-SQL)
              • sp_helpdistributor (T-SQL)
              • sp_help_downloadlist (T-SQL)
              • sp_helpextendedproc (T-SQL)
              • sp_helpfile (T-SQL)
              • sp_helpfilegroup (T-SQL)
              • sp_help_fulltext_catalogs (T-SQL)
              • sp_help_fulltext_catalogs_cursor (T-SQL)
              • sp_help_fulltext_tables (T-SQL)
              • sp_help_fulltext_tables_cursor (T-SQL)
              • sp_help_fulltext_columns (T-SQL)
              • sp_help_fulltext_columns_cursor (T-SQL)
              • sp_helpgroup (T-SQL)
              • sp_helphistory (T-SQL)
              • sp_help_job (T-SQL)
              • sp_help_jobhistory (T-SQL)
              • sp_help_jobschedule (T-SQL)
              • sp_help_jobserver (T-SQL)
              • sp_help_jobstep (T-SQL)
              • sp_helpindex (T-SQL)
              • sp_helplanguage (T-SQL)
              • sp_helplinkedsrvlogin (T-SQL)
              • sp_helplogins (T-SQL)
              • sp_helpmergearticle (T-SQL)
              • sp_helpmergearticleconflicts (T-SQL)
              • sp_helpmergeconflictrows (T-SQL)
              • sp_helpmergedeleteconflictrows (T-SQL)
              • sp_helpmergefilter (T-SQL)
              • sp_helpmergepublication (T-SQL)
              • sp_helpmergepullsubscription (T-SQL)
              • sp_helpmergesubscription (T-SQL)
              • sp_help_notification (T-SQL)
              • sp_helpntgroup (T-SQL)
              • sp_help_operator (T-SQL)
              • sp_helppublication (T-SQL)
              • sp_help_publication_access (T-SQL)
              • sp_helppullsubscription (T-SQL)
              • sp_helpremotelogin (T-SQL)
              • sp_helpreplicationdboption (T-SQL)
              • sp_helprole (T-SQL)
              • sp_helprolemember (T-SQL)
              • sp_helprotect (T-SQL)
              • sp_helpserver (T-SQL)
              • sp_helpsort (T-SQL)
              • sp_helpsrvrole (T-SQL)
              • sp_helpsrvrolemember (T-SQL)
              • sp_helpsubscriberinfo (T-SQL)
              • sp_helpsubscription (T-SQL)
              • sp_helpsubscription_properties (T-SQL)
              • sp_help_targetserver (T-SQL)
              • sp_help_targetservergroup (T-SQL)
              • sp_helptask (T-SQL)
              • sp_helptext (T-SQL)
              • sp_helptrigger (T-SQL)
              • sp_helpuser (T-SQL)
              • sp_indexes (T-SQL)
              • sp_indexoption (T-SQL)
              • sp_link_publication (T-SQL)
              • sp_linkedservers (T-SQL)
              • sp_lock (T-SQL)
              • sp_makewebtask (T-SQL)
              • sp_manage_jobs_by_login (T-SQL)
              • sp_mergedummyupdate (T-SQL)
              • sp_mergesubscription_cleanup (T-SQL)
              • sp_monitor (T-SQL)
              • sp_msx_defect (T-SQL)
              • sp_msx_enlist (T-SQL)
              • sp_OACreate (T-SQL)
              • sp_OADestroy (T-SQL)
              • sp_OAGetErrorInfo (T-SQL)
              • sp_OAGetProperty (T-SQL)
              • sp_OAMethod (T-SQL)
              • sp_OASetProperty (T-SQL)
              • sp_OAStop (T-SQL)
              • sp_password (T-SQL)
              • sp_pkeys (T-SQL)
              • sp_primarykeys (T-SQL)
              • sp_post_msx_operation (T-SQL)
              • sp_processmail (T-SQL)
              • sp_procoption (T-SQL)
              • sp_publication_validation (T-SQL)
              • sp_purgehistory (T-SQL)
              • sp_purge_jobhistory (T-SQL)
              • sp_reassigntask (T-SQL)
              • sp_recompile (T-SQL)
              • sp_refreshsubscriptions (T-SQL)
              • sp_refreshview (T-SQL)
              • sp_reinitmergepullsubscription (T-SQL)
              • sp_reinitmergesubscription (T-SQL)
              • sp_reinitpullsubscription (T-SQL)
              • sp_reinitsubscription (T-SQL)
              • sp_remoteoption (T-SQL)
              • sp_remove_job_from_targets (T-SQL)
              • sp_removedbreplication (T-SQL)
              • sp_rename (T-SQL)
              • sp_renamedb (T-SQL)
              • sp_replcmds (T-SQL)
              • sp_replcounters (T-SQL)
              • sp_repldone (T-SQL)
              • sp_replflush (T-SQL)
              • sp_replicationdboption (T-SQL)
              • sp_replication_agent_checkup (T-SQL)
              • sp_replsetoriginator (T-SQL)
              • sp_replshowcmds (T-SQL)
              • sp_repltrans (T-SQL)
              • sp_resync_targetserver (T-SQL)
              • sp_revoke_publication_access (T-SQL)
              • sp_revokedbaccess (T-SQL)
              • sp_revokelogin (T-SQL)
              • sp_runwebtask (T-SQL)
              • sp_script_synctran_commands (T-SQL)
              • sp_scriptdelproc (T-SQL)
              • sp_scriptinsproc (T-SQL)
              • sp_scriptmappedupdproc (T-SQL)
              • sp_scriptupdproc (T-SQL)
              • sp_server_info (T-SQL)
              • sp_serveroption (T-SQL)
              • sp_setapprole (T-SQL)
              • sp_setnetname (T-SQL)
              • sp_spaceused (T-SQL)
              • sp_special_columns (T-SQL)
              • sp_sproc_columns (T-SQL)
              • sp_srvrolepermission (T-SQL)
              • sp_start_job (T-SQL)
              • sp_statistics (T-SQL)
              • sp_stop_job (T-SQL)
              • sp_stored_procedures (T-SQL)
              • sp_subscription_cleanup (T-SQL)
              • sp_table_privileges (T-SQL)
              • sp_table_privileges_ex (T-SQL)
              • sp_table_validation (T-SQL)
              • sp_tableoption (T-SQL)
              • sp_tables (T-SQL)
              • sp_tables_ex (T-SQL)
              • sp_unbindefault (T-SQL)
              • sp_unbindrule (T-SQL)
              • sp_update_agent_profile (T-SQL)
              • sp_update_alert (T-SQL)
              • sp_update_category (T-SQL)
              • sp_update_job (T-SQL)
              • sp_update_jobschedule (T-SQL)
              • sp_update_jobstep (T-SQL)
              • sp_update_notification (T-SQL)
              • sp_update_operator (T-SQL)
              • sp_updatestats (T-SQL)
              • sp_update_targetservergroup (T-SQL)
              • sp_updatetask (T-SQL)
              • sp_validname (T-SQL)
              • sp_validatelogins (T-SQL)
              • sp_who (T-SQL)
              • xp_cmdshell (T-SQL)
              • xp_deletemail (T-SQL)
              • xp_enumgroups (T-SQL)
              • xp_findnextmsg (T-SQL)
              • xp_grantlogin (T-SQL)
              • xp_logevent (T-SQL)
              • xp_loginconfig (T-SQL)
              • xp_logininfo (T-SQL)
              • xp_msver (T-SQL)
              • xp_readmail (T-SQL)
              • xp_revokelogin (T-SQL)
              • xp_sendmail (T-SQL)
              • xp_sprintf (T-SQL)
              • xp_sqlinventory (T-SQL)
              • xp_sqlmaint (T-SQL)
              • xp_sqltrace (T-SQL)
              • xp_sscanf (T-SQL)
              • xp_startmail (T-SQL)
              • xp_stopmail (T-SQL)
              • xp_trace_addnewqueue (T-SQL)
              • xp_trace_deletequeuedefinition (T-SQL)
              • xp_trace_destroyqueue (T-SQL)
              • xp_trace_enumqueuedefname (T-SQL)
              • xp_trace_enumqueuehandles (T-SQL)
              • xp_trace_eventclassrequired (T-SQL)
              • xp_trace_flushqueryhistory (T-SQL)
              • xp_trace_generate_event (T-SQL)
              • xp_trace_getappfilter (T-SQL)
              • xp_trace_getconnectionidfilter (T-SQL)
              • xp_trace_getcpufilter (T-SQL)
              • xp_trace_getdbidfilter (T-SQL)
              • xp_trace_getdurationfilter (T-SQL)
              • xp_trace_geteventfilter (T-SQL)
              • xp_trace_geteventnames (T-SQL)
              • xp_trace_getevents (T-SQL)
              • xp_trace_gethostfilter (T-SQL)
              • xp_trace_gethpidfilter (T-SQL)
              • xp_trace_getindidfilter (T-SQL)
              • xp_trace_getntdmfilter (T-SQL)
              • xp_trace_getntnmfilter (T-SQL)
              • xp_trace_getobjidfilter (T-SQL)
              • xp_trace_getqueueautostart (T-SQL)
              • xp_trace_getqueuedestination (T-SQL)
              • xp_trace_getqueueproperties (T-SQL)
              • xp_trace_getreadfilter (T-SQL)
              • xp_trace_getserverfilter (T-SQL)
              • xp_trace_getseverityfilter (T-SQL)
              • xp_trace_getspidfilter (T-SQL)
              • xp_trace_getsysobjectsfilter (T-SQL)
              • xp_trace_gettextfilter (T-SQL)
              • xp_trace_getuserfilter (T-SQL)
              • xp_trace_getwritefilter (T-SQL)
              • xp_trace_loadqueuedefinition (T-SQL)
              • xp_trace_pausequeue (T-SQL)
              • xp_trace_restartqueue (T-SQL)
              • xp_trace_savequeuedefinition (T-SQL)
              • xp_trace_setappfilter (T-SQL)
              • xp_trace_setconnectionidfilter (T-SQL)
              • xp_trace_setcpufilter (T-SQL)
              • xp_trace_setdbidfilter (T-SQL)
              • xp_trace_setdurationfilter (T-SQL)
              • xp_trace_seteventclassrequired (T-SQL)
              • xp_trace_seteventfilter (T-SQL)
              • xp_trace_sethostfilter (T-SQL)
              • xp_trace_sethpidfilter (T-SQL)
              • xp_trace_setindidfilter (T-SQL)
              • xp_trace_setntdmfilter (T-SQL)
              • xp_trace_setntnmfilter (T-SQL)
              • xp_trace_setobjidfilter (T-SQL)
              • xp_trace_setqueryhistory (T-SQL)
              • xp_trace_setqueueautostart (T-SQL)
              • xp_trace_setqueuecreateinfo (T-SQL)
              • xp_trace_setqueuedestination (T-SQL)
              • xp_trace_setreadfilter (T-SQL)
              • xp_trace_setserverfilter (T-SQL)
              • xp_trace_setseverityfilter (T-SQL)
              • xp_trace_setspidfilter (T-SQL)
              • xp_trace_setsysobjectsfilter (T-SQL)
              • xp_trace_settextfilter (T-SQL)
              • xp_trace_setuserfilter (T-SQL)
              • xp_trace_setwritefilter (T-SQL)
              • xp_trace_startconsumer (T-SQL)
            • ▶System Tables (T-SQL)
            • SYSTEM_USER (T-SQL)
            • TAN (T-SQL)
            • text (T-SQL)
            • TEXTPTR (T-SQL)
            • TEXTVALID (T-SQL)
            • timestamp (T-SQL)
            • tinyint (T-SQL)
            • Trace Flags (T-SQL)
            • Transactions (T-SQL)
            • TRIGGER_NESTLEVEL (T-SQL)
            • TRUNCATE TABLE (T-SQL)
            • TYPEPROPERTY (T-SQL)
            • UNICODE (T-SQL)
            • UNION (T-SQL)
            • uniqueidentifier (T-SQL)
            • UPDATE (T-SQL)
            • UPDATE STATISTICS (T-SQL)
            • UPDATETEXT (T-SQL)
            • UPPER (T-SQL)
            • USE (T-SQL)
            • USER (T-SQL)
            • USER_ID (T-SQL)
            • USER_NAME (T-SQL)
            • VAR (T-SQL)
            • varbinary (T-SQL)
            • varchar (T-SQL)
            • VARP (T-SQL)
            • WAITFOR (T-SQL)
            • WHERE (T-SQL)
            • WHILE (T-SQL)
            • WRITETEXT (T-SQL)
            • YEAR (T-SQL)
          • ▶ADO and SQL Server
          • ▶OLE DB and SQL Server
          • ▶ODBC and SQL Server
          • ▶SQL-DMO
          • ▶SQL-NS
          • ▶Replication Programming
          • ▶DTS Programming
          • ▶OLAP Services Programming
          • ▶Repository Programming
          • ▶Command Prompt Utilities
          • ▶Open Data Services Programming
          • ▶Embedded SQL for C and SQL Server
          • ▶DB Library for C
        • ▶Troubleshooting
        • ▶How To
        • ▶Glossary
    • ▶Graphics and Multimedia Services
    • ▶Management Services
    • ▶Messaging and Collaboration Services
    • ▶Networking and Directory Services
    • ▶Security
    • ▶Tools and Languages
    • ▶User Interface Services
    • ▶Web Services
    • ▶Win32 API
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▶Specifications
  • ▶Books
  • ▶Partial Books
  • ▶Periodicals
  • ▶Samples