What does this return?

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

(Continued from previous question...)

What does this return?

What does this return?
declare @i int
select @i = -5
select +@i


Answer
-5

Explanation
This will return -5 as the result. The + operator functions as a unary plus operator, which means that it performs no operation on the value it preceeds.

(Continued on next question...)

Other Job Interview Questions

• What does @@textsize return?
• What are triggers? What are the different types of triggers in SQL Server 2000?
• What does SEND do in SQL Server 2005?
• You have a large table that you wish to partition to improve performance...
• Is it possible to build an index on a view
• What type of connectivity does the readpipe/makepipe utility test?
• You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• In SQL Server 2005, if you initialize a subscription using FTP, how is the password sent?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• More...