SQL RNNR

Blog Post

SQLSat 83 – Johannesburg

Awesome news.  I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011.  I saw that they were opening up the presentation schedule a little...

2011-04-28

1 reads

Blog Post

SQLPeople Interview

Have you heard about this new project out there called SQLPeople?  It is a new (relatively) project that is the brainchild of Andy Leonard.  Andy is trying to help...

2011-04-25

4 reads

Blog Post

SSIS Job Ownership

I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan.  That evolved into finding out who owns the the...

2011-04-11

21 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

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

Azure elastic query credential question

By cphite

I am trying to check out elastic query between two test instances we have...

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