• ▼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)
              • Aggregate Functions (T-SQL)
              • Configuration Functions (T-SQL)
              • Cursor Functions (T-SQL)
              • Date and Time Functions (T-SQL)
              • Mathematical Functions (T-SQL)
              • Metadata Functions (T-SQL)
              • Security Functions (T-SQL)
              • String Functions (T-SQL)
              • System Functions (T-SQL)
              • System Statistical Functions (T-SQL)
              • Text and Image Functions (T-SQL)
              • Rowset 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