Inserting automatic timestamps into the database
After some search I've found the way to do it:
- Open the table in Server Explorer and select the column in which you want to store the automatic timestamp.
- Under Column Properties, modify "Default Value or Binding" to hold: (getdate()).
- Save, and you're done!
Now everytime you insert a record into the database, the timestamp will be generated for you.