▼
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)
Categories (T-SQL)
Customers (T-SQL)
CustomerCustomerDemo (T-SQL)
CustomerDemographics (T-SQL)
Employees (T-SQL)
EmployeeTerritories (T-SQL)
Order Details (T-SQL)
Orders (T-SQL)
Products (T-SQL)
Region (T-SQL)
Shippers (T-SQL)
Suppliers (T-SQL)
Territories
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