<div>
Print Out ???<br />
<br />
You cannot print from a trigger (whatever you mean by &quot;Print&quot;)<br />
<br />
/Richard
</div>


<div>
Well if u insert Bulk records in sql query analyzer and we have a trigger being fired on same table which has print statements then we can see in query analyzer<br />

</div>


<div>
ok let me put it in this way :<br />
<br />
all the Inserted records(ie bulk Insert) into customer Table (with columns &nbsp;customer_ID,CustomerName) <br />
<br />
...Now the trigger is fired on the customer Table and all the inserted records should be inserted into a different table known as History with the same columns Customer_id,customerName..<wbr />......<br />
<br />
Lets consider this 
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a stored procedure which INSERTS BULK RECORDS into a Table using OpenXML approach<br />
<br />
Now I would like to write a trigger on the same table to Print out all the inserted records <br />
Looping thru the inserted Table in Trigger..<br />
<br />
Considering Table -- Customer &nbsp; &nbsp;and bulk rows inserted in columns Customer_ID,Customer_Name <br />
<br />
can example be shown?
</div>
</div>


Hi,
I have a stored procedure which INSERTS BULK RECORDS into a Table using OpenXML approach

Now I would like to write a trigger on the same table to Print out all the inserted records 
Looping thru the inserted Table in Trigger..

Considering Table -- Customer    and bulk rows inserted in columns Customer_ID,Customer_Name 

can example be shown?

Print Out ???

You cannot print from a trigger (whatever you mean by &quot;Print&quot;)

/Richard

Well if u insert Bulk records in sql query analyzer and we have a trigger being fired on same table which has print statements then we can see in query analyzer


ok let me put it in this way :

all the Inserted records(ie bulk Insert) into customer Table (with columns  customer_ID,CustomerName) 

...Now the trigger is fired on the customer Table and all the inserted records should be inserted into a different table known as History with the same columns Customer_id,customerName........

Lets consider this 

Write Trigger to Print Inserted Records

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.