<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#ffffff"
text="#000000">
On 09/05/2011 12:38 PM, Pau Marc Muñoz Torres wrote:
<blockquote
cite="mid:CADFuJLjCF6fmxswgS033EFyofmbJFy+J0ToUvwTCDDLYj+nr3Q(at)mail(dot)gmail(dot)com"
type="cite">Hi follk<br>
<br>
i trying to performe a conditional insert into a table, indeed,
what i'm trying to do is not insert a record into the table if
that record exist<br>
<br>
googleling i found something like<br>
<br>
insert into XX values (1,2,3) where not exist (select ....);<br>
<br>
but i'm having and error near where...<br>
<br>
anyone knows how do i can perfome this insert?<br>
<br>
thanks<br>
<br>
p<br>
</blockquote>
<p>You can either do an Insert(...) select... from...where...</p>
<p>or you can add a rule to the table that checks if the key exists
and if so, do an update or nothing instead.<br>
</p>
</body>
</html>