I am having trouble executing a long
MSSQL script using
It contains some batch statements separated by
GO. The script runs if its executed in
I have ensured line endings are not causing the issue.
I have also tried to enable
beginTransaction() before the request is executed. Which returns the following error:
SQLSTATE[IMSSP]: This function is not implemented by this driver.
PHP 5.4.16 and the
First part of the script:
USE foo; IF object_id(N'ToBit', N'FN') IS NOT NULL DROP Function dbo.ToBit GO CREATE FUNCTION dbo.ToBit( @InputString varchar(250) ) RETURNS BIT AS BEGIN DECLARE @OutputBit BIT SET @OutputBit = CASE WHEN (@InputString = 'yes') THEN 1 WHEN (@InputString = 'true') THEN 1 WHEN (@InputString = '1') THEN 1 ELSE 0 END RETURN @OutputBit END
Is it down to the driver? I can't see why
GO would require
beginTransaction() being called? Other than that I'm out of ideas.
Update: I think I might have found an answer here. Will update if I find a soloutio. Incorrect syntax near 'GO'