What is the command used to get the version of sql server?



What is the command used to get the version of sql server?..

Answer / anindya basu

SELECT @@VERSION AS CurVersion

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,


Differnce between sel server 2000 and 2005

3 Answers  


Do you know what is a with(nolock)?

0 Answers  


What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,


What is the purpose of sql profiler in sql server?

0 Answers  






how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,


What is nolock?

0 Answers  


Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,


explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  


select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  


Explain the benefits of user-defined functions?

0 Answers  


What is use of except clause? How does it differ from not in clause?

0 Answers  


Categories