SQL Server - Stored procedure call auto
on 10-Mar-12 02:15 PM
I am new to sql server i am able to create a procedure . i want to ask how to it will execute automatically in sql server?
on 10-Mar-12 02:20 PM
If you mean execute automatically on a schedule, you need to create a SQL Server Agent job for that.
on 10-Mar-12 02:43 PM
Thank you for your reply i have a update query of calculation from other columns and store in one column of DB. It can be done by SQL Server Agent job how if user enter the values in columns which get the result in one other column? it is possible when the values are entered in the columns the procedure call from sql?
on 10-Mar-12 03:14 PM
If you want something to happen when a row is inserted, study up on Triggers.