Tuesday, 20 August 2013

mssql unable to execute multiple ID's in one short

mssql unable to execute multiple ID's in one short

Delete from tblStats where indexID in (1,2,3,...........250900)
mssql_query function unable to delete all these ID's as well no error
thrown also affected rows says -1. this same query successfully deleted in
sql server 2008 tool.
is there any limitation exist in the mssql_query for DELETE Query.

No comments:

Post a Comment