Database

cmd.CommandText = "INSERT INTO cdr_log (cdr_row) values (?p_cdr_raw)";
cmd.Parameters.Add("p_cdr_raw", MySqlDbType.VarChar);

...

cmd.Parameters["p_cdr_raw"].Value = cdr_raw; //suppose cdr_raw is the variable with the value you want to insert

cmd.ExecuteNonQuery();  

jrahma wrote:

so how can I avoid the error?

if exists(select top 1 1 from [table] where [key] = [parameter])
begin
    -- insert
end
else
begin
    -- update
end

LIMIT 60 

SELECT table_1.PropID, FullStreetAddress, City, State, Zipcode, Remarks, Date, table_2.URL
FROM table_1 LEFT JOIN table_2 ON table_1.PropID=table_2.PropID
WHERE table_1.PropID IN
(SELECT PropID
FROM table_1
WHERE <your selection criteria>
LIMIT 60)

Uma Shankar Patel wrote:

select @DataID=MAX(taskid) from tblTaskAssign;
insert into tblJobs (taskid,taskname,completiondate) values (@DataID,@taskname,@completiondate)

DECLARE @DataID int
set @DataID = (select isnull(max(taskid),0) from tblTaskAssign)

   insert into tblJobs (taskid,taskname,completiondate) values (@DataID ,@taskname,@completiondate)