Steps For Creating Clr Trigger?

1.	Steps For Creating Clr Trigger?
Answer» Follow these steps to create a CLR trigger of DML (after) type to perform an insert action: • Create a .NET class of TRIGGERING action • Make an assembly (.DLL) from that Class • Enable CLR environment in that database. • Register the assembly in SQL Server • Create CLR Trigger USING that assembly Follow these steps to create a CLR trigger of DML (after) type to perform an insert action: • Create a .NET class of triggering action • Make an assembly (.DLL) from that Class • Enable CLR environment in that database. • Register the assembly in SQL Server • Create CLR Trigger using that assembly

Answer»

Follow these steps to create a CLR trigger of DML (after) type to perform an insert action:
• Create a .NET class of TRIGGERING action
• Make an assembly (.DLL) from that Class
• Enable CLR environment in that database.
• Register the assembly in SQL Server
• Create CLR Trigger USING that assembly

Follow these steps to create a CLR trigger of DML (after) type to perform an insert action:
• Create a .NET class of triggering action
• Make an assembly (.DLL) from that Class
• Enable CLR environment in that database.
• Register the assembly in SQL Server
• Create CLR Trigger using that assembly

Discussion

No Comment Found

Related InterviewSolutions

Explain The Different Types Of Assemblies?
Can One Dll File Contains The Compiled Code Of More Than One .net Language?
What Is The Maximum Number Of Classes That Can Be Contained In One Dll File?
Explain The Differences Between Managed And Unmanaged Code?
What Is Side-by-side Execution? Can Two Applications, One Using A Private Assembly And Other Using A Shared Assembly, Be Stated As Side-by-side Executables?
Why Is String Called Immutable Data Type?
Briefly Describe The Roles Of Clr In .net Framework?
Mention The Core Components Of .net Framework?
What Are The Benefits Of .net Framework?
Mention The Execution Process For Managed Code?