I encountered a very strange problem when I was working on a project today. When I used PHP's sqlsrv to call the stored procedure of sql server, no error was reported, and no result set was returned.
My var_dump comes out as null
But when executing the statement in sql server 2008, there is data
So I searched for information on the Internet for a long time and found a person who does java. He said this
So I tried it and changed the sql statement to
I didn’t expect it to be possible
I thought it was solved when I could get the result set
As a result, I changed a machine, put the program in and ran it, but it didn’t work again. It didn’t work whether I added SET NOCOUNT ON in front or not. If I changed it to another select SQL statement, it would be fine. But the stored procedure wouldn’t work. I was at a loss. , see if anyone can give me some advice
