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 2000 Forums
 SQL Server Development (2000)
 automatic update

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-12 : 08:52:12
Irfan writes "Hi,

For creating an online banking system,i want that the interest should be added to the current balance automatically at the end of each month.
how can i do this ? can i use triggers?"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-04-12 : 08:55:31
No, triggers need to be triggered by something.

You can write a stored proc, and schedule it as a job.

What bank is it ? I want to be sure my money is never there. Or is this a homework question ?

Damian
Go to Top of Page
   

- Advertisement -