Welcome  |  Sign In     | 
MSDN
     
Transact-SQL Reference
Transact-SQL Overview
Transact-SQL Syntax Conventions
New and Enhanced Features in Transact-SQL
+ (Add)
+ (Positive)
+ (String Concatenation)
- (Negative)
- (Subtract)
* (Multiply)
/ (Divide)
% (Modulo)
% (Wildcard - Character(s) to Match)
& (Bitwise AND)
| (Bitwise OR)
^ (Bitwise Exclusive OR)
~ (Bitwise NOT)
= (Equals)
> (Greater Than)
< (Less Than)
>= (Greater Than or Equal To)
<= (Less Than or Equal To)
<> (Not Equal To)
!< (Not Less Than)
!= (Not Equal To)
!> (Not Greater Than)
-- (Comment)
/*...*/ (Comment)
[ ] (Wildcard - Character(s) to Match)
[^] (Wildcard - Character(s) Not to Match)
_ (Wildcard - Match One Character)
@@CONNECTIONS
@@CPU_BUSY
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@FETCH_STATUS
@@IDENTITY
@@IDLE
@@IO_BUSY
@@LANGID
@@LANGUAGE
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@NESTLEVEL
@@OPTIONS
@@PACK_RECEIVED
@@PACK_SENT
@@PACKET_ERRORS
@@PROCID
@@REMSERVER
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TEXTSIZE
@@TIMETICKS
@@TOTAL_ERRORS
@@TOTAL_READ
@@TOTAL_WRITE
@@TRANCOUNT
@@VERSION
ABS
ACOS
ALL
ALTER DATABASE
ALTER FUNCTION
APP_NAME
AND
ANY
AVG
ALTER VIEW
ALTER TABLE
ASIN
ATAN
ATN2
ASCII
ALTER PROCEDURE
ALTER TRIGGER
BREAK
BINARY_CHECKSUM
bit
BACKUP
BULK INSERT
binary and varbinary
BETWEEN
BEGIN TRANSACTION
BEGIN DISTRIBUTED TRANSACTION
BEGIN...END
CONTINUE
COLUMNPROPERTY
Control-of-Flow Language
COUNT_BIG
Constants
CHECKPOINT
COL_LENGTH
CAST and CONVERT
COS
COT
CONTAINS
CHARINDEX
CONTAINSTABLE
CHECKSUM_AGG
COMMIT WORK
COUNT
CASE
COLLATIONPROPERTY
CLOSE
CHAR
CEILING
COL_NAME
char and varchar
COMMIT TRANSACTION
COALESCE
CHECKSUM
CURSOR_STATUS
cursor
CURRENT_USER
CURRENT_TIMESTAMP
Cursors
CREATE STATISTICS
CREATE RULE
CREATE VIEW
CREATE TRIGGER
CREATE TABLE
CREATE SCHEMA
CREATE DATABASE
CREATE DEFAULT
CREATE PROCEDURE
CREATE INDEX
CREATE FUNCTION
DATABASEPROPERTYEX
DATENAME
DATEPART
DAY
DATEADD
DATALENGTH
DATEDIFF
DB_NAME
DATABASEPROPERTY
DB_ID
datetime and smalldatetime
DENY
DROP PROCEDURE
DECLARE CURSOR
decimal and numeric
DROP RULE
DUMP
DROP VIEW
DROP DEFAULT
DROP INDEX
DROP FUNCTION
DECLARE @local_variable
DROP STATISTICS
DROP TABLE
DEALLOCATE
DROP DATABASE
DIFFERENCE
DEGREES
DROP TRIGGER
DELETE
EXECUTE
EXISTS
ELSE (IF...ELSE)
EXP
Expressions
END (BEGIN...END)
fn_trace_getinfo
fn_trace_gettable
fn_helpcollations
FORMATMESSAGE
FILEGROUP_NAME
FREETEXTTABLE
FREETEXT
FILE_ID
fn_get_sql
FILEGROUP_ID
FULLTEXTSERVICEPROPERTY
FROM
fn_virtualfilestats
fn_trace_geteventinfo
fn_servershareddrives
FLOOR
float and real
FILE_NAME
fn_trace_getfilterinfo
fn_listextendedproperty
fn_virtualservernodes
FULLTEXTCATALOGPROPERTY
FILEPROPERTY
FETCH
FILEGROUPPROPERTY
GETANSINULL
GETUTCDATE
GETDATE
GROUP BY
GOTO
GO
GRANT
COLLATE
Data Types
DBCC
Functions
GROUPING
NCHAR
NEWID
nchar and nvarchar
ntext, text, and image
NOT
NULLIF
numeric
OPEN
OBJECT_ID
OBJECT_NAME
OPENDATASOURCE
Operators
OPENXML
OPENQUERY
OBJECTPROPERTY
OPENROWSET
ORDER BY
OR
POWER
PATINDEX
PRINT
PERMISSIONS
PI
PARSENAME
Predicate
QUOTENAME
RETURN
ROWCOUNT_BIG
RAND
real
ROLLBACK WORK
RESTORE
RESTORE VERIFYONLY
REVOKE
RESTORE FILELISTONLY
RIGHT
ROLLBACK TRANSACTION
RECONFIGURE
RAISERROR
RESTORE HEADERONLY
RESTORE LABELONLY
REVERSE
RTRIM
REPLACE
REPLICATE
ROUND
RADIANS
Reserved Keywords
READTEXT
Search Condition
SAVE TRANSACTION
SESSION_USER
SERVERPROPERTY
SESSIONPROPERTY
SCOPE_IDENTITY
SELECT @local_variable
SET @local_variable
SUSER_ID
SOME | ANY
smalldatetime
SUSER_SID
SPACE
SOUNDEX
SIN
STR
SUM
STATS_DATE
SETUSER
sql_variant
smallmoney
SQL_VARIANT_PROPERTY
SQUARE
STDEV
SUBSTRING
STUFF
SIGN
smallint
SQRT
SUSER_SNAME
SUSER_NAME
STDEVP
SHUTDOWN
SYSTEM_USER
tinyint
TRIGGER_NESTLEVEL
text
TRUNCATE TABLE
Transactions
TYPEPROPERTY
TEXTPTR
TAN
TEXTVALID
Trace Flags
timestamp
table
UPDATE STATISTICS
USER_NAME
USER_ID
UPPER
UNION
USE
uniqueidentifier
UPDATETEXT
UNICODE
UPDATE
USER
varbinary
VARP
VAR
varchar
WRITETEXT
WHERE
WHILE
WAITFOR
YEAR
Information Schema Views
Northwind Sample Database
pubs Sample Database
SELECT
SET
System Stored Procedures
System Tables
HOST_NAME
HOST_ID
HAVING
HAS_DBACCESS
INDEXPROPERTY
IDENTITY (Property)
int, bigint, smallint, and tinyint
INDEX_COL
IS_SRVROLEMEMBER
IDENT_INCR
INSERT
IDENTITY (Function)
ISNULL
ISNUMERIC
IF...ELSE
IDENT_CURRENT
INDEXKEY_PROPERTY
IN
ISDATE
IS_MEMBER
image
IS [NOT] NULL
IDENT_SEED
KILL
LOG10
LIKE
LOWER
LEN
LOG
LOAD
LTRIM
LEFT
MONTH
MAX
MIN
money and smallmoney

©2006 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
 
Page view tracker