SQL Queries
Oct 26, 2020
- 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)
declare @CompanyId int
set @CompanyId = NULL
select COUNT(*) from UserActivity
where (CompanyId = @CompanyId or @CompanyId is null)
Distraction-free reading. No ads.
Organize your knowledge with lists and highlights.
Tell your story. Find your audience.
Read member-only stories
Support writers you read most
Earn money for your writing
Listen to audio narrations
Read offline with the Medium app