Insert Query in My Sql,sql server with duplicates

Question

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 19-Mar-13 21:50pm

Neetesh Agarwal

Add a Solution

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

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

vinodkumarnie · Accepted Answer · 2013-03-19T22:49:00

Solution 2

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[^]

Posted 19-Mar-13 22:49pm

vinodkumarnie

Updated 19-Mar-13 22:50pm

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

:-)

Neetesh Agarwal · Accepted Answer · 2013-03-19T22:23:00

Solution 1

Insert Ignore into table_name(a,b,c) Values (1,2,3)

Posted 19-Mar-13 22:23pm

Neetesh Agarwal

Comments

vinodkumarnie 20-Mar-13 7:13am

But how will you update it for every 15 min..?