1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

Question Posted / ashish kumar


which command using query analyzer will give you the version of sql server and operating system? : S..

Answer / Vinita Kumari Dixit

"In Microsoft SQL Server, you can use the following command to get the server and OS versions: SELECT @@VERSION;. This will return a string containing the server edition, build number, and OS name."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

Is stored procedure faster than query?

1 Answers  

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

Explain cursor types?

1 Answers  

What are the differences between implicit and explicit cursors?

1 Answers  

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

How do I partition a table in sql?

1 Answers  

what is index? : Sql dba

1 Answers  

Which language is used in sql?

1 Answers  

Can we create table inside stored procedure?

1 Answers  

What are reports usually used for?

1 Answers  

What is recursive join in sql?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories