Can i assign the time in my table?

• sandy2003

  Newbie

  Points: 1

  More actions

  December 23, 2003 at 2:31 am

  #64712

  hi thr ,,

  is it possible to assign the time of each entry in the table with the same entry?? actually i wanna use it as a timestamp method..

  if its possible then plz tell me how to assign..i.e. what should be the data type for this column n what whould be the command?? i have already created the table but not have to add a new column of timestamp..

  plz help me

  thanx a lot for ur responces

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  December 23, 2003 at 3:26 am

  #487560

  Please see my latest article Dealing With Changing Data for examples on how to do this. Use the link for articles in my signature.

  --

  Chris Hedgate @ Extralives (http://www.extralives.com/)

  Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)

  Articles: http://www.sqlservercentral.com/columnists/chedgate/

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/