Transact sql zero if null

Tom Robinson Tom Robinson 1, 1 1 gold badge 14 14 silver badges 13 13 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. Related Hot Network Questions.

Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings. A value expression that contains a subquery is considered non-deterministic and the subquery is evaluated twice. This result is in compliance with the SQL standard. In either case, different results can be returned between the first evaluation and upcoming evaluations. As a result, you can get different results depending on the isolation level of the query. As an alternative, you can rewrite the query to push the subquery into a subselect as shown in the following example:.

Data type determination of the resulting expression is different. Improve this question. Germstorm 9, 14 14 gold badges 63 63 silver badges 83 83 bronze badges. Karl Karl 1, 4 4 gold badges 13 13 silver badges 16 16 bronze badges. What type of database? Add a comment. Active Oldest Votes. Improve this answer. This would be valid if count returned NULL for no records. However count returns 0. Firo I am not sure if I have understood your exact problem, but in sqlserver on a left join, you will get a count as 0 if your query is something like this: select t1.

That's a good point. Rate this:. Like this: Like Loading Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public. Name required.

Find us on Facebook.