How do I add more records to a table?
On the Home tab, in the View group, click View, and then click Design View. On the Design tab, in the Query Type group, click Append. The Append dialog box appears. Next, you specify whether to append records to a table in the current database, or to a table in a different database.
How do you maintain a log table in SQL?
To get started, log into SQL Management Studio and connect to the SQL Server containing the desired database. The first step is to create the database table that will store the change log data. Execute the following script against the desired database.