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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2011-07-06 : 04:48:14
|
| i am uploading files into a table.i have a column of datetime with a default value of GETDATE().the problem is, that even if i upload takes 30 seconds, the time in the column between the first and last line are the same.any way to overcome this? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-07-06 : 07:56:21
|
| How are you inserting? If the entire file is inserted at the same time the GETDATE()-function will only be run once. Are you sure that it is the inserting that takes 30 seconds and not the upload...?- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
|
|
|
upload files & default column value