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