Set ansi null dflt on on php

You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. He loves to share and enhance his knowledge of SQL Server by spend time at newsgroups and forums, reading and writing blogs. You can contact me at s4sql sqlcommitted. This is a personal weblog.

The opinions expressed here represent my own and not those of my employer. All data and information provided on this site is for informational purposes only. Email Address:. The statement has been terminated. Share this: Facebook Twitter Pinterest. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Learn more. Ask Question. Asked 5 years, 7 months ago. Active 5 years, 7 months ago. Viewed 3k times. Improve this question. Solomon Rutzky Ashish Ashish 2 2 gold badges 14 14 silver badges 25 25 bronze badges. Thanks for your answer solomon-rutzky! Add a comment. Active Oldest Votes. Rodniko Rodniko 4, 16 16 gold badges 67 67 silver badges 91 91 bronze badges. Add a comment. Active Oldest Votes.

ID and t1. ID AND t1. Val1 OR t1. Improve this answer. Noctis Wouldn't it be t1. Val1 or t1. Val1 is null and t2. Val1 is null??? Gregbert - given and has higher precedence, I'm not sure what you think the extra pair of parentheses add. Show 1 more comment. Pravat Behuria Pravat Behuria 3 3 silver badges 3 3 bronze badges. Despite the over zealous down-voters' attempts, THIS should be the accepted answer! SWeko SWeko Joseph Stalin Joseph Stalin 31 1 1 bronze badge. What extra does this answer add to the already stated answers?