0

Hi friend

I have a question of 2 parts
I have to insert new entries from a file in a table once every month
Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of the fiields an not all the fields for instans I have the following file struktue

name;age;adress;compnay

But I want only to insert name and compnay in the table.

Thanks a lot for your help.

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by Lido98
0

You can create job.
Job can be scheduled as per your need.
Which MS SQL version are you using?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.