No announcements
Found 2529631 threads
-
0 VotesBest way to write INSERT in C#
>what is the best way to use INSERT INTO in C# and why?Answered | 5 Replies | 612 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
BEST WAY OF WRITING CODE
Which is the Best way in writing the code below ( 1 or 2 or 3) Which one gives the best execution plan?Answered | 6 Replies | 1987 Views | Created by KODI_KODI - Thursday, January 10, 2013 10:52 PM | Last reply by Varsha Mishra - Friday, January 11, 2013 12:40 PM -
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) ...Answered | 5 Replies | 5431 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 -
0 Votes
Which is the best way to write to a file
To answer your question, obviously the lower level input/output is going to have the best performance (ie.Answered | 1 Replies | 674 Views | Created by Amrut S Anegundi - Monday, April 14, 2014 2:23 PM | Last reply by Brian Muth - Monday, April 14, 2014 3:39 PM -
3 Votes
Best way to ignore duplicate inserts
The way this is being done is via a stored procedure - one record at a time.Answered | 9 Replies | 1867 Views | Created by David Zemdegs - Wednesday, November 27, 2019 8:31 PM | Last reply by David Zemdegs - Thursday, November 28, 2019 7:52 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 | 1535 Views | Created by 07301a0525 - Wednesday, April 1, 2015 10:45 AM | Last reply by Syed Shakeer Hussain - Friday, April 3, 2015 8:39 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 | 4264 Views | Created by sakuraJP - Wednesday, October 27, 2010 3:59 AM | Last reply by Riced - Thursday, October 28, 2010 12:09 PM -
0 Votes
Best Way to Insert Row that May Exist
(c) by Donald Knuth Naomi Nosonovsky, Sr.Answered | 16 Replies | 4518 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
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 | 3856 Views | Created by Born2Achieve - Friday, May 7, 2010 4:07 PM | Last reply by Arun_NS - Saturday, May 8, 2010 3:45 PM -
1 Votes
Direct3d in c#, the best way
About the best way to do that?Answered | 7 Replies | 6560 Views | Created by MrCamelCase - Friday, January 22, 2010 10:20 AM | Last reply by MrCamelCase - Sunday, January 24, 2010 7:03 PM -
1 Votes
The best way to write records to database from Biztalk
You run the script in such a way that omit UDT.Answered | 7 Replies | 6359 Views | Created by MSDEVTECH - Thursday, July 14, 2011 7:20 PM | Last reply by MSDEVTECH - Monday, July 25, 2011 4:08 PM -
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 | 4696 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 write Query for parameter
By the way, you can giveAnswered | 5 Replies | 564 Views | Created by sks_989 - Thursday, April 7, 2016 2:34 PM | Last reply by Sam Zha - Friday, April 8, 2016 5:24 AM -
0 Votes
Best way to write the output of sp_help_revlogin to a file
sqlcmd -E -S "SQL_Principal" -d master -Q "exec sp_help_revlogin" -o "C:\temp\Logins.sql" I am a SCCM admin and have not ...Answered | 9 Replies | 7696 Views | Created by pskubal1 - Wednesday, December 28, 2011 8:31 PM | Last reply by Ben Miller - DBAduck - Wednesday, January 4, 2012 5:22 AM -
0 Votes
Best way to learn C# on a budget
The cheapest way would propably be a book.Answered | 2 Replies | 2225 Views | Created by OhneDich - Sunday, July 14, 2013 12:02 AM | Last reply by CountryStyle - Sunday, July 14, 2013 2:07 AM -
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 | 7392 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
Best way to write the query for given Requirement
Is there any way that I can improve this query?Answered | 6 Replies | 670 Views | Created by Vijeth.Sankethi - Wednesday, October 14, 2015 9:07 AM | Last reply by Vijeth.Sankethi - Wednesday, October 14, 2015 11:26 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 | 3567 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 Read And Write To A Data Base
cmd.CommandText = "UPDATE " + TableName + " SET " + FieldName + " = " + YourValue + " WHERE " + ...Answered | 10 Replies | 2636 Views | Created by LearningVisualC2005 - Wednesday, December 10, 2008 8:53 PM | Last reply by Michael L. Wagner - Wednesday, December 10, 2008 10:52 PM -
0 Votes
Learning C#...
The hardest would be to simply use a text file as you would have to write your own parsing utilities.Answered | 6 Replies | 3791 Views | Created by S. Cole - Friday, June 20, 2008 2:49 PM | Last reply by AlexBB - Vista Ult64 SqlSer64 WinSer64 - Saturday, June 21, 2008 3:15 AM - Items 1 to 20 of 2529631 Next ›
No announcements
