select @@version

Which command using Query Analyzer will give you the version
of SQL server and operating system?

Question Posted / madhu

Answer Posted / madhu

select @@version

Is This Answer Correct ?

34 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are approximate numeric data types in ms sql server?

1099

Where are sql server user names and passwords stored in sql server?

1150

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1990

How to generate create view script on an existing view?

1033

Explain the stored procedure?

1092

What is a coalesce function?

1244

tell me the disaster recovery plan

2558

Tell me something about security and sql azure?

116

What are the underflow and overflow behaviors on float literals?

1163

What will happen if a column containing char type data is changed to the nchar data type?

1146

can a database be shrunk with users active? : Sql server administration

1058

How to use values from other tables in update statements in ms sql server?

1177

How to install sql server 2005 express edition?

1166

Are null values the same as that of zero or a blank space?

1087

What is the latest version of microsoft sql server?

1108