Viewing 15 posts - 1 through 15 (of 18 total)
Ya I join corrected table. but test with different data which is not available in Master Table . That is why join condition not satisfy. So Trigger fired but not...
June 26, 2011 at 12:57 pm
I made a blunder. Problem with Test data. Now every thing is solved. 🙂
June 26, 2011 at 12:32 pm
@Welsh Corgi
had u check my posted code. I already used SqlBulkCopyOptions.FireTriggers
Via Sql Profiler now I able to see Trigger is fired. But data is not inserted into destination table...
June 26, 2011 at 12:22 pm
Your options is welcome. I did the job that way. But I just want to know why it is not working?
June 25, 2011 at 11:54 pm
Your solution is excellent
April 27, 2011 at 12:16 pm
Hi Gianluca Sartori ,
Just excelent reply in a constructive way. Even I also not prefer "ORMs". Because adopting something new also a questinable point may be other factors also [technical...
December 14, 2010 at 4:57 am
If I exclude the security reason. What will be your answer ? Performace means I want to say faster, optimized.
December 14, 2010 at 3:46 am
Hi Gianluca,
1st of all thanks for your nice reply.
1. Query parsing / compilation
So do you mean SP and cached Inline Query (Parametarized SQL of ORM using sp_executesql) performance wise...
December 14, 2010 at 3:38 am
March 4, 2010 at 11:16 am
February 23, 2010 at 12:22 am
Hi Ben,
Your recommendation is appreciated, But not always need to delete Temp table explicitly. If someone working as DBA, then he or she have oder option to handle DB as...
February 22, 2010 at 11:35 pm
Paul thanks for your reply. no of table limited to 4 is just a example. it may be more than that. U r right that this is a lengthy operation....
February 22, 2010 at 10:00 am
February 22, 2010 at 9:44 am
February 22, 2010 at 6:29 am
February 22, 2010 at 4:02 am
Viewing 15 posts - 1 through 15 (of 18 total)