there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  


Is oracle faster than sql server?

0 Answers  


What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,


how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,


Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  


What is difference between rownum and row_number?

0 Answers  


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  


Explain what are page splits? : SQL Server Architecture

0 Answers  


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  


WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  


What is store procedure? How do they work? When do you use?

0 Answers  


how do we find every fifth record in a table

14 Answers   Aspire, HCL,


Categories