SQL Queries

vishal gupta
Oct 26, 2020

--

  1. Use below query when you want to check column having Null values

declare @CompanyId int

set @CompanyId = NULL

select COUNT(*) from UserActivity

where (CompanyId = @CompanyId or @CompanyId is null)

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

vishal gupta
vishal gupta

Written by vishal gupta

Software Architect, Author, Trainer

No responses yet

Write a response