how to lock table data when it check the previous month in sql server 2005

2.67/5 (3 votes)

See more:

How to lock previous month salary calculation when process this month salary in sql server 2005... i am doing payroll project... when click the proceed button it will check the current month and lock the previous month... how can i proceed...

please anyone help me... i am using asp.net with c# 2010... and sql server management studio express... plz send any code for lock table data~~... within one hour... plz... i want urgent...~~

Posted 16-Feb-12 23:15pm

v surya dev

Updated 16-Feb-12 23:52pm

RDBurmon

Add a Solution

Comments

Jaganathan Bantheswaran 17-Feb-12 6:02am

Why you need to lock the Rows?

Varun Sareen 17-Feb-12 6:34am

Why you require to lock last month salary?

ZurdoDev 17-Feb-12 7:54am

I don't think he actually means to lock the rows. I think he just doesn't want the last month to change. Either way, there is no telling what he actually wants with this little amount of details.

Herman<T>.Instance 15-Mar-12 4:55am

Why don't you use a transaction?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

merano99	120
Mircea Neacsu	80
Pete O'Hanlon	50
Malcolm Arthur McLean	10
xigmond	5

Pete O'Hanlon	280
Richard Deeming	230
merano99	130
Richard MacCutchan	130
OriginalGriff	130

how to lock table data when it check the previous month in sql server 2005

Add your solution here

Preview 0

how to lock table data when it check the previous month in sql server 2005

Add your solution here

Preview 0

Existing Members

...or Join us