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

Question Posted / dalveer singh

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

More SQL Server Interview Questions

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

Do you know the isolation level that sql server support?

What is side by side migration in sql server?

find 2nd highest salary of person using cursor concept?

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

What is right outer join in sql server joins?

What are the underflow and overflow behaviors on float literals?

What is the difference between a view and a stored procedure?

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

List out the difference between union and union all in sql server?

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

What is index fragmentation in ms sql server?

For more SQL Server Interview Questions Click Here