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 |
|
panthagani
Yak Posting Veteran
58 Posts |
 Posted - 2007-08-23 : 17:54:34
|
| I'm trying to call a stored proc with parameters without using EXEC statement and with only using a SELECT statement. I have the stored proc and need to call it from a 3rd party application which provides an interface to SQL server and does not support EXEC statements, but only SELECT statements. Is there a way this can be done?Any enlightenment is appreciated. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-23 : 18:29:06
|
| No I dont think so.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-23 : 20:28:41
|
I think you can with OPENDATASOURCE function.Spirit or Harsh showed my how, some weeks ago.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-23 : 20:56:52
|
quote:
Originally posted by Peso
I think you can with OPENDATASOURCE function.Spirit or Harsh showed my how, some weeks ago.
E 12°55'05.25"N 56°04'39.16"
you can do a SELECT on a proc ?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-24 : 04:42:24
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85347MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Run stored proc with SELECT