No announcements
Found 1353899 threads
-
0 Votesupdate the record in case it existed and insert in case it is not existed.
What are you passing for ID columns when you want to insert row?Answered | 3 Replies | 956 Views | Created by nikoo56 - Tuesday, April 29, 2014 6:47 PM | Last reply by Naomi N - Wednesday, April 30, 2014 12:37 AM
-
0 Votes
How to update a record if it exists or INSERT if it doesn't
Try below: create table #test (c2 int,c1 varchar(100)) Insert into #test Values (1,'099 11-12 Midwest Plumbers') create proc test_sp(@c2 int,@c1 ...Answered | 1 Replies | 1337 Views | Created by green2004 - Wednesday, November 6, 2013 2:53 PM | Last reply by SQLZealots - Wednesday, November 6, 2013 3:04 PM -
1 Votes
if record exists in XML file update else insert using LINQ C#
Hi Martin, I am trying to adopt the LINQ query you provided to query an XML file like this:Answered | 3 Replies | 12693 Views | Created by alokazia - Wednesday, June 3, 2009 5:27 PM | Last reply by alokazia - Wednesday, August 11, 2010 2:42 AM -
2 Votes
new to linq to sql - atomic insert and update
4) L2S is not ideal for 'batch' operations as it works with one record at a time when inserting, updating, and deleting.Answered | 2 Replies | 8165 Views | Created by Bit01 - Thursday, June 25, 2009 9:34 AM | Last reply by Martin Meixger - Saturday, December 4, 2010 11:02 AM -
0 Votes
atomic if not exists() and insert or update
If there is no match it would then insert a new record.Answered | 6 Replies | 13241 Views | Created by gidziu - Wednesday, May 5, 2010 1:24 AM | Last reply by gidziu - Thursday, May 6, 2010 2:12 AM -
0 Votes
Check if value exists on database LINQ
Hi, you can check for your solution ...Answered | 1 Replies | 10727 Views | Created by MrNow - Saturday, February 26, 2011 8:44 PM | Last reply by Mitja Bonca - Saturday, February 26, 2011 9:02 PM -
0 Votes
About the Insert, Update, and Delete operations in LINQ to SQL
There is a forum for Linq-2-SQL.Answered | 3 Replies | 895 Views | Created by e-mzRoy - Sunday, October 11, 2015 2:45 PM | Last reply by DA924 - Sunday, October 11, 2015 3:16 PM -
2 Votes
LINQ to SQL - Update and Insert in one C# method
Do you mean you want to insert and update records in one method ?Answered | 2 Replies | 31737 Views | Created by Haamakumba - Saturday, June 19, 2010 1:21 PM | Last reply by Alex Liang - Tuesday, June 22, 2010 6:25 AM -
0 Votes
How to insert only new records [ not exists in destination ] & update existing records [exists in destination]
thanks himanshu - i already implemented the same logic in my existing solution.Answered | 14 Replies | 14048 Views | Created by RMNathan - Wednesday, September 11, 2013 5:59 PM | Last reply by HimanshuSharma - Friday, September 13, 2013 11:22 AM -
3 Votes
Can I UPDATE, then INSERT if no record updated?
This way you check first and then you update if the record exists, otherwise you insert.Answered | 9 Replies | 10662 Views | Created by vspin - Tuesday, January 5, 2010 7:30 PM | Last reply by Abdshall - Tuesday, January 5, 2010 8:18 PM -
2 Votes
Linq to SQL - updating records
Lyncxbci, That is not Linq to SQL.Answered | 13 Replies | 662 Views | Created by Lynxbci - Thursday, February 4, 2016 2:54 PM | Last reply by Gtripodi - Thursday, February 4, 2016 7:49 PM -
0 Votes
In SSIS, insert if new and update if exists .
You can get more details about these two methods through walking through the following two ...Answered | 6 Replies | 4837 Views | Created by hongngoc - Tuesday, January 14, 2014 10:37 AM | Last reply by hongngoc - Sunday, March 23, 2014 2:55 PM -
0 Votes
Update if exists else insert
UPDATE STMT if @@ROWCOUNT = 0 INSERT STMT If you are using 2008 then as Peso suggested you should use the Merge stmt.Answered | 5 Replies | 9843 Views | Created by aniedv - Monday, August 31, 2009 5:08 AM | Last reply by Sankar Reddy - Tuesday, September 1, 2009 11:16 PM -
3 Votes
Insert or update record in HighScore table
However, the first thing it does in performs a request.execute that insert the new record.Answered | 12 Replies | 4023 Views | Created by Jason James - Sunday, May 5, 2013 8:46 PM | Last reply by Jeff Sanders - Tuesday, May 7, 2013 6:31 PM -
0 Votes
Insert, Update, Delete, Select Data using Linq
https://code.msdn.microsoft.com/Insert-Update-Delete-data-f39f431cAnswered | 2 Replies | 9315 Views | Created by Sritanu - Tuesday, December 15, 2009 7:36 PM | Last reply by Ehtesham Mehmood - Thursday, February 5, 2015 11:24 PM -
1 Votes
Search for record and then do insert or Update
Should I create another page to update record?Answered | 5 Replies | 1395 Views | Created by Ravi A Davawala - Wednesday, July 24, 2013 12:45 PM | Last reply by Christopher84 - Thursday, July 25, 2013 8:57 AM -
0 Votes
Linq tries to insert column which doesn't exist
Then I created Linq-to-SQL mappings by dragging all the tables onto my model from the server explorer.Answered | 1 Replies | 3245 Views | Created by jjczopek - Friday, January 27, 2012 11:49 AM | Last reply by Fernando Soto - MCSD - Saturday, January 28, 2012 7:30 PM -
0 Votes
If exists, update, if not, insert
There is no way to catch an update of a row that does not exist.Answered | 2 Replies | 5685 Views | Created by JCriSQL - Friday, April 13, 2012 4:27 PM | Last reply by Naomi N - Friday, April 13, 2012 6:41 PM -
0 Votes
Updating, Inserting, Deleting Records in DB
If you are using a TypedDataSet and created this by dragging the Tables from the data source window to a DataSet designer, then there are things called TableAdapters that are ...Answered | 1 Replies | 4539 Views | Created by Mankeer Senior Developer - Saturday, July 4, 2009 10:00 AM | Last reply by Chris Robinson- MSFT - Tuesday, July 7, 2009 8:52 PM -
1 Votes
Check For Record, Insert if Non-existent
However, not all records start with 'EPA'.Answered | 9 Replies | 4593 Views | Created by Jay Mazz - Friday, June 5, 2009 3:28 PM | Last reply by Jonathan Kehayias - Friday, June 5, 2009 4:31 PM - Items 1 to 20 of 1353899 Next ›
No announcements
