php - sql server：“set identity_insert on”无效

Question

I'm currently working on php application, with sql server database. I'm using the sqlsrv driver in php to make queries on my DB.

The problem is that I have to make an insert on a field which has Identity Specification. I tried to use instruction "SET IDENTITY_INSERT tableName ON", but it looks like it doesn't work with sqlsrv_query...

Does anyone know how to solve this problem?

Thanks in advance.

Answer 1

Did you call command in a batch by itself and then perform the insert?

See MSDN on SET IDENTITY_INSERT ON/OFF, it uses to GO to commit the batch before doing the insert.

Here is the reference manual for PHP SQLSVR.

When I was writing VB script or C# in the past, I would use query() to return a result set. The client side code uses a cursor to work with the data.strong text

However, this statement should be executed thru the execute() command.

Try the following.

1 - execute() - IDENTITY ON
2 - execute() - INSERT (S)
3 - execute() - IDENTITY OFF

See if that fixes your issue.