|
|
|
|
|
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 Batch objects can be very powerful tools if you leverage the capabilities. How many times have you had a nice little piece of code that does a specific thing, but you have several batches that can utilize that code? You have to copy and paste that code into each of those batches, wire it together, and execute it. Take a close look at the figure below. No, this statement won't execute outside of SQL-Programmer. What you can do is to create your batches with a modular approach. Several people have asked for a script that would reverse engineer a create index statement and I have that nasty little piece of code embedded in one of my stored procedures. What if I would have created just that piece as a batch object? Then wherever someone needed that functionality, they could simply call that batch object.
Ever needed to search for a string within your server? Maybe you are trying to find every place where you might have used a particular table. (sp_depends doesn't always show all of the dependencies that do exist.) This can be accomplished via the Search feature. It isn't very intuitive in finding this. You access the Search dialog through Edit | Find. It is limited in search capability to a single server and a single database at a time.
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
