create flowchart from a stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

create flowchart from a stored procedure

Author

Topic

mcp111
Starting Member

44 Posts

Posted - 2003-04-02 : 11:51:42

Does anybody know of any tool which would create a flowchart of code logic by examining a stored procedure which could be given to less technical personnel so that they can understand the general flow of the program better?

MichaelP
Jedi Yak

2489 Posts

Posted - 2003-04-02 : 13:59:01

If you find one, pls post a link to it in here. I've never heard of such a thing.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

nr
SQLTeam MVY

12543 Posts

Posted - 2003-04-02 : 14:52:45

I would like to see anything that could make sense of the sort of thing I write when I'm bored - I certainly can't.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

mvandeberg
Starting Member

2 Posts

Posted - 2004-12-08 : 11:44:03

I am also looking for a tool that will automatically create a flowchart or something to that affect by simply plugging in a stored procedure.. My boss said he'd pay good money for something like this. Anyone heard of such a thing yet?

Thanks,
Mike

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-12-08 : 12:01:32

nope... but if you pay me $100k i'll write you one. give me 1 month. updates and error handling will be charged separatly...

Go with the flow & have fun! Else fight the flow

mvandeberg
Starting Member

2 Posts

Posted - 2004-12-08 : 12:06:47

OK, how about 80K and free support, and its a deal!!! :-)
Gotta have it by the end of the day though, and it has to be written in FORTRAN and ya gotta give me the source code so I can make my own mods...

Thanks! Im waiting.............

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-12-08 : 12:09:10

well since it's 6 pm here there's no way

Fortran.... hmmm what is that again??

C# wouldn't do??

maybe Visio could help you. of course you'd have to write the UML manualy...

Go with the flow & have fun! Else fight the flow

X002548
Not Just a Number

15586 Posts

Posted - 2004-12-08 : 16:29:50

Well that's a neat idea...it'd have to be language specific.

I think I would try and build a parent child relationship table of the steps.

Then I would gener Table DDL with the step name as the table.

Then I would would gener FK contraints

And then through it all in to ERWIN to draw the picture...

Brett

8-)

gongxia649
So Suave

344 Posts

Posted - 2006-04-17 : 15:43:24

visustin

sql to flowchart

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-04-17 : 16:21:09

not bad...

Go with the flow & have fun! Else fight the flow

Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"]

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-18 : 01:36:35

so zeez was za tool you ver mentioning about "wit" ze other thread

cool...

--------------------
keeping it simple...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-18 : 01:38:58

Madhivanan

Failing to plan is Planning to fail

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2006-04-18 : 07:23:34

quote:
Originally posted by mvandeberg

Gotta have it by the end of the day though, and it has to be written in FORTRAN and ya gotta give me the source code so I can make my own mods...

Best
Troll
Ever

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources