i need something like a function to do a specific job which work in a specific time.Like every first day of the year i want to sum all the members account amount to my tbl_information table's column. How can i do that?

Recommended Answers

All 2 Replies

When you open SQL Server Management Studio, you see SQL Server Agent. You can define jobs in the SQL Server Agent to be executed regularly at specified times.

Of course you may do so; Learn sql triggers,stored procedures, and functions.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.