Add data in table with transaction and rollback

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Add data in table with transaction and rollback

Author

Topic

ashu1234
Starting Member

9 Posts

Posted - 2009-04-10 : 13:39:17

hello all friends
i have one table , and i want to insert or add salary which employee
does have salary minimum then reupess 5000 autometically his salary increse by 1000 repess...

i m using
select salary = salary+1000, empcode from tablename
where saalary< 5000

empcode salary work_hour

EM1001 4000 2 Hour
EM1002 5000 3 Hour
EM1003 6000 4hOUR
EM1004 8000 5 Hour
EM1005 1000 1 Hour
EM1006 9000 1 Hour
EM1007 2300 1 Hour

help me please
ashwani

ashwani

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-10 : 13:40:54

Your question is not clear. What is "reupess"?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-04-10 : 14:58:10

UPDATE OneTable
SET Salaray = salary + 1000
WHERE salary < 5000

Rupee

common name for the currencies used in India, Pakistan, Sri Lanka, Nepal, Mauritius, and Seychelles;

http://en.wikipedia.org/wiki/Rupee

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-10 : 15:12:08

Oh it was a typo! Now "rupee" I would have been able to figure out, but I stared at "reupess" for a while and just couldn't figure out the meaning. Thanks!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

dsindo
Starting Member

45 Posts

Posted - 2009-04-10 : 17:08:50

how much is $1 in rupees, might want that job.

ashu1234
Starting Member

9 Posts

Posted - 2009-04-11 : 07:15:48

Rupess means Currency ($)

ashwani

ashu1234
Starting Member

9 Posts

Posted - 2009-04-11 : 07:19:12

Hello yosiasz !!
I am complete with ur help!!
Bt what is transaction and rollback in sql server .
which problem i send to u this is also done in rollback and transaction .
please help me give me one example of rollback and transaction ???????

Thanks

ashwani

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources