SQL Server's insert into queries can be difficult to read, because you first provide the column names, and then the values: insert into table(field1,field2) values(value1,value2). There is no easy way to view it as a table. When you've forgotten a field name or a comma, you will have a serious problem... Unless you download these two tools.

See the two screenshots below to see what I mean.

Insert Into Analyer screenshot

Analyze Insert Into Select screenshot

Features

• Shows INSERT INTO and INSERT INTO...SELECT in tabular form
• Tested with SQL Server 7.0/2000 format (T-SQL)
• Checks whether the number of fields correspondents with the number of values
• Allows columns of the INSERT INTO analyzer to be changed on the fly, by double-clicking on the row

Drawbacks

The program currently has the following drawbacks:

• There is no easy installation package
• There is no technical or user documentation

Dependancies

To run the tools, you need the VB6 runtime (SP6), which is available on the Microsoft website. Or you can install PFM, which is available here.

Download

Last modified on: 2005-12-09