ANY (Transact-SQL)

MSDN Home

MSDN
MSDN Library
Servers and Enterprise Develop ...
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Transact-SQL Reference

Transact-SQL Reference

Transact-SQL Syntax Convention ...
Tutorial: Writing Transact-SQL ...
+ (Add) (Transact-SQL)
+ (Unary Plus) (Transact-SQL)
+ (String Concatenation) (Tran ...
+= (Add EQUALS) (Transact-SQL)
+= (String Concatenation) (Tra ...
- (Negative) (Transact-SQL)
- (Subtract) (Transact-SQL)
-= (Subtract EQUALS) (Transact ...
* (Multiply) (Transact-SQL)
*= (Multiply EQUALS) (Transact ...
/ (Divide) (Transact-SQL)
/= (Divide EQUALS) (Transact-S ...
\ (Backslash) (Transact-SQL)
% (Modulo) (Transact-SQL)
%= (Modulo EQUALS) (Transact-S ...
% (Wildcard - Character(s) to ...
& (Bitwise AND) (Transact-SQL)
&= (Bitwise AND EQUALS) (Trans ...
| (Bitwise OR) (Transact-SQL)
|= (Bitwise OR EQUALS) (Transa ...
^ (Bitwise Exclusive OR) (Tran ...
^= (Bitwise Exclusive OR EQUAL ...
~ (Bitwise NOT) (Transact-SQL)
= (Equals) (Transact-SQL)
> (Greater Than) (Transact- ...
< (Less Than) (Transact-SQL ...
>= (Greater Than or Equal T ...
<= (Less Than or Equal To) ...
<> (Not Equal To) (Trans ...
!< (Not Less Than) (Transac ...
!= (Not Equal To) (Transact-SQ ...
!> (Not Greater Than) (Tran ...
-- (Comment) (Transact-SQL)
/*...*/ (Comment) (Transact-SQ ...
[ ] (Wildcard - Character(s) t ...
[^] (Wildcard - Character(s) N ...
_ (Wildcard - Match One Charac ...
$PARTITION (Transact-SQL)
@@CONNECTIONS (Transact-SQL)
@@CPU_BUSY (Transact-SQL)
@@CURSOR_ROWS (Transact-SQL)
@@DATEFIRST (Transact-SQL)
@@DBTS (Transact-SQL)
@@ERROR (Transact-SQL)
@@FETCH_STATUS (Transact-SQL)
@@IDENTITY (Transact-SQL)
@@IDLE (Transact-SQL)
@@IO_BUSY (Transact-SQL)
@@LANGID (Transact-SQL)
@@LANGUAGE (Transact-SQL)
@@LOCK_TIMEOUT (Transact-SQL)
@@MAX_CONNECTIONS (Transact-SQ ...
@@MAX_PRECISION (Transact-SQL)
@@NESTLEVEL (Transact-SQL)
@@OPTIONS (Transact-SQL)
@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
@@PACKET_ERRORS (Transact-SQL)
@@PROCID (Transact-SQL)
@@REMSERVER (Transact-SQL)
@@ROWCOUNT (Transact-SQL)
@@SERVERNAME (Transact-SQL)
@@SERVICENAME (Transact-SQL)
@@SPID (Transact-SQL)
@@TEXTSIZE (Transact-SQL)
@@TIMETICKS (Transact-SQL)
@@TOTAL_ERRORS (Transact-SQL)
@@TOTAL_READ (Transact-SQL)
@@TOTAL_WRITE (Transact-SQL)
@@TRANCOUNT (Transact-SQL)
@@VERSION (Transact-SQL)
ABS (Transact-SQL)
ACOS (Transact-SQL)
ADD SIGNATURE (Transact-SQL)
ALL (Transact-SQL)
ALTER Statements (Transact-SQL ...
AND (Transact-SQL)
ANY (Transact-SQL)
APPLOCK_MODE (Transact-SQL)
APPLOCK_TEST (Transact-SQL)
APP_NAME (Transact-SQL)
ASCII (Transact-SQL)
ASIN (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL ...
ASYMKEY_ID (Transact-SQL)
ASYMKEYPROPERTY (Transact-SQL)
ATAN (Transact-SQL)
ATN2 (Transact-SQL)
AVG (Transact-SQL)
BACKUP (Transact-SQL)
BACKUP CERTIFICATE (Transact-S ...
BACKUP MASTER KEY (Transact-SQ ...
BACKUP SERVICE MASTER KEY (Tra ...
BEGIN...END (Transact-SQL)
BEGIN CONVERSATION TIMER (Tran ...
BEGIN DIALOG CONVERSATION (Tra ...
BEGIN DISTRIBUTED TRANSACTION ...
BEGIN TRANSACTION (Transact-SQ ...
BETWEEN (Transact-SQL)
binary and varbinary (Transact ...
BINARY_CHECKSUM (Transact-SQL ...
bit (Transact-SQL)
BREAK (Transact-SQL)
BULK INSERT (Transact-SQL)
CASE (Transact-SQL)
CAST and CONVERT (Transact-SQL ...
CATCH (TRY...CATCH) (Transact- ...
CEILING (Transact-SQL)
CertProperty (Transact-SQL)
Cert_ID (Transact-SQL)
Change Data Capture Functions ...
Change Tracking Functions (Tra ...
char and varchar (Transact-SQL ...
CHAR (Transact-SQL)
CHARINDEX (Transact-SQL)
CHECKPOINT (Transact-SQL)
CHECKSUM (Transact-SQL)
CHECKSUM_AGG
CLOSE (Transact-SQL)
CLOSE MASTER KEY (Transact-SQL ...
CLOSE SYMMETRIC KEY (Transact- ...
COALESCE (Transact-SQL)
COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQ ...
COL_LENGTH (Transact-SQL)
COL_NAME (Transact-SQL)
COLUMNPROPERTY (Transact-SQL)
COLUMNS_UPDATED (Transact-SQL)
COMMIT TRANSACTION (Transact-S ...
COMMIT WORK (Transact-SQL)
Compound Operators (Transact-S ...
COMPUTE (Transact-SQL)
CONNECTIONPROPERTY (Transact-S ...
Constants (Transact-SQL)
CONTAINS (Transact-SQL)
CONTAINSTABLE (Transact-SQL)
CONTINUE (Transact-SQL)
CONTEXT_INFO (Transact-SQL)
Control-of-Flow Language (Tran ...
CONVERT (Transact-SQL)
COS (Transact-SQL)
COT (Transact-SQL)
COUNT (Transact-SQL)
COUNT_BIG (Transact-SQL)
CREATE Statements (Transact-SQ ...
CRYPT_GEN_RANDOM (Transact-SQL ...
CURRENT_REQUEST_ID (Transact-S ...
CURRENT_TIMESTAMP (Transact-SQ ...
CURRENT_USER (Transact-SQL)
cursor (Transact-SQL)
CURSOR_STATUS (Transact-SQL)
Cursors (Transact-SQL)
Data Collector Functions (Tra ...
Data Types (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transac ...
DATABASEPROPERTY (Transact-SQL ...
DATABASEPROPERTYEX (Transact-S ...
DATALENGTH (Transact-SQL)
date (Transact-SQL)
DATEADD (Transact-SQL)
DATEDIFF (Transact-SQL)
DATENAME (Transact-SQL)
DATEPART (Transact-SQL)
datetime (Transact-SQL)
datetime2 (Transact-SQL)
datetimeoffset (Transact-SQL)
DAY (Transact-SQL)
DB_ID (Transact-SQL)
DB_NAME (Transact-SQL)
DBCC (Transact-SQL)
DEALLOCATE (Transact-SQL)
decimal and numeric (Transact- ...
DECLARE @local_variable (Trans ...
DECLARE CURSOR (Transact-SQL)
DECRYPTBYASYMKEY (Transact-SQL ...
DECRYPTBYCERT (Transact-SQL)
DECRYPTBYKEY (Transact-SQL)
DECRYPTBYKEYAUTOASYMKEY (Trans ...
DECRYPTBYKEYAUTOCERT (Transact ...
DECRYPTBYPASSPHRASE (Transact- ...
DEGREES (Transact-SQL)
DELETE (Transact-SQL)
DENSE_RANK (Transact-SQL)
DENY (Transact-SQL)
DIFFERENCE (Transact-SQL)
DISABLE TRIGGER (Transact-SQL)
DROP Statements (Transact-SQL)
ELSE (IF...ELSE) (Transact-SQL ...
ENABLE TRIGGER (Transact-SQL)
ENCRYPTBYASYMKEY (Transact-SQL ...
ENCRYPTBYCERT (Transact-SQL)
ENCRYPTBYKEY (Transact-SQL)
ENCRYPTBYPASSPHRASE (Transact- ...
END (BEGIN...END) (Transact-SQ ...
END CONVERSATION (Transact-SQL ...
ERROR_LINE (Transact-SQL)
ERROR_MESSAGE (Transact-SQL)
ERROR_NUMBER (Transact-SQL)
ERROR_PROCEDURE (Transact-SQL)
ERROR_SEVERITY (Transact-SQL)
ERROR_STATE (Transact-SQL)
EVENTDATA (Transact-SQL)
EXCEPT and INTERSECT (Transact ...
EXECUTE AS (Transact-SQL)
EXECUTE AS Clause (Transact-SQ ...
EXECUTE
EXISTS (Transact-SQL)
EXP (Transact-SQL)
Expressions (Transact-SQL)
FETCH (Transact-SQL)
FILE_ID (Transact-SQL)
FILE_IDEX (Transact-SQL)
FILE_NAME (Transact-SQL)
FILEGROUP_ID (Transact-SQL)
FILEGROUP_NAME (Transact-SQL)
FILEGROUPPROPERTY (Transact-SQ ...
FILEPROPERTY (Transact-SQL)
float and real (Transact-SQL)
FLOOR (Transact-SQL)
sys.fn_check_object_signatures ...
fn_get_audit_file (Transact-SQ ...
fn_get_sql (Transact-SQL)
fn_helpcollations (Transact-SQ ...
fn_listextendedproperty (Trans ...
sys.fn_xe_file_target_read_fil ...
fn_my_permissions (Transact-SQ ...
fn_servershareddrives (Transac ...
fn_trace_geteventinfo (Transac ...
fn_trace_getfilterinfo (Transa ...
fn_trace_getinfo (Transact-SQL ...
fn_trace_gettable (Transact-SQ ...
fn_virtualfilestats (Transact- ...
fn_virtualservernodes (Transac ...
FOR Clause (Transact-SQL)
FORMATMESSAGE (Transact-SQL)
FREETEXT (Transact-SQL)
FREETEXTTABLE (Transact-SQL)
FROM (Transact-SQL)
FULLTEXTCATALOGPROPERTY (Trans ...
FULLTEXTSERVICEPROPERTY (Trans ...
Functions (Transact-SQL)
geography (Transact-SQL)
geometry (Transact-SQL)
GET CONVERSATION GROUP (Transa ...
GET_FILESTREAM_TRANSACTION_CON ...
GET_TRANSMISSION_STATUS (Trans ...
GETANSINULL (Transact-SQL)
GETDATE (Transact-SQL)
GETUTCDATE (Transact-SQL)
GO (Transact-SQL)
GOTO (Transact-SQL)
GRANT (Transact-SQL)
GROUP BY (Transact-SQL)
GROUPING (Transact-SQL)
GROUPING_ID (Transact-SQL)
HAS_DBACCESS (Transact-SQL)
HAS_PERMS_BY_NAME (Transact-SQ ...
HASHBYTES (Transact-SQL)
HAVING (Transact-SQL)
hierarchyid (Transact-SQL)
Hints (Transact-SQL)
HOST_ID (Transact-SQL)
HOST_NAME (Transact-SQL)
IDENT_CURRENT (Transact-SQL)
IDENT_INCR (Transact-SQL)
IDENT_SEED (Transact-SQL)
IDENTITY (Function) (Transact- ...
IDENTITY (Property) (Transact- ...
IF...ELSE (Transact-SQL)
image (Transact-SQL)
IN (Transact-SQL)
INDEXKEY_PROPERTY (Transact-SQ ...
INDEXPROPERTY (Transact-SQL)
INDEX_COL (Transact-SQL)
INSERT (Transact-SQL)
int, bigint, smallint, and tin ...
INTO Clause (Transact-SQL)
IS_MEMBER (Transact-SQL)
IS_OBJECTSIGNED (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL ...
ISDATE (Transact-SQL)
IS [NOT] NULL (Transact-SQL)
ISNULL (Transact-SQL)
ISNUMERIC (Transact-SQL)
Key_GUID (Transact-SQL)
Key_ID (Transact-SQL)
KEY_NAME (Transact-SQL)
KILL (Transact-SQL)
KILL QUERY NOTIFICATION SUBSCR ...
KILL STATS JOB (Transact-SQL)
LEFT (Transact-SQL)
LEN (Transact-SQL)
LIKE (Transact-SQL)
LOG (Transact-SQL)
LOG10 (Transact-SQL)
LOGINPROPERTY (Transact-SQL)
LOWER (Transact-SQL)
LTRIM (Transact-SQL)
MAX (Transact-SQL)
MERGE (Transact-SQL)
MIN (Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transac ...
money and smallmoney (Transact ...
MONTH (Transact-SQL)
MOVE CONVERSATION (Transact-SQ ...
NCHAR (Transact-SQL)
nchar and nvarchar (Transact-S ...
NEWID (Transact-SQL)
NEWSEQUENTIALID() (Transact-SQ ...
NOT (Transact-SQL)
ntext, text, and image (Transa ...
NTILE (Transact-SQL)
NULLIF (Transact-SQL)
numeric (Transact-SQL)
OBJECT_DEFINITION (Transact-SQ ...
OBJECT_ID (Transact-SQL)
OBJECT_NAME (Transact-SQL)
OBJECT_SCHEMA_NAME (Transact-S ...
OBJECTPROPERTY (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL ...
ODBC Scalar Functions (Transac ...
OPEN (Transact-SQL)
OPEN MASTER KEY (Transact-SQL)
OPEN SYMMETRIC KEY (Transact-S ...
OPENDATASOURCE (Transact-SQL)
OPENQUERY (Transact-SQL)
OPENROWSET (Transact-SQL)
OPENXML (Transact-SQL)
Operators (Transact-SQL)
OPTION Clause (Transact-SQL)
OR (Transact-SQL)
ORDER BY Clause (Transact-SQL)
ORIGINAL_DB_NAME (Transact-SQL ...
ORIGINAL_LOGIN (Transact-SQL)
OUTPUT Clause (Transact-SQL)
OVER Clause (Transact-SQL)
PARSENAME (Transact-SQL)
PathName (Transact-SQL)
PATINDEX (Transact-SQL)
PERMISSIONS (Transact-SQL)
PI (Transact-SQL)
POWER (Transact-SQL)
Predicate (Transact-SQL)
PRINT (Transact-SQL)
PUBLISHINGSERVERNAME (Transact ...
PWDCOMPARE (Transact-SQL)
PWDENCRYPT (Transact-SQL)
QUOTENAME (Transact-SQL)
RADIANS (Transact-SQL)
RAISERROR
RAND (Transact-SQL)
RANK (Transact-SQL)
READTEXT (Transact-SQL)
real (Transact-SQL)
RECEIVE (Transact-SQL)
RECONFIGURE (Transact-SQL)
REPLACE (Transact-SQL)
REPLICATE (Transact-SQL)
Reserved Keywords (Transact-SQ ...
RESTORE Statements for Restori ...
RESTORE MASTER KEY (Transact-S ...
RESTORE SERVICE MASTER KEY (Tr ...
RETURN (Transact-SQL)
REVERSE (Transact-SQL)
REVERT (Transact-SQL)
REVOKE (Transact-SQL)
RIGHT (Transact-SQL)
ROLLBACK TRANSACTION (Transact ...
ROLLBACK WORK (Transact-SQL)
ROUND (Transact-SQL)
ROW_NUMBER (Transact-SQL)
ROWCOUNT_BIG (Transact-SQL)
rowversion (Transact-SQL)
RTRIM (Transact-SQL)
SAVE TRANSACTION (Transact-SQL ...
SCHEMA_ID (Transact-SQL)
SCHEMA_NAME (Transact-SQL)
SCOPE_IDENTITY (Transact-SQL)
Search Condition (Transact-SQL ...
SELECT @local_variable (Transa ...
SELECT (Transact-SQL)
SEND (Transact-SQL)
SERVERPROPERTY (Transact-SQL)
SESSION_USER (Transact-SQL)
SESSIONPROPERTY (Transact-SQL)
SET @local_variable (Transact- ...
SET (Transact-SQL)
SETUSER (Transact-SQL)
SHUTDOWN (Transact-SQL)
SIGN (Transact-SQL)
SignByAsymKey (Transact-SQL)
SignByCert (Transact-SQL)
SIN (Transact-SQL)
smalldatetime (Transact-SQL)
smallint (Transact-SQL)
smallmoney (Transact-SQL)
SOME | ANY (Transact-SQL)
SOUNDEX (Transact-SQL)
SPACE (Transact-SQL)
sql_variant (Transact-SQL)
SQL_VARIANT_PROPERTY (Transact ...
SQRT (Transact-SQL)
SQUARE (Transact-SQL)
STATS_DATE (Transact-SQL)
STDEV (Transact-SQL)
STDEVP (Transact-SQL)
STR (Transact-SQL)
STUFF (Transact-SQL)
SUBSTRING (Transact-SQL)
SUM (Transact-SQL)
SUSER_ID (Transact-SQL)
SUSER_NAME (Transact-SQL)
SUSER_SID (Transact-SQL)
SUSER_SNAME (Transact-SQL)
SWITCHOFFSET (Transact-SQL)
SYSDATETIME (Transact-SQL)
SYSDATETIMEOFFSET (Transact-SQ ...
SYMKEYPROPERTY (Transact-SQL)
System Stored Procedures (Tran ...
System Tables (Transact-SQL)
System Views (Transact-SQL)
SYSUTCDATETIME (Transact-SQL)
sys.fn_builtin_permissions (Tr ...
sys.fn_translate_permissions ( ...
sys.fn_validate_plan_guide (Tr ...
sys.login_token (Transact-SQL)
sys.user_token (Transact-SQL)
SYSTEM_USER (Transact-SQL)
table (Transact-SQL)
Table Value Constructor (Trans ...
TAN (Transact-SQL)
TERTIARY_WEIGHTS (Transact-SQL ...
text (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
time (Transact-SQL)
tinyint (Transact-SQL)
TODATETIMEOFFSET (Transact-SQL ...
TOP (Transact-SQL)
Trace Flags (Transact-SQL)
Transactions (Transact-SQL)
TRY...CATCH (Transact-SQL)
TRIGGER_NESTLEVEL (Transact-SQ ...
TRUNCATE TABLE (Transact-SQL)
TYPE_ID (Transact-SQL)
TYPE_NAME (Transact-SQL)
TYPEPROPERTY (Transact-SQL)
UNICODE (Transact-SQL)
UNION (Transact-SQL)
uniqueidentifier (Transact-SQL ...
UPDATE (Transact-SQL)
UPDATE() (Transact-SQL)
UPDATE STATISTICS (Transact-SQ ...
UPDATETEXT (Transact-SQL)
UPPER (Transact-SQL)
USE (Transact-SQL)
USER (Transact-SQL)
USER_ID (Transact-SQL)
USER_NAME (Transact-SQL)
VAR (Transact-SQL)
varbinary (Transact-SQL)
varchar (Transact-SQL)
VARP (Transact-SQL)
VerifySignedByCert (Transact-S ...
VerifySignedByAsymKey (Transac ...
WAITFOR (Transact-SQL)
WHERE (Transact-SQL)
WHILE (Transact-SQL)
WITH common_table_expression ( ...
WITH XMLNAMESPACES (Transact-S ...
WRITETEXT (Transact-SQL)
XACT_STATE (Transact-SQL)
xml (Transact-SQL)
xml_schema_namespace (Transact ...
YEAR (Transact-SQL)

Switch View :

Lightweight Beta

SQL Server 2008 Books Online (October 2009)

ANY (Transact-SQL)

Compares a scalar value with a single-column set of values. For more information, see SOME | ANY (Transact-SQL).

Tags :