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
How to create a new table in a given schema?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
what are cursors? : Sql server database administration
When I delete any data from a table, does the sql server reduce the size of that table?
How can we rewrite sub-queries into simple select statements or with joins?
What is tabulation?
what is the difference between a primary key and a unique key? : Sql server database administration
What is the purpose of floor function?
Is sql server difficult to learn?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Which is the main third-party tool used in sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Explain about service Broker functions?
How to convert binary strings into integers in ms sql server?
How many types of built in functions are there in sql server 2012?