|
Home > Archive > Microsoft SQL Server forum > June 2005 > Insert or Append?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Do Park via SQLMonster.com 2005-06-14, 11:23 am |
| Hello all,
Number of rows in a table was increased significantly. Is there a way to see
whether data was inserted in to the table, or whether data was appended to
the table?
Thanks in advance,
Do.
--
Message posted via http://www.webservertalk.com
| |
| Simon Hayes 2005-06-14, 11:23 am |
| What do you understand is the difference between "insert" and "append"?
Do you mean INSERT and BULK INSERT? In any case, there is no built-in
way to know which process INSERTed a row into a table, unless you log
that information yourself, either in the table or in some other way.
Simon
| |
| Erland Sommarskog 2005-06-14, 8:24 pm |
| Do Park via webservertalk.com (forum@nospam.webservertalk.com) writes:
> Number of rows in a table was increased significantly. Is there a way to
> see whether data was inserted in to the table, or whether data was
> appended to the table?
You can't append data to a table, as append implies an order, and tables.
logically, are unordered sets of data.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|
|
|
|
|