can you any body tell me which service pack is installed in
the sql server?
Answer Posted / bharathi
SELECT @@VERSION
Running the above SELECT statemet will give you the version
of SQL server and its SP
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is unique key constraint?
What is role playing dimension with two examples? : sql server analysis services, ssas
What are the character string functions supported by sql server 2005?
Define normalisation?
What is a matrix in ssrs?
Explain the various types of concurrency problem?
How to configure odbc dsn with different port numbers?
What are a scheduled jobs or what is a scheduled tasks?
What is the contrast between sql and mysql?
Why truncate is ddl command?
Explain the different types of joins?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
How to generate create table script on an existing table in ms sql server?
What do you understand by recursive stored procedures?
Does partitioning help performance?