N Things Worth Knowing About CTEs
If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) - new in SQL Server 2005...
2010-08-26
1,284 reads
If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) - new in SQL Server 2005...
2010-08-26
1,284 reads
SELECT is this kind of Swiss Army Knife
SELECT is our bedrock, our foundation, our now-and-forever T-SQL multitasker…and it’s one of the...
2010-08-23
1,209 reads
Piggybacking tangentially off of Tim Mitchell’s (blog, Twitter) SSC editorial Turn a Bad Job into a Good Experience…yesterday I got...
2010-08-17
660 reads
One of the things about SSRS that irritates me is that in the graphical editor, you have to set the...
2010-08-13
1,678 reads
This has come up several times in the course of the last TWO jobs, so I’ll put it here for...
2010-08-12
750 reads
24HOP: Like Bacon for Chocolate
24 Hours of PASS is hip, it’s new…it’s serialized.
The September 15-16 24HOP is a sneak peek...
2010-08-11
676 reads
I’m absolutely positive that I’m not the first to blog on this topic, but I haven’t seen anyone else say...
2010-08-04
925 reads
…or, How I Learned to Stop Worrying and Love the Bomb
I had a SQL dev’s dream come to me via...
2010-07-28
903 reads
Hi! I’m SA! I’ll be your mentor during your stay at Innitrode! Actually, I’m everyone’s mentor here…anytime someone needs some...
2010-07-20
566 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers