Which command using Query Analyzer will give you the version
of SQL server and operating system?
Answer Posted / madhu
select @@version
Is This Answer Correct ? | 34 Yes | 6 No |
Post New Answer View All Answers
What stored by the msdb? : sql server database administration
What is the user of Primary key?
How does the report manager work in SSRS?
can you instantiate a com object by using t-sql? : Sql server database administration
Can you use order by when defining a view?
Difference between Sql server reporting services and Crystal reports?
How can you check the level of fragmentation on a table?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain table valued parameters in sql server? Why tvp used?
Can sql servers link to other servers like oracle?
What is a livelock?
What are the advantages of having an index on the sql server?
What is the maximum size of sql server database?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is the difference between having clause and where clause in sql server?