Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is dirty read?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Explain what are page splits? : SQL Server Architecture
Is there any difference between primary key and unique with the not null condition?
Why do we use non clustered index?
Tell me in brief how sql server enhances scalability of the database system?
What are the different types of normalization?
What is equi join with example?
What are filegroups in sql server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Explain what is row_number function?
What is the use of @@spid?
What is page-level compression?
