Answer Posted / brahma
Yes,
Begin transaction t1
update <Table_Name> set <col1>=<col1>+50
Begin Transaction t2
delete from <Table_Name> set <col1>=<col1>+100
commit Transaction t2
end transaction t1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a primary key and a unique key.
What is the default port for SQL Server over a firewall?
Can I use sql azure as a backup with log shipping or database mirroring?
What is the difference between delete and truncate statements?
What is subquery explain with example?
What is a trace frag? Where do we use it?
What is user-defined multi-statement table-valued function?
What are the basic functions for master, msdb, model, tempdb databases?
Explain use of expression builder.
What is the difference between inner join and equi join?
When is the use of update_statistics command?
Explain the difference between clustered and non-clustered index?
What are different types of raid configurations? : SQL Server Architecture
How to compare the top two records using sql?
What is scheduled job and how to create it?
