can you any body tell me which service pack is installed in
the sql server?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is unique key constraint?
How to create logins using windows Authentication mode?
How can we Use Linked Server? Uses of Linked server
What is an expression in ms sql server?
Explain about nested stored procedure?
Explain the steps needed to create a scheduled job?
What is indexed view?
What are the purposes of floor and sign functions?
Explain the concept of view and Types of views in SQL server?
What is difference between joins and subqueries?
What is the order in which the SQL query is executed? list them in order.
5 Answers CarrizalSoft Technologies, CTS, Oracle,
What is the user of Primary key?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)