meta user
network profile
|
Feb 28 |
comment |
difference between UPDLOCK and FOR UPDATE Maybe you missed the ... in the code. also there is code before and after the moment this code is called. The flow of the program (which I won't discuss) makes it mandatory that certain records need to be locked with 100% certainty that the row cannot be updated by another statement. |
|
Feb 27 |
revised |
difference between UPDLOCK and FOR UPDATE added 59 characters in body |
|
Feb 27 |
awarded | Editor |
|
Feb 27 |
comment |
difference between UPDLOCK and FOR UPDATE I updated the question, perhaps with this you can help me out? |
|
Feb 27 |
revised |
difference between UPDLOCK and FOR UPDATE added 603 characters in body |
|
Feb 27 |
comment |
difference between UPDLOCK and FOR UPDATE the above code is exactly what we use. the dots are just other code and lookups. Your answer looks like you didn't read the code provided since i did include a column list and a transaction and am not using a cursor. Or am I missing your point here? |
|
Feb 27 |
comment |
difference between UPDLOCK and FOR UPDATE Thanks. You say: 'in general'. I need to know if there is ANY specific difference between the 2 statements. We are using MSSQL only |
|
Feb 27 |
asked | difference between UPDLOCK and FOR UPDATE |
|
Feb 1 |
comment |
Get counts grouped by month and year True, Didn't know a better way to do it tough |
|
Feb 1 |
answered | Get counts grouped by month and year |
|
Jan 31 |
awarded | Informed |
|
Apr 30 |
awarded | Analytical |
|
Apr 27 |
awarded | Supporter |
|
Apr 27 |
awarded | Scholar |
|
Apr 27 |
accepted | Backup database and clean old backup question |
|
Apr 27 |
comment |
Backup database and clean old backup question Exactly what I was looking for. Thanks a lot! |
|
Apr 27 |
comment |
Backup database and clean old backup question It is one of the requirements that I don't have to do extra work after the script/job has been implemented on the server. The way you describe forces me to add an extra step when somebody adds a database. Something we absolutely want to avoid. |
|
Apr 27 |
awarded | Student |
|
Apr 27 |
comment |
Backup database and clean old backup question Thanks for the pointers. It is not an option to have NO backup. I already know about the sp_msforeachdb. But can I use it for cleaning old backup files? I hardly doubt it. |
|
Apr 27 |
comment |
Backup database and clean old backup question the usual cases: not enough space and databases being offline. |
