Documenting Queries

  • Our systems and technical specs usually set out the construction of a T-SQL command in text (eg, something like 'Join Table1 to Table2 on field ItemID and select records that have been updated in the last 24 hours'). More complex algorithms may be set out in a tabular format but, however it's done, it rapidly becomes very difficult to interpret. Can anyone recommend graphical methods for representing T-SQL algorithms that can be understood easily by relatively non-technical people as well as developers and DBAs?

  • With something like ER-Win or Visio you could create a simple model of the queries.

     

    DAB

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply