No announcements
Found 3747273 threads
-
3 VotesBest way to ignore duplicate inserts
The way this is being done is via a stored procedure - one record at a time.Answered | 9 Replies | 1961 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 write INSERT in C#
>what is the best way to use INSERT INTO in C# and why?Answered | 5 Replies | 687 Views | Created by TakeshiKitano - Tuesday, September 27, 2016 4:30 PM | Last reply by Sabah Shariq - Wednesday, October 5, 2016 10:53 AM -
0 Votes
The best way to find tables that being inserted to?
SELECT 'CREATE TRIGGER myTrigger_'+st.name+ ' ON '+s.name+'.'+st.name+' FOR INSERT AS INSERT INTO audit(tbname) SELECT '''+st.name+'''' ...Answered | 5 Replies | 5478 Views | Created by Mark in Atlanta - Tuesday, November 2, 2010 9:22 PM | Last reply by Uri Dimant - Wednesday, November 3, 2010 12:10 PM -
1 Votes
the best way of read file and insert to DB
If your computer's memory is larger than the CSV file then way 1 is best (because you only have to read the file once).Answered | 7 Replies | 4321 Views | Created by sakuraJP - Wednesday, October 27, 2010 3:59 AM | Last reply by Riced - Thursday, October 28, 2010 12:09 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 | 1591 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
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 | 3899 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 Insert Row that May Exist
(c) by Donald Knuth Naomi Nosonovsky, Sr.Answered | 16 Replies | 4585 Views | Created by Jonathan Wood - Thursday, September 2, 2010 6:17 AM | Last reply by Jonathan Wood - Thursday, September 2, 2010 6:16 PM -
0 Votes
Which is the best way to insert html tags in webpart
A Visual WebPart would be the best in all these casesDeepak Sinha Logimindz Technologies Pvt.Answered | 3 Replies | 7442 Views | Created by Phanindra K - Monday, December 6, 2010 3:25 AM | Last reply by Dave Hunter - Monday, December 6, 2010 10:59 AM -
1 Votes
The best way to implement "lookup + insert new" logic
This technique will attempt to insert each unique City and State, but (and here's the key) if you have a UNIQUE constraint on the table for City Name, then it can't ...Answered | 2 Replies | 4740 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 insert entities into Azure TableStore
As you say that your code was busy preparing batches and hence you removed that code then I suggest following way to improve batching.Answered | 6 Replies | 3622 Views | Created by Anand Vanam - Friday, August 23, 2013 1:38 AM | Last reply by Ojas Maru - Thursday, August 29, 2013 11:30 PM -
0 Votes
Best way to update/insert items in an existing collection?
No, and what you are doing is typical and is the way to do it.Answered | 2 Replies | 520 Views | Created by TorstenTiedt - Tuesday, May 12, 2015 4:48 PM | Last reply by TorstenTiedt - Wednesday, May 13, 2015 7:31 AM -
0 Votes
Debatch XML files for inserting into SQL- Whats the best way
I hope this helps Greetings,HTH Naushad Alam When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, ...Answered | 2 Replies | 1618 Views | Created by SureshRKumar - Thursday, February 28, 2013 11:34 AM | Last reply by Naushad.Alam - Thursday, February 28, 2013 11:48 AM -
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 | 5738 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 to compare data in 2 data sources for insert into a target?
There are several ways to accomplish what you're looking for - but there are also several quirks to each method that work best in different scenarios.Answered | 9 Replies | 4937 Views | Created by Jon Strauss - Wednesday, January 7, 2009 10:24 AM | Last reply by SudhaSam - Tuesday, January 27, 2009 7:47 PM -
1 Votes
Best way of copying tables
I should have missed that paragraph :) Sorry Jon :) BI and ERP Senior Consultant @ Nexum Bogazici If it is, Please dont forget to mark as ...Answered | 7 Replies | 3694 Views | Created by york0001 - Friday, May 7, 2010 2:07 PM | Last reply by Manikandan S - Tuesday, May 11, 2010 11:08 AM -
0 Votes
Best way to insert a BR
User-1686683459 posted Argh!Answered | 2 Replies | 48 Views | Created by Anonymous - Monday, June 9, 2008 5:18 PM | Last reply by Anonymous - Tuesday, June 10, 2008 11:54 AM -
1 Votes
Best way to Insert Millions records in SQL Azure on daily basis?
When i migrate these on SQL Azure, i am unable to perform these operations in a faster way as i did in SQL 2008.Answered | 5 Replies | 5129 Views | Created by Ashish N - Thursday, January 8, 2015 11:15 AM | Last reply by Joseph Idziorek - Wednesday, February 11, 2015 2:08 PM -
3 Votes
Best way to handle insert/update process for application with high transaction of data?
Read this https://www.red-gate.com/simple-talk/books/sql-books/defensive-database-programming/ Best Regards,Uri Dimant SQL Server ...Answered | 4 Replies | 787 Views | Created by dmile - Monday, August 13, 2018 1:43 AM | Last reply by Uri Dimant - Wednesday, August 15, 2018 5:40 AM -
0 Votes
Best method for inserting/updating data
DECLARE @t TABLE (ID int) INSERT INTO @t SELECT SalesOrderDetailID FROM (MERGE Sales.SalesOrderDetail ...Answered | 9 Replies | 3386 Views | Created by Brian205 - Friday, May 11, 2012 7:09 PM | Last reply by Brian205 - Sunday, May 13, 2012 10:55 PM -
0 Votes
Best Way to Migrate Data
Hi Paul Muller, When you use MERGE command to access different databse, please use the fully qualified database name.Answered | 5 Replies | 1962 Views | Created by Paul Muller - Monday, November 26, 2012 8:34 PM | Last reply by Eileen Zhao - Tuesday, November 27, 2012 6:58 AM - Items 1 to 20 of 3747273 Next ›
No announcements
