June 28, 2010 at 12:55 am
Hi All,
I want to create a flow chart for an existing procedure which will explain all the queries inside the procedure and also i need how we can explain the joins in the queries.
Can some one tell the different flow chart symbols related to database concepts like union, left join, inner join, etc.,
Faster reply is appreciated.
Thanks,
Varadhaerajan
June 28, 2010 at 6:43 am
you mean to say execution plan .. i dont think there is any word like "flow chart " for queries
you can use "include actual exec plan" available in mgmt studio
moreover you can use
set showplan_all on
select top 2 * from activity_email
set showplan_all off but here you wil get detailed info , a bit difficult to understand.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 29, 2010 at 12:05 am
Hi,
My customer wants me to put flow chart for the procedure. which has union, joins and conditions of around 1400 lines.
June 29, 2010 at 12:18 am
i dont know your exact requirement but you can give them conditional flow of businees flow, if you know that . i guess high level view will work for them.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 29, 2010 at 3:24 am
Well in this case, there is nothing which SQL Server can automatically generate for your customers and which they can understand as a layman.
Looks like they want some graphical representation of queries/business logic inside the proc. I might use simple boxes with different color schemas here.....
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply