Best way to retrieve SP? - SQL Server Forums

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

SQL Server Development (2000)

Best way to retrieve SP?

Author

Topic

Outze
Starting Member

2 Posts

Posted - 2002-03-03 : 18:15:53

Hi,

I was wondering if this is the most effective way of retrieving SP data. I usually have to retrieve data from three SP or more.

set cm = Server.CreateObject("ADODB.Connection")
cm.Open ConnString
dspoll = cm.Execute("spPoll "& pollId &"").GetRows
dspolloption = cm.Execute("spPolloption "& pollId &"").GetRows
dspollpId = cm.Execute("spPollId "& pollId &"").GetRows
cm.Close
set cm = nothing

Thank you for your guidance.
Outze

Edited by - Outze on 03/03/2002 18:17:07

Nazim
A custom title

1408 Posts

Posted - 2002-03-04 : 00:30:36

Check this link therez pretty good discussion on best practices of using Sp's too
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=10964

HTH

--------------------------------------------------------------

Outze
Starting Member

2 Posts

Posted - 2002-03-04 : 04:30:56

Thank you,

After reading that topic again I suppose its an good way to come about it.

Any further info is still appreciated
Outze

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources