SELECT INTO / INSERT INTO

• JuanBob

  SSCertifiable

  Points: 5059

  More actions

  June 13, 2006 at 10:19 am

  #171376

  SQL 2000 on Win2003 Server

  I am inserting rows into Table1Archive from Table1 based on a Trigger.  Since the two tables are a mirror of each other, do I need to specify each field? 

  I know this will not work but it would be great to replicate this idea:

  INSERT INTO Table1Archive

  SELECT * FROM Table1

   

  Any help would be greatly appreciated!

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  June 13, 2006 at 11:05 am

  #643454

  Table auditing using triggers? Take a look at these...

  http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html

  http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.