speed dating score card - We are updating a field in sql and alter

and I'm getting back the number of rows updated so I know the transactions are happening on the server.. Now, yesterday afternoon, two transactions (same query/batch) were lost entirely (NO record written at all) on four out of the five tables..

This is a very simple question, but the SQL Server documentation doesn't explain this as clearly as I would like, so I would appreciate someone spelling it out for me.

I am updating a table with new values based on a spreadsheet - which means I'm using multiple Now, during my research on this I managed to find some documentation on how SQL Server handles this - which is that it uses the UPDATED value. You could also get constraint errors because of how updates are applied (especially on uniqueness) The way to do many updates in one go to avoid intermediate errors is to do a single update Thanks - that's definitely my problem alright.

The other thing that I've noticed is that it's usually one field with the same information that's missing. So, to give an example, I have a temp table with say, 15 columns..

this is the calculated data the user is writing to the DB..

I need to automatically change this to reflect the time in the timezone the db server is in. The dates going into this column are retrieved in batches every so often (5, 10, 15 minutes), so I think the only way to go is to alter the time once it has been received, not to add a Time Modified field or something. Another option here would be to use a calendar table where you map a UTC date and time to the local date and time value.

For example, if they send me PM, but I am in NYC, I would want it to be entered in the db as AM. Disadvantages here are a loss in some of the granularity.

then the second, but one field isn't written and remains NULL. Fourth table, missing the same field info, then the fifth may be missing it too. There is no consistency in which tables may not have that field written to, or when this may occur.

But, the next time the user sends an update to the DB.. Now, I've (in the interim) ran update queries to replace the lost info in the tables.. Nothing has stood out so far in the logs on the SQL server..

ALTER and UPDATE are the two modifying commands of SQL.

ALTER is used to modify the structure of the relations (Tables) in the database.

This would also have to account for differences in Daylight Savings between GMT and wherever the server is, which seems like a nightmare. If seconds are important I would not implement this; you can look at the size of the calendar record and compare it to the size of storing a datetime for every record in your transactional table.

268 Comments

  1. Connections Chat is a free personals chat line for singles and a discreet way to instantly connect with exciting single men and women in your area 24 hours a day 365 days a year. You will always find exciting singles from all around the U. looking to connect with you for chat, dating, or just fun entertainment.

  2. Also, you can not post individually to more than 100 students at a time.

  3. Looking for great hookups on a site that's better than Craigslist?

  4. If you accept cookies from our site and you choose "Proceed", you will not be asked again during this session (that is, until you close your browser).

  5. Insh is a site of dating and exchange which tends to facilitate to Muslims the discovery of the soul mate wishing to see, if God will, marriage becoming a reality in the respect of human and moral values which are the ones of Islam.

  6. “When a woman is interested in a man, she makes time for him,” says Brooke Carsner, owner of Intuitive Matchmaking.

  7. If you are a and into butches please be so kind to send Me a message. You said you didn't want to have to treat him like he is a genius when he is just a guy.

Comments are closed.