Common Table Expressions
They are new to SQL Server in 2005, but they are not necessarily in common use for many people. New author Kirk Kuykendall brings us a basic look on what a CTE is and how you can use it.
2008-03-18
13,868 reads
Kirk Kuykendall
Blogs
Why oh Why? Effects of Antivirus on a DB Server
At best these phantom backups cause undue headache in troubleshooting. At worst, they make...
Your First Jupyter Notebook
In April, I said I was going to start learning Jupyter Notebooks. It’s November....
Using Visual Studio Code
I’m a creature of habit. I have my routine when I get to my...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
power shell script for add datetime to file
Hi, i would like to generate csv file with datetime through sql job with...
NOT Operator and NULLs
--test data declare @T table(a int null, b int null) insert @T(a, b) select...
Ask SSC