I around 10 Free Online Training Codes available of .NET and SQL Training from Pluralsight. I am willing to give it to someone who wants learn technology this weekend. You just have to go to my Facebook page and leave a comment explaining in one line – what course will you learn during weekend. I will send all this codes to 10 winners whom I will randomly select using Facebook.
Meanwhile do you know how can you generate Zero without using any numbers in T-SQL. My friend Madhivanan has done that and I find it very interesting.Run following T-SQL code – ‘SELECT $’. He has written many other tricks how to generate zero also on his blog.
On another note – I have published my answer for question about SELECT * vs SELECT COUNT(*) here.
Reference: Pinal Dave (https://blog.sqlauthority.com)
22 Comments. Leave new
try this
select count(cast(null as int))
or
any false condition
select count(*) where ‘a’=’b’
It ‘s really good.
FYI –
Your Hyperlink for SELECT * vs SELECT COUNT(*) here is not working.
It is going to URL — *%20vs%20SELECT%20COUNT%28*%29
Please update accordingly.
It seems every currency symbol that SQL Server supports. Return the same value as zero
i tried some as
select €
select ¥
select £
that’s great, pinaldave…
that post. produce zero without using numbers is great.
Hi Pinal,
I’m interested in online training on “Core Silverlight 4” from Pluralsight. Please consider me among intersted participants.
Regards
Vivek Srivastava
Sir, Kindly consider me for this online training for SQL. Your blog is very helpful for the ppl like us.. Thanks a lot.. :)
select count(*)-count(*)
;))
you know what, i went to the site at the same day you posted the link for free TSQL, and happened to sign up with the sight, nice teaching. but no in-depth explanations or real time scenarios for MSBI sessions.
do you know any site or place (including SOLIDQ, where you teach) where we can see end-to-end dwh development. like explaining starting from requirement specifications and then coming up for a solutions, rather than just learning technical. I mean total business perspective, that is real useful for students. if possible you implement the approach. at least give an insight.
its just a suggestion.
Hi Pinal,
I am interested to learn Web Services (WCF) in .NET. Kindly share me some tutorials for this.
TnR,
Satish
Thanks sir, I am eager to Learn .Net with SQL. Thanks for your helpful information.
select COUNT (*)-COUNT(*)
answer is 0.00
Hi PinalDave–I would like to learn SSIS in SQL 2008, please. One of your codes would be very helpful.
Thank you,
Karen in NW Arkansas
Another way for generate zero.
select Ascii(‘Y’)-Ascii(‘Y’)
OR
select LEN(”)
I like Madhivanan’s answer. and it was awesome.
Hie Pinal Sir..
I intersted to learn .net webservices.
If you please revert me some link that help me.
That would be very helpful for my career.
Zubair
I intersted to learn .net webservices.
i interest in MSSQL tunning
I am interested to learn .net webservices. pl. send us your deatils
how does these tricks usefull in real life
Hi Pinal,
Hello, actually i am trying to get into the IT field. I am an engineer with experience in Industrial electronics for a long time.
I want to learn SQL. Do guide me in my new venture.
Thanks
Sunil
SQL course is good to learn in online training and we can learn how to generate Zero without using any numbers in T-SQL it is very important to learn.