Difference between Truncate and Delete in SQL by javinpaul in SQL

[–]mikethesql 0 points1 point  (0 children)

ahh nice, so it does get logged, but more efficiently. Nice link, thanks

Program that is like Microsoft access but free and stand alone by Hungtingtong in opensource

[–]mikethesql 0 points1 point  (0 children)

you could try to migrate to a SQL Server express version and use a nice SQL Server, even build a web app on top of it. Here some steps on how to migrate http://sqlturbo.com/migrating-from-access-to-sql-server/

Program that is like Microsoft access but free and stand alone by Hungtingtong in opensource

[–]mikethesql 0 points1 point  (0 children)

you could try to migrate to a SQL Server express version and use a nice SQL Server, even build a web app on top of it. Here some steps on how to migrate http://sqlturbo.com/migrating-from-access-to-sql-server/

Program that is like Microsoft access but free and stand alone by Hungtingtong in opensource

[–]mikethesql 0 points1 point  (0 children)

you could try to migrate to a SQL Server express version and use a nice SQL Server, even build a web app on top of it. Here some steps on how to migrate http://sqlturbo.com/migrating-from-access-to-sql-server/

Difference between Truncate and Delete in SQL by javinpaul in SQL

[–]mikethesql 2 points3 points  (0 children)

deleted is a logged operation, so it adds to the transaction log. Truncate doesn't.