Tag Archives: sql statements
-
Using OUTPUT to back up a change
2June 26, 2013 by Kenneth Fisher
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back …
Continue reading -
Metadata Functions (OBJECT_NAME for example)
Leave a commentJune 24, 2013 by Kenneth Fisher
What is a metadata function? According to BOL a metadata function is one that returns data about the database or …
Continue reading -
ORDER BY the numbers
17June 17, 2013 by Kenneth Fisher
Have you ever needed to order by a calculated column? You might have written it something like this: Did you …
Continue reading -
Best practice recommendations for writing Dynamic SQL
16June 12, 2013 by Kenneth Fisher
Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
Continue reading -
Using the OVER clause
2June 10, 2013 by Kenneth Fisher
Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has …
Continue reading -
Pattern searches beyond ‘%string%’.
4June 3, 2013 by Kenneth Fisher
I was asked today to take a table with a social security column and put all 0s if the column …
Continue reading -
Backup a password, change it, then restore it.
3May 30, 2013 by Kenneth Fisher
A couple of months ago I talked about moving a login from one server to another without the password. The …
Continue reading -
Using CROSS APPLY to calculate an aggregate across a single row.
2May 28, 2013 by Kenneth Fisher
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last …
Continue reading -
Using CROSS APPLY instead of a calculated variable
3May 22, 2013 by Kenneth Fisher
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working …
Continue reading -
The many uses of CROSS APPLY
4May 20, 2013 by Kenneth Fisher
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the …
Continue reading
SQL Studies 