Home
|
Tutorial
|
Articles
|
Forum
|
Interview Question
|
Code Snippets
|
News
|
Fun Zone
|
Poll
|
Web Links
|
Certification
|
Search
Welcome :
Guest
Sign In
Register
Win Surprise Gifts!!!
Congratulations!!!
Top 5 Contributors of the Month
ffttt
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...)
The maximum number of column per SELECT Statement?
4096
(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's the latest version of DTS?
SSIS
(More...)
There is a DELETE statement inside a transaction. What happens if the transaction is rolled back?
Truncation statement cannot be rolled back
(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