Category Archives: T-SQL
-
How can I use the identity column, without knowing identity column’s name.
Leave a commentMay 12, 2022 by Kenneth Fisher
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The …
Continue reading -
My job managing a calling list. : T-SQL Tuesday #150
Leave a commentMay 10, 2022 by Kenneth Fisher
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I …
Continue reading -
SQL Homework – May 2022 – Books on Line
Leave a commentMay 5, 2022 by Kenneth Fisher
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of …
Continue reading -
Scripting with a temp stored procedure
2March 17, 2022 by Kenneth Fisher
A few years back I learned about temporary stored procedures from a Kendra Little (blog|twitter) blog post. At the time …
Continue reading -
Shift calculations (or same time every day)
2March 15, 2022 by Kenneth Fisher
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. …
Continue reading -
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Leave a commentMarch 8, 2022 by Kenneth Fisher
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a …
Continue reading -
SQL Homework – March 2022 – Formatting
Leave a commentMarch 1, 2022 by Kenneth Fisher
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries …
Continue reading -
You can’t use GO in dynamic SQL.
1February 10, 2022 by Kenneth Fisher
This is one of those things that when I look back on it seems really obvious. Note: If at the …
Continue reading -
Who do you contact before an upgrade? : T-SQL Tuesday #147
1February 9, 2022 by Kenneth Fisher
I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent …
Continue reading -
Commenting a branching IF-THEN-ELSE.
1October 19, 2021 by Kenneth Fisher
I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE …
Continue reading