Solved How to convert an access delete query to Passthrough query

[nector]

I have tried to convert this query below into a passthrough delete query but I keep on getting an error message from the SQL Server why?

DELETE tblItemClassList.itemlistID, tblItemClassList.itemClsCd, tblItemClassList.itemClsNm
FROM tblItemClassList
WHERE (((tblItemClassList.itemClsNm) Is Not Null));

 

[tvanstiphout]

And what is the error message?
And what is the error message if you run this in SSMS?

 

[GPGeorge]

What error would that be, exactly? Sometimes we can help you diagnose problems from the details provided in an error message, but only when the error message itself is included.

I will say, though, that the DELETE syntax in SQL Server is different, as described here. TSQL delete

 

[tvanstiphout]

What error would that be, exactly? Sometimes we can help you diagnose problems from the details provided in an error message, but only when the error message itself is included.

I will say, though, that the DELETE syntax in SQL Server is different, as described here. TSQL delete

DELETE
FROM dbo.tblItemClassList
WHERE dbo.tblItemClassList.itemClsNm Is Not Null;

(or whatever namespace tblItemClassList is in).

 

[cheekybuddha]

@nector, I'm curious as to whether you notice any actual benefit to using a pass-through with this simple query.

 

[nector]

Well after trying many way , I have come realise that since I need to the entire data in the temporal table , the systex should be like below:

DELETE FROM tblItemClassList

This can delete the data in SQL server even if it has 350000 lines in less than 5 seconds and that is what I wanted from the passthrough query, its a great tool