• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

any help in this case will be appreciated

i am trying to delete everything that is there in the temp table and there are around 4724012 rows of data each time i run the page.
i know this much data will be coming each time but my major concern will arise as the no of rows will keep on increasing on daily basis but when i try and delete it in an SQL-Window query it executes perfectly but when i try the same with php code it shows an error message that query failed.

Any help in this case will be appreciated
$qdel = "delete from dbo.temp DBCC CHECKIDENT('dbo.temp', reseed, 0)";
$rdel = mssql_query($qdel);

Open in new window

src.txt
0
jhawarmayank
Asked:
jhawarmayank
1 Solution
 
bmatumburaCommented:
Try this:
$qdel = "delete from dbo.temp; DBCC CHECKIDENT('dbo.temp', reseed, 0)";
$rdel = mssql_query($qdel);

Open in new window

0
 
jmoss111Commented:
Why don't you TRUNCATE the table?
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now