Toad World® Forums

Append Query Not Working


#1

Hi-

I am running an append query to insert records from one table to another in a SQL Server DB via TDA. The statement seems to run ok, but viewing the table via DB Explorer does not show any records, and when querying the table the query runs forever and doesn’t return anything.

The funny part is, if I try to re-append the same data I get primary key violation errors…as if the data is actually in there somewhere.

???

Thanks for the help


#2

By default commit is OFF when connected to SQL Server. Did you submit a commit after your inserted rows? Or you can change your connections to Autocommit by using the toggle at the bottom left of the app.

Debbie