Answer: DATABASEPROPERTYEX(dtabase,property)
It will return the specified property of the specified database.
Example:-
SELECT DATABASEPROPERTYEX(Student,Version)
-->365
You can use this function to know other properties of your database.
Asked In: Many Interviews |
Alert Moderator