SQL Server Nation
For all of your SQL Server needs.

December 2009 - Development

  • Getting started with dynamic SQL

    Sometimes you need dynamic SQL. Sometimes you don't know at run time where you're querying or what fields you need to bring back, or what your criteria will be, so there will always be a place for the use of dynamic SQL. You have to be careful how you use it, but if you do use it correctly it can be a powerful tool that you have in your tool belt. So, today I am going to show you a nice little general purpose procedure that you can write to pass in a few object strings and execute dynamic...
Copyright SQL Server Nation 2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems