What does @@MAX_PRECISION return?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does @@MAX_PRECISION return?

Answer
The maximum precision for numeric and decimal data.
Explanation
This function returns the maximum precision for numeric and decimal data as set on the server. The default for SQL Server 2005 is 38.

(Continued on next question...)

Other Job Interview Questions

• You have upgraded your SQL Server 2000 on Windows 2000 server to SQL Server 2005 to take advantage ...
• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• In SQL Server 2005, which network protocols use endpoints?
• Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?
• How can you easily monitor to see if this assembly is being used?
• What result would you expect from this statement? Select * from dbo .MyTable
• You want to release some memory and reduce SQL Server to 3GB or RAM. How can you do this?
• What does the NULLIF function do?
• What is the result of the following query?
• What does this code return? select 6 | 7 Figure it out without running it.
• More...