|
|
|
|
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 I'm sure by this point, you have seen enough to realize the benefit DBArtisan can have in your environment. But, there are a few more features still remaining. DBArtisan has a full featured isql capability. For those familiar with RapidSQL, this part of DBArtisan will be very familiar. Much of the basic functionality provided in RapidSQL has been embedded within DBArtisan. You can comment and uncomment whole blocks of code with a single click. You can apply bookmarks to your code allowing quick navigation through large volumes of TSQL or PL/SQL. The only limits on the size of the batch you can open in DBArtisan is with resources. I have opened files in excess of 200MB for editing. (I was parsing trace files.) It has showplan capabilities and provides a very easy error resolution. How many times have you seen the message error near line 12537. The last thing I'm going to do is count lines. In DBArtisan, you simply double click on the error message and it navigates you directly to the line where the error occurred.If you are not sure about the syntax of a command, there is help available for that as well. Simply click on the Paste SQL Syntax button and you will see the dialog below. This is filtered based upon the DBMS and version that you are connected to. Selecting a command and clicking the Paste button will paste the syntax into the ISQL window at the cursor.
Want to build a SQL statement the lazy way? Click the Paste SQL button and you will see the dialog below. This allows you to point and click build a SQL statement. If all you want is a list of tables, select the tables you want and click the Paste Tables button. The same applies to the Paste Columns button. You can also build a select/insert/update/delete statement and paste that in as well.
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
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.
