|
How do I get the number of rows affected by a BULK INSERT on SQL Server (2008 if that matters)?
Started by Mathias on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
As a result of your BULK INSERT, as this may affect your result..
|
|
What is the importance of DTD and how it affects the display of the web page page at runtime
Started by vinay_rockin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In particular some browsers have a....
HTML version) you are targeting.
As mentioned, this tells the browser what exact type of document (eg .
DTD defines the type of document and in particular the specific version of the HTML spec you intended to target .
|
|
When I enable trace, e.g.:
How badly this affects application performance?
Started by dnk.nitro on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Writing to a file? Or is a DebugView tool opened to watch the system debug console... .
Are you turning on Tracing for WCF components, or using your own trace calls? Is there a trace listener attached (e.g .
As with most questions, the answer is "It depends".
|
Ask your Facebook Friends
|
I'm hoping to learn assembly language for x86. I'm on a Mac, and I'm assuming most x86 tutorials/books use code that's meant for Windows.
How does the OS that code is run on affect what the code does, or determine whether the code even works? Could I ...
Started by stalepretzel on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Unless you're doing extremely low-level hackery (that is, OS development), the nuts and bolts of how is typically how you access an assembly....
Also a big part of the difference is in how the program communicates.
Different behavior.
|
|
I read that you should define your javascript functions in the <head> tag, but how does the location of the <script> (whether in the <head> , <body> , or any other tag) affect a javascript function.
Specifically, I would like to...
Started by Mark Rogers on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
It ....
Not saying it is always going to happen, just that it may depending on browser type or version .
If you have an inline script (outside functions) located before functions it may call, you may get an error because they may not be not available yet .
|
|
For INSERT , UPDATE and DELETE SQL statements executed directly against the database, most database providers return the count of rows affected. For stored procedures, the number of records affected is always -1 .
How do we get the number of records affected...
Started by dthrasher on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
@@ROWCOUNT
Register an out parameter for the stored procedure, and set the value based on @@ROWCOUNT... .
For Microsoft SQL Server you can return the @@ROWCOUNT variable to return the number of rows affected by the last statement in the stored procedure.
|
|
Mysql_affected_rows is to get number of affected rows in previous MySQL operation, but I want to get affected rows in previous MySQL operation. For example:
update mytable set status=2 where column3="a_variable";
Before this operation, status of some ...
Started by Steven on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In response to your question tho, in order to do what you are suggesting you would need to keep a copy of the SQL table prior to the change and compare... .
The implementation and function you are asking about is from PHP, please tag your question with PHP .
|
|
How does fast user switching affect a windows service? Are the services suspended? or do they keep running in the background when a different user logs in?
Started by Jason on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
On Vista, services run in session 0.....
Switching between users should have no impact on a properly written service .
Windows services run in the background even if no user is logged in .
They keep running; they run as their own users (whatever you set) .
|
|
When I execute a sql statement like "Select ...", I can only see "...100%" completed...
I want to log the number of rows affected.
How can we do that?
Started by tful on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
--your select goes here SELECT @Rows=@@ROWCOUNT INSERT INTO YourLogTable....
CREATE PROCEDURE SSIS_TaskA AS DECLARE @Rows int SELECT ...
Run your SELECT from within a stored procedure, where you can log the rowcount into a table, or do anything else to record it.. .
|
|
Now I know how one can execute mysql queries \ commands from bash :
mysql -u[user] -p[pass] -e "[mysql commands]"
or
mysql -u[user] -p[pass] `<<`QUERY_INPUT [mysql commands] QUERY_INPUT
My question is : How can I capture how many rows where affected...
Started by theBlinker on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
V -v" as parameters to the mysql command forces it to be more verbose and it spits out how many.
|
