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

Answer Posted / anindya basu

SELECT @@VERSION AS CurVersion

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many columns can exist together per table?

703


Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

492


Explain steps of normalization?

525


Can you pass expressions to stored procedure parameters?

504


What is cursors?

640






What is the need for indexing?

500


What is the difference between writing data to mirrored drives versus raid5 drives

511


what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

528


Can the query output be sorted by multiple columns in ms sql server?

553


Explain how to use linked server?

565


What are sql server procedures?

545


Call by value and call by reference in procedure and function, with NOCOPY.

838


Can we delete data from a view?

544


How to retrieve error messages using odbc_errormsg()?

542


What is save transaction and save point?

622