Solved How to convert an access delete query to Passthrough query (1 Viewer)

nector

Member
Joined
Jan 21, 2020
Messages
416
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?

Code:
DELETE tblItemClassList.itemlistID, tblItemClassList.itemClsCd, tblItemClassList.itemClsNm
FROM tblItemClassList
WHERE (((tblItemClassList.itemClsNm) Is Not Null));
 
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
 
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).
 
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:

Code:
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
 

Users who are viewing this thread

Top Bottom