Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manojkumarfbd
Starting Member
4 Posts |
 Posted - 2009-05-11 : 05:27:47
|
| HiI want to update the current date on each updation in a column.is there any way to update this column without using trriger?thanksManoj kumar |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-05-11 : 06:15:14
|
| Try thisupdate table1 set c1='a',c2='b',... c10=getdate() where id=1Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-11 : 11:08:41
|
quote:
Originally posted by manojkumarfbd
HiI want to update the current date on each updation in a column.is there any way to update this column without using trriger?thanksManoj kumar
nope. for updates to pick up date automatically you need to use trigger. |
|
|
|
manojkumarfbd
Starting Member
4 Posts |
Posted - 2009-05-12 : 00:43:02
|
| I wanted to update the value automaticallyThanks for your prompt reply.Manoj Kumar |
|
|
|
|
|
|
Default Value