What is the use of @@VERSION statement?

A revision and build number in an assemblies is called Version Number.

There are Major and Minor Version number in an assembly. you can change this version number in assemblyinfo.cs file
usually version number looks like this in assemblyinfo.cs
1.0.*

The common language run time uses these numbers to enforce version policy. (More...)

Version information is stored in assembly in manifest. (More...)

The first version of .Net that is 1.0 SDK was released on 15 Jan,2002. (More...)

4096 Columns allowed in per Insert SQL (More...)

No. Once the proper catch block processed, control is transferred to the finally block (if any).

So we can not execute multiple catch block in one try block (More...)

4096 (More...)

Application.Exit() or System.Environment.Exit (More...)

The main difference between UNION ALL statement and UNION is UNION All statement is much faster than UNION.
Reason : Because UNION ALL statement does not look for duplicate rows, but on the other hand UNION statement does look for duplicate rows, whether or not they exist. (More...)

Commit statement helps in termination of the current transaction and do all the changes that occur in transaction persistent and this also commits all the changes to the database.
ROLLBACK do the same thing just terminate the currenct transaction but one another thing is that the changes made to database are ROLLBACK to the database. (More...)

SSIS (More...)

Truncation statement cannot be rolled back (More...)

To know the current language used. (More...)

To know the status of the last cursor FETCH statement issued against any cursor currently opened by the connection (More...)

@@CPU_BUSY returns the time that SQL Server has spent working since it was last started. (More...)