MSSQL-PHP-ADODB Issues

• 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

@ECHO OFF
set counter=1
set second=10
set minute=%second% / 60
set /A stopper=1000*%second%
echo Delay … %second% second(s)

:loop
set /A counter=%counter%+1

if %counter% EQU %stopper% GOTO OK
GOTO loop

:OK
REM Put the command below
MOVE file1.txt file2.txt

Write output into a file
Login into mysql

mysql> \T D:\temp\innodb_status.txt
Logging to file ‘D:\temp\innodb_status.txt’
mysql> show innodb status
mysql> \t
Outfile diabled