note 70720 added to function.mssql-query
| From: | simon at slicmedia dot com | Date: | Wed, 25 Oct 2006 07:37:52 +0000 |
| Subject: | note 70720 added to function.mssql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-119091@lists.php.net to get a copy of this message | ||
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?
----
Server IP: 217.160.250.20
Probable Submitter: 58.6.127.73
----
Manual Page -- http://www.php.net/manual/en/function.mssql-query.php
Edit -- https://master.php.net/note/edit/70720
Del: integrated -- https://master.php.net/note/delete/70720/integrated
Del: useless -- https://master.php.net/note/delete/70720/useless
Del: bad code -- https://master.php.net/note/delete/70720/bad+code
Del: spam -- https://master.php.net/note/delete/70720/spam
Del: non-english -- https://master.php.net/note/delete/70720/non-english
Del: in docs -- https://master.php.net/note/delete/70720/in+docs
Del: other reasons-- https://master.php.net/note/delete/70720
Reject -- https://master.php.net/note/reject/70720
Search -- https://master.php.net/manage/user-notes.php