| Author |
Topic |
|
dhanu.tpk
Starting Member
14 Posts |
 Posted - 2010-02-02 : 03:42:56
|
| hi All,I want to read a text line by line in procedure. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-02-02 : 03:46:15
|
| Please be more specific...- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
 |
|
|
dhanu.tpk
Starting Member
14 Posts |
Posted - 2010-02-02 : 03:48:01
|
| i am 1000 lines of procedure so i want to read the each row one by one and get the specific data... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-02 : 04:02:17
|
quote:
Originally posted by dhanu.tpk
i am 1000 lines of procedure so i want to read the each row one by one and get the specific data...
Why do you want to do this?MadhivananFailing to plan is Planning to fail |
|
|
|
dhanu.tpk
Starting Member
14 Posts |
Posted - 2010-02-02 : 04:05:54
|
| in that procedure i want to find out tables whcich are related to insert,update,select query... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-02 : 04:09:59
|
quote:
Originally posted by dhanu.tpk
in that procedure i want to find out tables whcich are related to insert,update,select query...
What happens when you try this?EXEC sp_depends 'procedure name'MadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-02 : 04:14:38
|
quote:
Originally posted by dhanu.tpk
in that procedure i want to find out tables whcich are related to insert,update,select query...
didnt we suggested you a solution yesterday? did you try that yet?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139153 |
|
|
|
dhanu.tpk
Starting Member
14 Posts |
Posted - 2010-02-02 : 04:16:26
|
| it gives list of tables i agree which are dependent but i want to categorise it for insert,update,select statements... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-02 : 04:19:55
|
quote:
Originally posted by dhanu.tpk
it gives list of tables i agree which are dependent but i want to categorise it for insert,update,select statements...
categorize? you mean count of tables used in each case? |
|
|
|
dhanu.tpk
Starting Member
14 Posts |
Posted - 2010-02-02 : 04:24:11
|
| exactly!! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-02 : 04:27:44
|
quote:
Originally posted by dhanu.tpk
it gives list of tables i agree which are dependent but i want to categorise it for insert,update,select statements...
What is the actual purpose of this?MadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-02 : 05:09:38
|
quote:
Originally posted by madhivanan
quote:
Originally posted by dhanu.tpk
it gives list of tables i agree which are dependent but i want to categorise it for insert,update,select statements...
What is the actual purpose of this?MadhivananFailing to plan is Planning to fail
i think he needs some kind of report which says x number of tables used in sp for insert, y tables for update, z for select etc with details |
|
|
|
|
read text line by line