--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/\
/*
---------------------
NULL
(1
row(s) affected)...
2010-07-29
5,809 reads
If you have a database application that is running slowly, or is straining the server, what do you do? After...
2009-10-25
3,114 reads
/*
A couple
of years ago, I wrote the Simple-Talk Prettifier. This is really no more than a stored
procedure that...
2009-08-14
3,539 reads
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,482 reads
I was reading a MCP training manual for SQL Server the other day. It was good. The whole of TSQL...
2009-06-22
1,739 reads
Going through one’s father’s belongings after his death is
always a poignant, bitter-sweet experience. I was going through his most
precious books...
2009-06-18
1,968 reads
One of the charming people who helped me register at Teched told me where we, who had registered, could get...
2009-05-10
1,696 reads
I spent a fascinating hour at the Teched Shop this afternoon. I was trying to get a feel for where...
2009-05-10
1,269 reads
Steve Jones isn't usually the wild man of publishing, but on April 1st, a strangely
anarchic spirit breaks loose. Having...
2009-04-03
1,484 reads
Most of the time, you want to have a SQL result in a particular order. Occasionally you just don't care....
2009-03-16
3,119 reads
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Comments posted to this topic are about the item Microsoft Power BI Performance Best...
I am learning DbaTools in Powershell, and my current project is exporting a CSV...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers