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 |
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
 Posted - 2008-03-27 : 12:06:29
|
| I'm using PHP, and I understand it has MSSQL extensions for various tasks. Is there a way to turn off Free_Result just for one query? Does there exist a flag in mssql that can temporarily suspend destroying of the result? Normally, after a database pointer exhausts the result query, it'll get destroyed because there's it's finished processing all rows. I'd like to suspend this action for one query. Is there a way to accomplish this, either using php sql extensions or within the sql query itself?thank you. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-27 : 13:55:11
|
| well i have no idea how php handles database stuff, but doesn't it have something comparable to a dataset or recordset that you can put your data in?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
Posted - 2008-03-27 : 14:18:51
|
| it does not have to be in php. figured since there are numerous flags in SQL Server, perhaps there's one that prevents the query result from being destroyed after the database pointer has exhausted it. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-27 : 14:22:17
|
| emm... not that i know of... because sql server sends data to it's output stream... if it would keep data there then other queries would have to wait._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
Posted - 2008-03-27 : 15:01:32
|
| Well, you would know. Since you don't, I assume there isn't a functionality built-in for SQL Server. It's probably customary to handle such things in php. |
|
|
|
|
|
|
how to turn off "Free_Result" in SQL?