There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

As we know, automatically created statistics, as can be see with

SELECT * FROM sys.Stats WHERE object_id LIKE OBJECT_ID('MyTable')

(only change 'MyTable' for something else), has name starting with _WA_Sy_....

As we know, automatically created statistics, as can be see with

SELECT * FROM sys.Stats WHERE object_id LIKE OBJECT_ID('MyTable')

(only change 'MyTable' for something else), has name starting with _WA_Sy_....

As we know, automatically created statistics, as can be see with

SELECT * FROM sys.Stats WHERE object_id LIKE OBJECT_ID('MyTable')

(only change 'MyTable' for something else), has name starting with _WA_Sy_....

As we know, automatically created statistics, as can be see with

SELECT * FROM sys.Stats WHERE object_id LIKE OBJECT_ID('MyTable')

(only change 'MyTable' for something else), has name starting with _WA_Sy_....

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...

I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database. Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have be...