- MSSQL only support FETCH_MODE_ASSOC
- $rs->EOF cause unlimited loop
- Only the first select statement in the procedure are returned as query object
- the rest of query are return as true array
- You can only fetchRow once
- text, ntext, image fields can not be local variables
- index on datetime will not be used if date range is in the query select statement
The following features are not working in the linked server env.
- @@IDENTITY insert won't return at all
- SET ROWCOUNT 500 for insert/update/select
- Need to use SET XACT_ABORT ON to be able to write to the linked server
No comments:
Post a Comment
Thank you for your feedback. If you find the tip and trick useful, feel free to share with your friends on Facebook, Twitter and G+!