.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What is the use of @@VERSION statement?

Posted By :nishithraj     Posted Date :March 25, 2010    Points :10   Category :Sql Server 
@@VERSION statement returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

You can also find related Interview Question to What is the use of @@VERSION statement?  below: 

What is Version Number in Assembly Manifest ?

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

Where is version information stored of an assembly ?

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

When was the First Version of .NET Released?

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

How many Columns per INSERT statement is allowed

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

Can multiple catch blocks be executed for a single try statement?

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

What is the equivalent statement for exit in C#?

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

What is the difference between UNION ALL Statement and UNION

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

What is COMMIT and ROLLBACK statement in SQL

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

What is the purpose of @@LANGUAGE statement?

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

What is the purpose of @@FETCH_STATUS statement in T-SQL?

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

What is the use of @@CPU_BUSY statement?

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

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend