United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

Transact-SQL Syntax Conventions (Transact-SQL)

What's New and Enhanced in Transact-SQL (Transact-SQL)

+ (Add) (Transact-SQL)

+ (Unary Plus) (Transact-SQL)

+ (String Concatenation) (Transact-SQL)

- (Negative) (Transact-SQL)

- (Subtract) (Transact-SQL)

* (Multiply) (Transact-SQL)

/ (Divide) (Transact-SQL)

% (Modulo) (Transact-SQL)

% (Wildcard - Character(s) to Match) (Transact-SQL)

& (Bitwise AND) (Transact-SQL)

| (Bitwise OR) (Transact-SQL)

^ (Bitwise Exclusive OR) (Transact-SQL)

~ (Bitwise NOT) (Transact-SQL)

= (Equals) (Transact-SQL)

> (Greater Than) (Transact-SQL)

< (Less Than) (Transact-SQL)

>= (Greater Than or Equal To) (Transact-SQL)

<= (Less Than or Equal To) (Transact-SQL)

<> (Not Equal To) (Transact-SQL)

!< (Not Less Than) (Transact-SQL)

!= (Not Equal To) (Transact-SQL)

!> (Not Greater Than) (Transact-SQL)

-- (Comment) (Transact-SQL)

/*...*/ (Comment) (Transact-SQL)

[ ] (Wildcard - Character(s) to Match) (Transact-SQL)

[^] (Wildcard - Character(s) Not to Match) (Transact-SQL)

_ (Wildcard - Match One Character) (Transact-SQL)

$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-SQL)

@@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 APPLICATION ROLE (Transact-SQL)

ALTER ASSEMBLY (Transact-SQL)

ALTER ASYMMETRIC KEY (Transact-SQL)

ALTER AUTHORIZATION (Transact-SQL)

ALTER CERTIFICATE (Transact-SQL)

ALTER CREDENTIAL (Transact-SQL)

ALTER DATABASE (Transact-SQL)

ALTER ENDPOINT (Transact-SQL)

ALTER FULLTEXT CATALOG (Transact-SQL)

ALTER FULLTEXT INDEX (Transact-SQL)

ALTER FUNCTION (Transact-SQL)

ALTER INDEX (Transact-SQL)

ALTER LOGIN (Transact-SQL)

ALTER MASTER KEY (Transact-SQL)

ALTER MESSAGE TYPE (Transact-SQL)

ALTER PARTITION FUNCTION (Transact-SQL)

ALTER PARTITION SCHEME (Transact-SQL)

ALTER PROCEDURE (Transact-SQL)

ALTER QUEUE (Transact-SQL)

ALTER REMOTE SERVICE BINDING (Transact-SQL)

ALTER ROLE (Transact-SQL)

ALTER ROUTE (Transact-SQL)

ALTER SCHEMA (Transact-SQL)

ALTER SERVICE (Transact-SQL)

ALTER SERVICE MASTER KEY (Transact-SQL)

ALTER SYMMETRIC KEY (Transact-SQL)

ALTER TABLE (Transact-SQL)

ALTER TRIGGER (Transact-SQL)

ALTER USER (Transact-SQL)

ALTER VIEW (Transact-SQL)

ALTER XML SCHEMA COLLECTION (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)

ATAN (Transact-SQL)

ATN2 (Transact-SQL)

AVG (Transact-SQL)

BACKUP (Transact-SQL)

BACKUP CERTIFICATE (Transact-SQL)

BACKUP MASTER KEY (Transact-SQL)

BACKUP SERVICE MASTER KEY (Transact-SQL)

BEGIN...END (Transact-SQL)

BEGIN CONVERSATION TIMER (Transact-SQL)

BEGIN DIALOG CONVERSATION (Transact-SQL)

BEGIN DISTRIBUTED TRANSACTION (Transact-SQL)

BEGIN TRANSACTION (Transact-SQL)

BETWEEN (Transact-SQL)

binary and varbinary (Transact-SQL)

BINARY_CHECKSUM

bit (Transact-SQL)

BREAK (Transact-SQL)

BULK INSERT (Transact-SQL)

CASE (Transact-SQL)

CAST and CONVERT (Transact-SQL)

CATCH (TRY...CATCH) (Transact-SQL)

CEILING (Transact-SQL)

CertProperty (Transact-SQL)

Cert_ID (Transact-SQL)

char and varchar (Transact-SQL)

CHAR (Transact-SQL)

CHARINDEX (Transact-SQL)

CHECKPOINT (Transact-SQL)

CHECKSUM (Transact-SQL)

CHECKSUM_AGG (Transact-SQL)

CLOSE (Transact-SQL)

CLOSE MASTER KEY (Transact-SQL)

CLOSE SYMMETRIC KEY (Transact-SQL)

COALESCE (Transact-SQL)

COLLATE (Transact-SQL)

COLLATIONPROPERTY (Transact-SQL)

COL_LENGTH (Transact-SQL)

COL_NAME (Transact-SQL)

COLUMNPROPERTY (Transact-SQL)

COLUMNS_UPDATED (Transact-SQL)

COMMIT TRANSACTION (Transact-SQL)

COMMIT WORK (Transact-SQL)

COMPUTE (Transact-SQL)

Constants (Transact-SQL)

CONTAINS (Transact-SQL)

CONTAINSTABLE (Transact-SQL)

CONTEXT_INFO (Transact-SQL)

CONTINUE (Transact-SQL)

Control-of-Flow Language (Transact-SQL)

CONVERT (Transact-SQL)

COS (Transact-SQL)

COT (Transact-SQL)

COUNT (Transact-SQL)

COUNT_BIG (Transact-SQL)

CREATE AGGREGATE (Transact-SQL)

CREATE APPLICATION ROLE (Transact-SQL)

CREATE ASSEMBLY (Transact-SQL)

CREATE ASYMMETRIC KEY (Transact-SQL)

CREATE CERTIFICATE (Transact-SQL)

CREATE CONTRACT (Transact-SQL)

CREATE CREDENTIAL (Transact-SQL)

CREATE DATABASE (Transact-SQL)

CREATE DEFAULT (Transact-SQL)

CREATE ENDPOINT (Transact-SQL)

CREATE EVENT NOTIFICATION (Transact-SQL)

CREATE FULLTEXT CATALOG (Transact-SQL)

CREATE FULLTEXT INDEX (Transact-SQL)

CREATE FUNCTION (Transact-SQL)

CREATE INDEX (Transact-SQL)

CREATE LOGIN (Transact-SQL)

CREATE MASTER KEY (Transact-SQL)

CREATE MESSAGE TYPE (Transact-SQL)

CREATE PARTITION FUNCTION (Transact-SQL)

CREATE PARTITION SCHEME (Transact-SQL)

CREATE PROCEDURE (Transact-SQL)

CREATE QUEUE (Transact-SQL)

CREATE REMOTE SERVICE BINDING (Transact-SQL)

CREATE ROLE (Transact-SQL)

CREATE ROUTE (Transact-SQL)

CREATE RULE (Transact-SQL)

CREATE SCHEMA (Transact-SQL)

CREATE SERVICE (Transact-SQL)

CREATE STATISTICS (Transact-SQL)

CREATE SYMMETRIC KEY (Transact-SQL)

CREATE SYNONYM (Transact-SQL)

CREATE TABLE (Transact-SQL)

CREATE TRIGGER (Transact-SQL)

CREATE TYPE (Transact-SQL)

CREATE USER (Transact-SQL)

CREATE VIEW (Transact-SQL)

CREATE XML SCHEMA COLLECTION (Transact-SQL)

CURRENT_REQUEST_ID (Transact-SQL)

CURRENT_TIMESTAMP (Transact-SQL)

CURRENT_USER (Transact-SQL)

cursor (Transact-SQL)

CURSOR_STATUS (Transact-SQL)

Cursors (Transact-SQL)

DATABASEPROPERTY (Transact-SQL)

DATABASEPROPERTYEX (Transact-SQL)

DATABASE_PRINCIPAL_ID (Transact-SQL)

Data Types (Transact-SQL)

DATALENGTH (Transact-SQL)

DATEADD (Transact-SQL)

DATEDIFF (Transact-SQL)

DATENAME (Transact-SQL)

DATEPART (Transact-SQL)

Date and Time (Transact-SQL)

DAY (Transact-SQL)

DB_ID (Transact-SQL)

DB_NAME (Transact-SQL)

DBCC (Transact-SQL)

DEALLOCATE (Transact-SQL)

decimal and numeric (Transact-SQL)

DECLARE @local_variable (Transact-SQL)

DECLARE CURSOR (Transact-SQL)

DecryptByAsymKey (Transact-SQL)

DecryptByCert (Transact-SQL)

DecryptByKey (Transact-SQL)

DecryptByKeyAutoAsymKey (Transact-SQL)

DecryptByKeyAutoCert (Transact-SQL)

DecryptByPassPhrase (Transact-SQL)

DEGREES (Transact-SQL)

DELETE (Transact-SQL)

DENSE_RANK (Transact-SQL)

DENY (Transact-SQL)

DIFFERENCE (Transact-SQL)

DISABLE TRIGGER (Transact-SQL)

DROP AGGREGATE (Transact-SQL)

DROP APPLICATION ROLE (Transact-SQL)

DROP ASSEMBLY (Transact-SQL)

DROP ASYMMETRIC KEY (Transact-SQL)

DROP CERTIFICATE (Transact-SQL)

DROP CONTRACT (Transact-SQL)

DROP CREDENTIAL (Transact-SQL)

DROP DATABASE (Transact-SQL)

DROP DEFAULT (Transact-SQL)

DROP ENDPOINT (Transact-SQL)

DROP EVENT NOTIFICATION (Transact-SQL)

DROP FULLTEXT CATALOG (Transact-SQL)

DROP FULLTEXT INDEX (Transact-SQL)

DROP FUNCTION (Transact-SQL)

DROP INDEX (Transact-SQL)

DROP LOGIN (Transact-SQL)

DROP MASTER KEY (Transact-SQL)

DROP MESSAGE TYPE (Transact-SQL)

DROP PARTITION FUNCTION (Transact-SQL)

DROP PARTITION SCHEME (Transact-SQL)

DROP PROCEDURE (Transact-SQL)

DROP QUEUE (Transact-SQL)

DROP REMOTE SERVICE BINDING (Transact-SQL)

DROP ROLE (Transact-SQL)

DROP ROUTE (Transact-SQL)

DROP RULE (Transact-SQL)

DROP SCHEMA (Transact-SQL)

DROP SERVICE (Transact-SQL)

DROP SIGNATURE (Transact-SQL)

DROP STATISTICS (Transact-SQL)

DROP SYMMETRIC KEY (Transact-SQL)

DROP SYNONYM (Transact-SQL)

DROP TABLE (Transact-SQL)

DROP TRIGGER (Transact-SQL)

DROP TYPE (Transact-SQL)

DROP USER (Transact-SQL)

DROP VIEW (Transact-SQL)

DROP XML SCHEMA COLLECTION (Transact-SQL)

DUMP (Transact-SQL)

ELSE (IF...ELSE) (Transact-SQL)

ENABLE TRIGGER (Transact-SQL)

EncryptByAsymKey (Transact-SQL)

EncryptByCert (Transact-SQL)

EncryptByKey (Transact-SQL)

EncryptByPassPhrase (Transact-SQL)

END (BEGIN...END) (Transact-SQL)

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-SQL)

EXECUTE AS (Transact-SQL)

EXECUTE AS Clause (Transact-SQL)

EXECUTE (Transact-SQL)

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-SQL)

FILEPROPERTY (Transact-SQL)

float and real (Transact-SQL)

FLOOR (Transact-SQL)

fn_get_sql (Transact-SQL)

fn_helpcollations (Transact-SQL)

fn_listextendedproperty (Transact-SQL)

fn_my_permissions (Transact-SQL)

fn_servershareddrives (Transact-SQL)

fn_trace_geteventinfo (Transact-SQL)

fn_trace_getfilterinfo (Transact-SQL)

fn_trace_getinfo (Transact-SQL)

fn_trace_gettable (Transact-SQL)

fn_virtualfilestats (Transact-SQL)

fn_virtualservernodes (Transact-SQL)

FOR Clause (Transact-SQL)

FORMATMESSAGE (Transact-SQL)

FREETEXT (Transact-SQL)

FREETEXTTABLE (Transact-SQL)

FROM (Transact-SQL)

FULLTEXTCATALOGPROPERTY (Transact-SQL)

FULLTEXTSERVICEPROPERTY (Transact-SQL)

Functions (Transact-SQL)

GET CONVERSATION GROUP (Transact-SQL)

GET_TRANSMISSION_STATUS (Transact-SQL)

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)

HAS_DBACCESS (Transact-SQL)

Has_Perms_By_Name (Transact-SQL)

HashBytes (Transact-SQL)

HAVING (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-SQL)

IDENTITY (Property) (Transact-SQL)

IF...ELSE (Transact-SQL)

image (Transact-SQL)

IN (Transact-SQL)

INDEXKEY_PROPERTY (Transact-SQL)

INDEXPROPERTY (Transact-SQL)

INDEX_COL (Transact-SQL)

INSERT (Transact-SQL)

int, bigint, smallint, and tinyint (Transact-SQL)

INTO Clause (Transact-SQL)

IS_MEMBER (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)

KILL (Transact-SQL)

KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)

KILL STATS JOB (Transact-SQL)

LEFT (Transact-SQL)

LEN (Transact-SQL)

LIKE (Transact-SQL)

LOAD (Transact-SQL)

LOG (Transact-SQL)

LOG10 (Transact-SQL)

LOGINPROPERTY (Transact-SQL)

LOWER (Transact-SQL)

LTRIM (Transact-SQL)

MAX (Transact-SQL)

MIN (Transact-SQL)

MIN_ACTIVE_ROWVERSION (Transact-SQL)

money and smallmoney (Transact-SQL)

MONTH (Transact-SQL)

MOVE CONVERSATION (Transact-SQL)

NCHAR (Transact-SQL)

nchar and nvarchar (Transact-SQL)

NEWID (Transact-SQL)

NEWSEQUENTIALID()

NOT (Transact-SQL)

ntext, text, and image (Transact-SQL)

NTILE (Transact-SQL)

NULLIF (Transact-SQL)

numeric (Transact-SQL)

OBJECT_DEFINITION (Transact-SQL)

OBJECT_ID (Transact-SQL)

OBJECT_NAME (Transact-SQL)

OBJECT_SCHEMA_NAME (Transact-SQL)

OBJECTPROPERTY (Transact-SQL)

OBJECTPROPERTYEX (Transact-SQL)

OPEN (Transact-SQL)

OPEN MASTER KEY (Transact-SQL)

OPEN SYMMETRIC KEY (Transact-SQL)

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_LOGIN (Transact-SQL)

OUTPUT Clause (Transact-SQL)

OVER Clause (Transact-SQL)

PARSENAME (Transact-SQL)

PATINDEX (Transact-SQL)

PERMISSIONS (Transact-SQL)

PI (Transact-SQL)

POWER (Transact-SQL)

Predicate (Transact-SQL)

PRINT (Transact-SQL)

PUBLISHINGSERVERNAME (Transact-SQL)

QUOTENAME (Transact-SQL)

RADIANS (Transact-SQL)

RAISERROR (Transact-SQL)

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-SQL)

RESTORE Statements for Restoring, Recovering, and Managing Backups

RESTORE MASTER KEY (Transact-SQL)

RESTORE SERVICE MASTER KEY (Transact-SQL)

RETURN (Transact-SQL)

REVERSE (Transact-SQL)

REVERT (Transact-SQL)

REVOKE (Transact-SQL)

RIGHT (Transact-SQL)

ROLLBACK TRANSACTION (Transact-SQL)

ROLLBACK WORK (Transact-SQL)

ROUND (Transact-SQL)

ROWCOUNT_BIG (Transact-SQL)

ROW_NUMBER (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 (Transact-SQL)

SELECT (Transact-SQL)

SEND (Transact-SQL)

SERVERPROPERTY (Transact-SQL)

SESSION_USER (Transact-SQL)

SESSIONPROPERTY (Transact-SQL)

SET @local_variable (Transact-SQL)

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-SQL)

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)

System Stored Procedures (Transact-SQL)

System Tables (Transact-SQL)

System Views (Transact-SQL)

sys.fn_builtin_permissions (Transact-SQL)

sys.fn_translate_permissions (Transact-SQL)

sys.login_token (Transact-SQL)

sys.user_token (Transact-SQL)

SYSTEM_USER (Transact-SQL)

table (Transact-SQL)

TAN (Transact-SQL)

TERTIARY_WEIGHTS

text (Transact-SQL)

TEXTPTR (Transact-SQL)

TEXTVALID (Transact-SQL)

timestamp (Transact-SQL)

tinyint (Transact-SQL)

TOP (Transact-SQL)

Trace Flags (Transact-SQL)

Transactions (Transact-SQL)

TRY...CATCH (Transact-SQL)

TRIGGER_NESTLEVEL (Transact-SQL)

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-SQL)

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-SQL)

VerifySignedByAsmKey (Transact-SQL)

WAITFOR (Transact-SQL)

WHERE (Transact-SQL)

WHILE (Transact-SQL)

WITH common_table_expression (Transact-SQL)

WITH XMLNAMESPACES (Transact-SQL)

WRITETEXT (Transact-SQL)

XACT_STATE (Transact-SQL)

xml (Transact-SQL)

xml_schema_namespace (Transact-SQL)

YEAR (Transact-SQL)

Minimize

0 out of 5 rated this helpful - Rate this topic

@@VERSION (Transact-SQL)

SQL Server 2005

Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

Topic link icon Transact-SQL Syntax Conventions


@@VERSION

nvarchar

The information returned by @@VERSION is similar to the product name, version, platform, and file data that is returned by the xp_msver stored procedure; however, xp_msver provides more detailed information.

The following example shows returning the version information for the current installation.

SELECT @@VERSION AS 'SQL Server Version'

Reference

Configuration Functions (Transact-SQL)
xp_msver (Transact-SQL)
SERVERPROPERTY (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.