by: Ajay Garg |
last post by:
I want to Insert 10000 rows at a time and commit in sql server , Is
there a way to do it if the source tables have no id fields ?
What would be the most efficient method?
Thanks
Ajay
|
by: Matthias |
last post by:
Hi,
I am just reading that book by Scott Meyers. In Item 4 Meyers suggests
to always use empty() instead of size() when probing for emptyness of
STL containers. His reasoning is that size()...
|
by: Paul Reddin |
last post by:
Hi,
(V8.1 Fp2)
Our application uses JDBC batch to execute mutiple insert statements
and we saw a strange thing this morning.
There were 4 SQL Insert statements in the batch, and we know the...
|
by: MLH |
last post by:
I have a batch file named GetConf.bat.
It contains a line like this:
ipconfig /all >c:\MyAppDir\IPdata.txt
I believe I could run the line with something
like ShellWait by Terry Kreft. Any...
|
by: andy6 |
last post by:
I am using the following code and SQL Profiler shows no activity when I step
through the .update line. Do you see a syntax error?
Thanks!
using (SqlConnection cn = new SqlConnection(cnStr))
{...
|
by: fingermark |
last post by:
If it's possible, can someone tell me how I could ignore and log
SqlBulkCopy duplicate key errors?
So, if the bulkCopy.WriteToServer(dt); errors on duplicate key, I want
it to log what the row...
|
by: subramanian |
last post by:
I have been thinking that all pointers(to any obejct) have the same
size. The size of a pointer is the size of an int. This is beause a
memory location is addressed by an int. Is that right/wrong?
|
by: bravo |
last post by:
hi
using mysql 4.1 i wish to update records using batch update but for a batch of 100, records and table having only 5000 records execution time is approx 2.4 sec i want to know whether this time...
|
by: shapper |
last post by:
Hello,
I have been reading a few articles about font sizing and I get various
versions.
All them say to use em ... ok that is what I use. But then they differ
on the text size "initialization"....
|
by: SteveB |
last post by:
Hi All,
Using the SQLBulkCopy for big CSV files consumes almost all the memory in
the computer. I found how to resolve this problem while google that, but no
code was added. The person claimed...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|