No announcements
Found 2566793 threads
-
1 Votesthe best way of read file and insert to DB
Otherwise way 2 is best because you would run out of memory doing way 1.Answered | 7 Replies | 4267 Views | Created by sakuraJP - Wednesday, October 27, 2010 3:59 AM | Last reply by Riced - Thursday, October 28, 2010 12:09 PM
-
0 Votes
insert more than 1000 rows
Use UNION ALL to insert...Answered | 3 Replies | 75478 Views | Created by Dkuud - Thursday, April 19, 2012 3:21 PM | Last reply by tanmoy2308 - Thursday, April 19, 2012 4:02 PM -
3 Votes
Best way to ignore duplicate inserts
For example I just handled a problem where if a row is less than three month old then consider it as duplicate otherwise its a new record.Answered | 9 Replies | 1873 Views | Created by David Zemdegs - Wednesday, November 27, 2019 8:31 PM | Last reply by David Zemdegs - Thursday, November 28, 2019 7:52 PM -
0 Votes
Best Way to Insert Row that May Exist
As said by Jonathan, "I'm writing a stored procedure to insert a row.Answered | 16 Replies | 4523 Views | Created by Jonathan Wood - Thursday, September 2, 2010 6:17 AM | Last reply by Jonathan Wood - Thursday, September 2, 2010 6:16 PM -
1 Votes
SQL: Best way to read a row from a DB?
Using David Morton's approach is a fast way to fetch results using the DataReader.Answered | 5 Replies | 3126 Views | Created by Jimmy Collins - Thursday, April 30, 2009 3:57 PM | Last reply by Jimmy Collins - Friday, May 1, 2009 8:45 AM -
0 Votes
optimal way to write data to DB
Another option is SQL Server Integration Services, which includes For Each file enumerators and data flow components that allow you to perform these import tasks ...Answered | 1 Replies | 5775 Views | Created by animageofmine1 - Monday, September 28, 2009 8:48 AM | Last reply by Dan Guzman - Monday, September 28, 2009 10:50 AM -
1 Votes
Select rows apart from the top 1000 rows
something like this To select all the rows except first 1000 rows select * from dbo.tablename except select top 100 * from ...Answered | 7 Replies | 4447 Views | Created by Mayooran99 - Friday, January 2, 2015 3:19 PM | Last reply by Ahsan Kabir - Saturday, January 3, 2015 8:01 PM -
0 Votes
Best way to transfer data
Hi sidx, the best way to transfer Lacs of rows would be using a SSIS package.Answered | 5 Replies | 5644 Views | Created by SIRIGINEEDI - Wednesday, January 4, 2012 5:32 PM | Last reply by Hunt_SQL - Friday, January 6, 2012 5:22 AM -
0 Votes
Best way of inserting data into Database from application
As suggested by Naom, the best way is to pass XML to stored proc.Answered | 6 Replies | 3861 Views | Created by Born2Achieve - Friday, May 7, 2010 4:07 PM | Last reply by Arun_NS - Saturday, May 8, 2010 3:45 PM -
0 Votes
Best way to transfer millions of rows
Hello, What is the best way to transfer more than 100 million rows from source to destination.Answered | 9 Replies | 1302 Views | Created by srikanth.kasu - Tuesday, April 7, 2015 5:04 PM | Last reply by Harry Bal - Wednesday, April 8, 2015 6:05 PM -
0 Votes
best way to insert 1000 row of data to DB
You could get and save your data in a DataTable, then you could use SqlBulkCopy.WriteToServer Method to copy all rows in the DataTable to a destination table.Answered | 4 Replies | 273 Views | Created by Anonymous - Monday, July 6, 2015 8:37 AM | Last reply by Anonymous - Wednesday, July 8, 2015 5:08 AM -
1 Votes
LocalInsertRemoteInsert - what is the best way to keep all data?
But anyway seems I have to go that way.Answered | 8 Replies | 10961 Views | Created by ekostron - Monday, February 8, 2010 9:28 PM | Last reply by Rudi - Euricom - Tuesday, February 9, 2010 1:16 PM -
1 Votes
The best way to implement "lookup + insert new" logic
Send each of those to respective OLE DB Destination, and set the Table Access Mode to Table or View (NOT Fast Load).Answered | 2 Replies | 4701 Views | Created by alec_k - Wednesday, November 10, 2010 10:49 AM | Last reply by Todd C - Wednesday, November 10, 2010 11:57 AM -
0 Votes
Best Way to Migrate Data
For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.Answered | 5 Replies | 1901 Views | Created by Paul Muller - Monday, November 26, 2012 8:34 PM | Last reply by Eileen Zhao - Tuesday, November 27, 2012 6:58 AM -
0 Votes
Best way to indentify offending row(s) in ssis package execution
http://rad.pasfu.com/index.php?Answered | 3 Replies | 4205 Views | Created by airwalker2000 - Monday, August 9, 2010 10:07 AM | Last reply by airwalker2000 - Monday, August 9, 2010 2:18 PM -
3 Votes
Best way to bulk insert records to sqlserver ??
Hi, If you want inset records using c# the best way is doing parallel Programming.Answered | 4 Replies | 1540 Views | Created by 07301a0525 - Wednesday, April 1, 2015 10:45 AM | Last reply by Syed Shakeer Hussain - Friday, April 3, 2015 8:39 PM -
0 Votes
Inserting over 10,000 rows in a datatable... is there a better way than INSERT INTO
I suppose the separate INSERT INTO statements will be the best.Answered | 9 Replies | 2789 Views | Created by Tom R.1956 - Tuesday, September 4, 2012 2:30 PM | Last reply by Tom R.1956 - Tuesday, September 4, 2012 11:14 PM -
2 Votes
Procedure to insert data in multiple rows
You can insert multiple rows using a single SQL INSERT statement: INSERT INTO Table ( Column1, Column2 ) VALUES ( Value1, Value2 ), ( Value1, ...Answered | 5 Replies | 1337 Views | Created by sreekanth.jonna - Saturday, September 20, 2014 5:16 PM | Last reply by Ahsan Kabir - Monday, September 22, 2014 1:20 PM -
0 Votes
Best way to write INSERT in C#
>what is the best way to use INSERT INTO in C# and why?Answered | 5 Replies | 617 Views | Created by TakeshiKitano - Tuesday, September 27, 2016 4:30 PM | Last reply by Sabah Shariq - Wednesday, October 5, 2016 10:53 AM -
1 Votes
Insert A Record For the Next 1000 Days
We have a DATE data type so why did you invent your own display format?Answered | 7 Replies | 948 Views | Created by JBHowl - Thursday, March 12, 2015 3:37 PM | Last reply by pituach - Tuesday, March 24, 2015 1:07 PM - Items 1 to 20 of 2566793 Next ›
No announcements
