Click here to Skip to main content
15,945,603 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello Friends,

I have a Query. I need to insert some value in database (fetch from gmail) and I need to update in every 15 minutes. I want only new value Insert in table. Please help me write a suitable query for it.
Posted
Comments
gvprabu 20-Mar-13 4:11am    
give some samples... wht u tried already?
Neetesh Agarwal 20-Mar-13 4:22am    
Hi gvprabhu . Thanks for replying .
I solved this by using Ignore Keyword, after Insert

If you want to update your table every 15 min you need to use Job schedule's.
Please refer below links...

Custom Scheduler - SQL Server Reporting Services[^]
A scheduler GUI for SQL Server Agent[^]
 
Share this answer
 
v2
Comments
Neetesh Agarwal 20-Mar-13 7:01am    
Thanks Vinod .......
vinodkumarnie 20-Mar-13 7:11am    
Welcome.. Job schedule is very interesting one.. Please go through it..
Neetesh Agarwal 20-Mar-13 7:19am    
Yeah I will. Thanks
vinodkumarnie 20-Mar-13 7:26am    
:-)
Insert Ignore into table_name(a,b,c) Values (1,2,3)
 
Share this answer
 
Comments
vinodkumarnie 20-Mar-13 7:13am    
But how will you update it for every 15 min..?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900