SQL SERVER – Solution – Generating Zero Without using Any Numbers in T-SQL
- by pinaldave
SQL Server MVP and my friend My friend Madhivanan has asked very interesting question on his blog regarding How to Generate Zero without using Any Numbers in T-SQL. He has demonstrated various methods how one can generate Zero. When I posted note regarding how one he has generated Zero without using number in my blog post for Free Online Training, blog readers have come up with few very interesting answers. I really found them very interesting and here I am listing them with due credit.
Special mention to Andery.ca as the answer Andery provided is the one, I myself come up with after very first look and that is why I had left the same as hint in the original article.
anil
try this
select count(cast(null as int))
or
any false condition
select count(*) where ‘a’=’b’
Varinder Sandhu
It seems every currency symbol that SQL Server supports. Return the same value as zero
i tried some as
select €
select ¥
select £
Andrey.ca
select count(*)-count(*)
Vinay Kumar
Another way for generate zero.
select Ascii(‘Y’)-Ascii(‘Y’)
OR
select LEN(”)
I like Madhivanan’s answer. and it was awesome.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Filed under: PostADay, Readers Contribution, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology
