How do I delete the results of a query

[cymerman]

Hi All,

I have run a query and exported the results from that query to a TXT file. 2503 Rows. Is there any way to write a statement that delets everything that is on this TXT file ? I know the other way which is using the delete blablabla from table where blablabla. But was just wondering if there is a way to delete just what is on this TXT file.

THANKS

 

[JarlH]

No, there isn't. DELETE is the way to go.

(Well, if you check a vendor specific forum they *may* be able to help you in some other way. ANSI SQL doesn't cover export and TXT files.)