Tag Archives: dynamic sql
-
How do I use a variable in an IN clause?
16April 8, 2013 by Kenneth Fisher
I see this question in one form or another a lot. I’ve seen this or something like it probably half …
Continue reading -
DROP and CREATE vs ALTER
25February 25, 2013 by Kenneth Fisher
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic …
Continue reading -
Generating multiple SQL statements from a query
2December 17, 2012 by Kenneth Fisher
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can …
Continue reading
SQL Studies 