Home Microsoft SQL Server DigiMailing Contact
    Keyword



 
On Microsoft SQL Server supplies you with the following objects:

$PARTITION
ASYMKEYPROPERTY
ASYMKEY_ID
CertProperty
Cert_ID
Change Data Capture Functions
Change Tracking Functions
CLOSE MASTER KEY
CLOSE SYMMETRIC KEY
COLLATE
COLLATIONPROPERTY
CONTAINSTABLE
Control-of-Flow Language
Data Collector Functions
DATABASEPROPERTY
DATABASEPROPERTYEX
DATABASE_PRINCIPAL_ID
DATALENGTH
DBCC
DEGREES
DENSE_RANK
END CONVERSATION
Expressions
FILEGROUPPROPERTY
FILEGROUP_ID
FILEGROUP_NAME
FILEPROPERTY
FILE_ID
FILE_IDEX
FILE_NAME
fn_get_audit_file
fn_get_sql
fn_helpcollations
fn_listextendedproperty
fn_my_permissions
fn_servershareddrives
fn_virtualfilestats
fn_virtualservernodes
FORMATMESSAGE
GET CONVERSATION GROUP
GETANSINULL
GET_FILESTREAM_TRANSACTION_CONTEXT
GET_TRANSMISSION_STATUS
GROUPING
GROUPING_ID
hierarchyid
IDENTITY (Function)
IDENTITY (Property)
IDENT_SEED
INDEXKEY_PROPERTY
INDEXPROPERTY
INDEX_COL
IS_MEMBER
IS_SRVROLEMEMBER
Key_GUID
Key_ID
KEY_NAME
KILL QUERY NOTIFICATION SUBSCRIPTION
KILL STATS JOB
LOGINPROPERTY
MIN_ACTIVE_ROWVERSION
MOVE CONVERSATION
NEWSEQUENTIALID()
NTILE
OBJECTPROPERTY
OBJECTPROPERTYEX
OBJECT_DEFINITION
OBJECT_ID
OBJECT_NAME
OBJECT_SCHEMA_NAME
ODBC Scalar Functions
OPEN MASTER KEY
OPEN SYMMETRIC KEY
ORIGINAL_DB_NAME
ORIGINAL_LOGIN
OVER Clause
PARSENAME
PathName
POWER
Predicate
PUBLISHINGSERVERNAME
RAISERROR
RECEIVE
RECONFIGURE
REVERT
rowversion
ROW_NUMBER
SCHEMA_ID
SCHEMA_NAME
SCOPE_IDENTITY
SEND
SERVERPROPERTY
SESSIONPROPERTY
SESSION_USER
SET @local_variable
SPACE
SQL_VARIANT_PROPERTY
SWITCHOFFSET
SYMKEYPROPERTY
sys.fn_builtin_permissions
sys.fn_translate_permissions
sys.fn_validate_plan_guide
sys.fn_xe_file_target_read_file
sys.login_token
sys.user_token
SYSTEM_USER
TERTIARY_WEIGHTS
TYPEPROPERTY
TYPE_ID
TYPE_NAME
UNICODE
UPDATE STATISTICS
UPDATE()
USER
VARP
WITH common_table_expression
XACT_STATE

Backup
BACKUP
BACKUP CERTIFICATE
BACKUP MASTER KEY
BACKUP SERVICE MASTER KEY
RESTORE Statements for Restoring, Recovering, and Managing Backups

Column
COLUMNPROPERTY
COLUMNS_UPDATED
COL_LENGTH
COL_NAME

Comparison
ALL
AND
ANY
BETWEEN
CASE
CONTAINS
DIFFERENCE
ELSE (IF...ELSE)
EXCEPT and INTERSECT
EXISTS
IF...ELSE
IN
IS [NOT] NULL
ISNULL
LIKE
NOT
NULLIF
OR
Search Condition
SOME | ANY
SOUNDEX
WHERE

Cursor
CLOSE
cursor
Cursors
CURSOR_STATUS
DEALLOCATE
DECLARE CURSOR
FETCH
FOR Clause
OPEN

Data transfer
BULK INSERT
INTO Clause

Datatype
binary and varbinary
bit
CHAR
char and varchar
Data Types
date
datetime
datetime2
decimal and numeric
float and real
image
int, bigint, smallint, and tinyint
money and smallmoney
NCHAR
nchar and nvarchar
ntext, text, and image
numeric
real
smalldatetime
smallint
smallmoney
sql_variant
table
text
tinyint
uniqueidentifier
varbinary
varchar

Date
DATEADD
DATEDIFF
DATENAME
DATEPART
datetimeoffset
DAY
GETDATE
GETUTCDATE
ISDATE
MONTH
SYSDATETIME
SYSDATETIMEOFFSET
SYSUTCDATETIME
time
TODATETIMEOFFSET
YEAR

DDL
ALTER Statements
CREATE Statements
DROP Statements

DML
DELETE
INSERT
TRUNCATE TABLE
UPDATE

Encryption
CRYPT_GEN_RANDOM
DECRYPTBYASYMKEY
DECRYPTBYCERT
DECRYPTBYKEY
DECRYPTBYKEYAUTOASYMKEY
DECRYPTBYKEYAUTOCERT
DECRYPTBYPASSPHRASE
ENCRYPTBYASYMKEY
ENCRYPTBYCERT
ENCRYPTBYKEY
ENCRYPTBYPASSPHRASE
HashBytes

Function
Functions
RETURN

Geometry
geography
geometry

Informational
System Stored Procedures
System Tables
System Views

Math
ABS
ACOS
ASIN
ATAN
ATN2
AVG
CEILING
CHECKSUM
CHECKSUM_AGG
COALESCE
COMPUTE
COS
COT
COUNT
COUNT_BIG
EXP
FLOOR
LOG
LOG10
MIN
PI
RADIANS
RAND
RANK
ROUND
ROWCOUNT_BIG
SIGN
SIN
SQRT
SQUARE
STDEV
STDEVP
SUM
TAN

Numeric
ISNUMERIC

Operator
(Backslash)
!< (Not Less Than)
!= (Not Equal To)
!> (Not Greater Than)
% (Modulo)
% (Wildcard - Character(s) to Match)
%= (Modulo EQUALS)
& (Bitwise AND)
&= (Bitwise AND EQUALS)
* (Multiply)
*= (Multiply EQUALS)
+ (Add)
+ (String Concatenation)
+ (Unary Plus)
+= (Add EQUALS)
+= (String Concatenation)
- (Negative)
- (Subtract)
-- (Comment)
-= (Subtract EQUALS)
/ (Divide)
/*...*/ (Comment)
/= (Divide EQUALS)
< (Less Than)
<= (Less Than or Equal To)
<> (Not Equal To)
= (Equals)
> (Greater Than)
>= (Greater Than or Equal To)
Compound Operators
Operators
[ ] (Wildcard - Character(s) to Match)
[^] (Wildcard - Character(s) Not to Match)
^ (Bitwise Exclusive OR)
^= (Bitwise Exclusive OR EQUALS)
_ (Wildcard - Match One Character)
| (Bitwise OR)
|= (Bitwise OR EQUALS)
~ (Bitwise NOT)

Procedure
Constants
GOTO
OUTPUT Clause
SET
TRY...CATCH
VAR
WAITFOR
WHILE

Remote query
OPENDATASOURCE
OPENQUERY
OPENROWSET

Security
ADD SIGNATURE
DENY
EXECUTE AS
EXECUTE AS Clause
GRANT
HAS_DBACCESS
HAS_PERMS_BY_NAME
IS_OBJECTSIGNED
PERMISSIONS
RESTORE MASTER KEY
RESTORE SERVICE MASTER KEY
REVOKE
SETUSER
SignByAsymKey
SignByCert
sys.fn_check_object_signatures
VerifySignedByAsymKey
VerifySignedByCert

Server variable
@@CONNECTIONS
@@CPU_BUSY
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@FETCH_STATUS
@@IDENTITY
@@IDLE
@@IO_BUSY
@@LANGID
@@LANGUAGE
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@microsoftversion
@@NESTLEVEL
@@OPTIONS
@@PACKET_ERRORS
@@PACK_RECEIVED
@@PACK_SENT
@@PROCID
@@REMSERVER
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TEXTSIZE
@@TIMETICKS
@@TOTAL_ERRORS
@@TOTAL_READ
@@TOTAL_WRITE
@@TRANCOUNT
@@VERSION
APP_NAME
CURRENT_REQUEST_ID
CURRENT_TIMESTAMP
CURRENT_USER
DB_ID
DB_NAME
ERROR_LINE
ERROR_MESSAGE
ERROR_NUMBER
ERROR_PROCEDURE
ERROR_SEVERITY
ERROR_STATE
HOST_ID
HOST_NAME
IDENT_CURRENT
IDENT_INCR
NEWID
SUSER_ID
SUSER_NAME
SUSER_SID
SUSER_SNAME
USER_ID
USER_NAME

Status
APPLOCK_MODE
APPLOCK_TEST
ASSEMBLYPROPERTY
BINARY_CHECKSUM
CONNECTIONPROPERTY
CONTEXT_INFO
EVENTDATA
STATS_DATE

String
ASCII
CAST and CONVERT
CHARINDEX
CONVERT
LEFT
LEN
LOWER
LTRIM
MAX
PATINDEX
QUOTENAME
READTEXT
REPLACE
REPLICATE
REVERSE
RIGHT
RTRIM
STR
STUFF
SUBSTRING
UPPER
WRITETEXT

Text
FREETEXT
FREETEXTTABLE
FULLTEXTCATALOGPROPERTY
FULLTEXTSERVICEPROPERTY
TEXTPTR
TEXTVALID
UPDATETEXT

Tracing
fn_trace_geteventinfo
fn_trace_getfilterinfo
fn_trace_getinfo
fn_trace_gettable
Trace Flags

Transaction
BEGIN CONVERSATION TIMER
BEGIN DIALOG CONVERSATION
BEGIN DISTRIBUTED TRANSACTION
BEGIN TRANSACTION
BEGIN...END
BREAK
CATCH (TRY...CATCH)
CHECKPOINT
COMMIT TRANSACTION
COMMIT WORK
CONTINUE
DECLARE @local_variable
END (BEGIN...END)
ROLLBACK TRANSACTION
ROLLBACK WORK
SAVE TRANSACTION
Transactions

Trigger
DISABLE TRIGGER
ENABLE TRIGGER
TRIGGER_NESTLEVEL

TSQL
EXECUTE
FROM
GO
GROUP BY
HAVING
Hints
KILL
MERGE
OPTION Clause
ORDER BY Clause
PRINT
Reserved Keywords
SELECT
SELECT @local_variable
SHUTDOWN
TOP
Transact-SQL Syntax Conventions
Tutorial: Writing Transact-SQL Statements
UNION
USE

XML
OPENXML
WITH XMLNAMESPACES
xml
xml_schema_namespace