[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

how to automatically update table in sqlserver 2005

I have one table in sql server 2005.it is updating from different table .I want to do these updates automatically everyday.
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what is the question, actually?
how to formulate the UPDATE/INSERT/DELETEs needed, or how to run the code "every day"?
if it's the second part, you "just" schedule the SQL, with either the sql agent, or, if that is not available, you run the sql using sqlcmd command line tool from within the windows scheduled task
Alpesh PatelAssistant ConsultantCommented:
Create trigger on tables from where you are updating thjs table.

Or create SSIS package to get update from all tables.
peterstiAuthor Commented:

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now