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.

Pseudonym · Accepted Answer · 2014-07-14 20:16:55Z

2

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.

answered Jul 14, 2014 at 20:16

Pseudonym

2,0722 gold badges18 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dave.Gugg · Accepted Answer · 2014-07-14 20:16:35Z

2

You can set up a SQL Agent job to run an update statement once a minute:

UPDATE tablename
SET NUMBER = NUMBER + 1

answered Jul 14, 2014 at 20:16

Dave.Gugg

6,8013 gold badges26 silver badges45 bronze badges

Comments

magic-s · Accepted Answer · 2014-07-14 20:26:26Z

2

Job Agent is only for full SQL Server. Then best choise. If you using SQL express then can't. You can solve with update

UPDATE TABLE-NAME SET
VALUE = VALUE + 1

answered Jul 14, 2014 at 20:26

magic-s

2421 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to automatically update database SQL Server?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related