How To Return A Dummy Row Instead Of Empty Results In SQL Server

แชร์
ฝัง
  • เผยแพร่เมื่อ 19 พ.ย. 2024

ความคิดเห็น • 6

  • @douglascoats7081
    @douglascoats7081 7 วันที่ผ่านมา +1

    Whenever i try using your dummy row suggestion it just keeps returning my name :/

    • @ErikDarlingData
      @ErikDarlingData  6 วันที่ผ่านมา

      at least it doesn't keep saying "your mom"

  • @adrian_sanchez
    @adrian_sanchez 7 วันที่ผ่านมา +1

    Cool trick. Normally I have to handle this on the app side. Probably because i never had this in my bag of tricks. Like you if i had to keep one, it's going to be the 2nd version.....I will say after disecting, the *"select 1/0 from d as d2"* portion is a little distracting for me. Since 1/0 doesn't do anything , i changed it on my notes to be *"select * from d as d2"* . For simplicity sake, I know I'll probably get some hate for that.

    • @ErikDarlingData
      @ErikDarlingData  7 วันที่ผ่านมา

      You can do whatever you’d like. It’s not like I have a copyright on it.

  • @stephenlawrenson2380
    @stephenlawrenson2380 7 วันที่ผ่านมา +1

    Where’s my T???😂😂

    • @ErikDarlingData
      @ErikDarlingData  7 วันที่ผ่านมา

      You’ll have to get that checked by a licensed physician.