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)