note 70720 rejected from function.mssql-query by betz
| From: | betz@php.net | Date: | Wed, 25 Oct 2006 09:11:55 +0000 |
| Subject: | note 70720 rejected from function.mssql-query by betz | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-119095@lists.php.net to get a copy of this message | ||
Note Submitter: simon at slicmedia dot com
----
It seems inserting records to a temporary table using sp_executesql within a stored procedure is not
supported.
I run insert...exec sp_executesql... within a sproc, and get 0 results, no errors. I also noticed
some other odd behaviour running subsequent queries on the same connection.
Same sproc runs fine using ADO, QA, etc.
Ideas anyone? Maybe there is some kind of 'master list' of non-PHP-mssql compatible T-SQL?