Tuesday 29 October 2013

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

This one is very important question for interview.

Here you go,

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition').

No comments:

Post a Comment