How to automatically update database SQL Server?

Question

I need a field (column) of my database to update automatically. For example, the field NUMBER for each record incrementing every minute. How can I do it? I am using SQL Server.

Answer 1

You're probably looking for something called SQL Server Agent jobs

here is a good starting point reference:

http://technet.microsoft.com/en-us/library/ms181153(v=sql.105).aspx

This allows you to run some sql code on a schedule of your choosing.

P.S.

If you have access to sql server management studio, the GUI is much nicer.