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
Can group by and orderby be used together?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Explain comment on transactions?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What are “lock” hints?
Write a SQL query to delete a table?
What are the types of processing and explain each? : sql server analysis services, ssas
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Where can you add custom error messages to sql server?
What are rest-style architecture's?
What is the sql case statement used for? Explain with an example?
How to delete duplicate rows in sql server?
What stored by the model? : sql server database administration
How to connect of datebase with sql express.?
How to return the top 5 rows from a select query in ms sql server?
