SQL Swimmer

Blog Post

Will You Vote?

Voting is one of the many privileges that I have as an American citizen.  It’s a privilege that most Americans...

2013-09-23

563 reads

Blog Post

Saving Grace

According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...

2013-05-30

1,232 reads

Blog Post

Certifiable?

I have recently begun to contemplate pursuing the MCSA Certification.  I have been working with SQL Server for almost 20...

2013-05-17

613 reads

Blog Post

Mentoring

I’m putting my money where my mouth is, with respect to my last blog post.  I am officially a mentor...

2012-08-24

634 reads

Blog Post

Paying it Forward

My company has recently put forth an effort to hire fresh college graduates and interns.  I think this is a...

2012-08-24 (first published: )

1,725 reads

Blogs

Modify Power BI page visibility and active status with Semantic Link Labs

By

Setting page visibility and the active page are often overlooked last steps when publishing...

T-SQL Tuesday #190–Mastering a New Technical Skill

By

It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...

Getting Started with the MSSQL AI Agent in VS Code

By

Recently I was working in VS Code and I saw a walkthrough for the...

Read the latest Blogs

Forums

Laptop on Rent in Bangalore – Flexible & Affordable Solutions

By SRITTECH

Looking for a laptop on rent in Bangalore? Renting laptops is a smart choice...

Password Guidance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Password Guidance

Using table variables in T-SQL

By Alessandro Mortola

Comments posted to this topic are about the item Using table variables in T-SQL

Visit the forum

Question of the Day

Using table variables in T-SQL

What happens if you run the following code in SQL Server 2022+?

declare @t1 table (id int);

insert into @t1 (id) values (NULL), (1), (2), (3);

select count(*)
from @t1
where @t1.id is distinct from NULL;
 

See possible answers