SQL SERVER – Free Online Training on .net and SQL

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)

Best Practices
Previous Post
SQL SERVER – Solution – Puzzle – SELECT * vs SELECT COUNT(*)
Next Post
SQL SERVER – Solution – Puzzle – Statistics are not Updated but are Created Once

Related Posts

22 Comments. Leave new

  • try this

    select count(cast(null as int))

    or

    any false condition

    select count(*) where ‘a’=’b’

    Reply
  • Varinder Sandhu
    June 16, 2011 12:05 pm

    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.

    Reply
  • Varinder Sandhu
    June 16, 2011 12:21 pm

    It seems every currency symbol that SQL Server supports. Return the same value as zero

    i tried some as

    select €
    select ¥
    select £

    Reply
  • PeterPatrickGo
    June 16, 2011 12:26 pm

    that’s great, pinaldave…
    that post. produce zero without using numbers is great.

    Reply
  • Vivek Srivastava
    June 16, 2011 1:26 pm

    Hi Pinal,
    I’m interested in online training on “Core Silverlight 4” from Pluralsight. Please consider me among intersted participants.

    Regards
    Vivek Srivastava

    Reply
  • Sir, Kindly consider me for this online training for SQL. Your blog is very helpful for the ppl like us.. Thanks a lot.. :)

    Reply
  • select count(*)-count(*)

    ;))

    Reply
  • 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.

    Reply
  • Satish Boddapati
    June 17, 2011 12:25 pm

    Hi Pinal,
    I am interested to learn Web Services (WCF) in .NET. Kindly share me some tutorials for this.

    TnR,
    Satish

    Reply
  • .Net Online Training
    June 17, 2011 3:02 pm

    Thanks sir, I am eager to Learn .Net with SQL. Thanks for your helpful information.

    Reply
  • select COUNT (*)-COUNT(*)

    answer is 0.00

    Reply
  • Karen Dunning
    June 19, 2011 12:25 pm

    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

    Reply
  • Another way for generate zero.

    select Ascii(‘Y’)-Ascii(‘Y’)
    OR
    select LEN(”)

    I like Madhivanan’s answer. and it was awesome.

    Reply
  • 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

    Reply
  • gowri shankar
    April 4, 2012 10:52 am

    I intersted to learn .net webservices.

    Reply
  • i interest in MSSQL tunning

    Reply
  • I am interested to learn .net webservices. pl. send us your deatils

    Reply
  • how does these tricks usefull in real life

    Reply
  • 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

    Reply
  • satyanaryana raju
    November 24, 2016 6:27 pm

    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.

    Reply

Leave a Reply

Menu
Exit mobile version