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.
| Author |
Topic |
|
sharmasumit45
Starting Member
9 Posts |
 Posted - 2008-01-17 : 08:07:54
|
| Can you help me in one more thing When ever I see a complex Stored procedure I feel scared.But I can see people using print command use to debug it and also some are using sql profiler to trace the database updates/changes.I am scared how can they do this so effortlessely.Actally I don't know these two technique can you please help me with example script.Regardssumit |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-01-17 : 22:04:29
|
Step 1 : Relax Step 2 : Take a deep breath, breath in, breath out 3 timesStep 3 : Google for help on debugging stored procedure and go through some of the techniqueStep 4 : Take a deep breath and look at your complex stored procedure again.Remember, a complex stored procedure is nothing but a stored procedure. Don't be afraid. It will not bite.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sharmasumit45
Starting Member
9 Posts |
Posted - 2008-01-17 : 23:28:20
|
| Thanks for early morning relaxation exercise.Hope your exrecise and advise help me to boost my confidence.Let me try this link and will inform you if I get stuck with specific problem.regardssumit |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-01-17 : 23:48:39
|
quote:
Originally posted by khtan
Remember, a complex stored procedure is nothing but a stored procedure. Don't be afraid. It will not bite.
are you sure? I think some of those 40,000 line SAP procs have a septic bite.
elsasoft.org |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-01-18 : 00:16:01
|
quote:
Originally posted by jezemine
quote:
Originally posted by khtan
Remember, a complex stored procedure is nothing but a stored procedure. Don't be afraid. It will not bite.
are you sure? I think some of those 40,000 line SAP procs have a septic bite.
elsasoft.org
40K lines SP ? Looks like it is a table design issue.  With table name like A001, A002, KNVP etc no wonder the SP is 40K lines.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Need help for complex Stored procedures