SUM and Addition of Null

Question

Post reply

SUM and Addition of Null

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Thanks for the question. An easy one considering the available answer options 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

David Conn SSCertifiable Points: 6010 More actions · Answer 2

Thanks. I enjoyed this question. Had to think about the '' but got there in the end.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

manik_anu SSCrazy Points: 2377 More actions · Answer 4

nice question, really thingable one....:-D

Manik
You cannot get to the top by sitting on your bottom.

Neeraj Prasad Sharma Ten Centuries Points: 1315 More actions · Answer 5

select '1' as num1, '' as num2

tricky part but 1+

Neeraj Prasad Sharma
Sql Server Tutorials