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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-14 : 22:23:06
|
| Joy Bonham writes "I cannot get ADO to return the resultset of a dynamically created select statement which was executed using the sp_executesql or execute() commands inside a stored procedure.Details: I created a stored procedure which has 8 parms. The sproc dynamically builds a sql statement based upon values in the parms. The dynamical sql is then executed in the sproc using the sp_executesql statement.When I exec the sproc inside sqlserver, it returns the resultset. When I execute the sproc from an asp page using ado, it does not return a resultset. Any experience with this? Saw your artical on dynamic sql. While it had several examples, it did not show this one." |
|
|
|
|
|
sp_executesql with ADO