Can Any One Help Me In Sqlserver.......a Question In The Query

[@Shadow@]

the following query is in a stored procedure which called by UI to get a Value from It

UPDATE Table
SET Coloumn = Coloumn + @InputVariable
output deleted[b].[/b]Coloumn
where xxx==xxxx


na doubt entante..........how to capture this [b]deleted.Column[/b] value in a Variable( this will provides me the needed value before it gets updated), so that I can return through that variable
I have tried selecting it, assigning it and in various ways kani solve avvaledhu


ela endhu ku chesannate.................
previously I had 1 select query and 1 update query in a single SP
in which select query will assign a value from the column to a variable and thath variable is used in update
but b.coz of that my team assuming could raise concurrency issues.....................
so motham oke query lo radhamanukunna kani ............ mind ikkadiki block iyyendi bhaiyya.....

edhe oracle lo iyte locking cheyochu ledha select from update anta inkedo vadochata kani eee SQLServer lo em cheyagalamo, telisthe chepandi boss

[PMREDDY19]

[NaniMAN]

[img]http://i.imgur.com/kjV81.gif[/img]

[NaniMAN]

help

[demo]

ltt

[tom bhayya]

[Chocolateboy]

help seyyandi vay

[spicyfish]

@shadow, I dont know what ru trying to do at output deleted.column, but as far as I know you can do one thing by your same logic as earlier you did with 2 statements, with out any concurrency issues,

Use BEGIN TRAN
write your select statement , udpate statement
COMMIT TRAN.

This will help you do kind of locking table and wont have any concurrency issues,I am lill confused with you explanation abt output deleted.colum above if you can explain lill more may b I can help.
Just shared my thought. take it if its helpful.

[Jeffa]

[quote name='spicyfish' timestamp='1325205460' post='1301212268']
@shadow, I dont know what ru trying to do at output deleted.column, but as far as I know you can do one thing by your same logic as earlier you did with 2 statements, with out any concurrency issues,

Use BEGIN TRAN
write your select statement , udpate statement
COMMIT TRAN.

This will help you do kind of locking table and wont have any concurrency issues,I am lill confused with you explanation abt output deleted.colum above if you can explain lill more may b I can help.
Just shared my thought. take it if its helpful.
[/quote]

agreed....concurrency issues rakunda aa sp lo unnavaatiki oka Transaction lo petteste chalu ani anukuntunna...

[CaliStar]

ltt