• ▼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