question

Partha avatar image
Partha asked

CLR Stored Procedure

I have data in one table and that data needs to be loaded to another table after some processing. I want to write a CLR Stored Procedure in C#. How to do that? I need to Log each record status in another table.

stored-proceduresclr
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
TG avatar image
TG answered

This might help you get started: Using CLR Integration in SQL Server 2005

"after some processing"

it may be much more efficient to to bypass CLR and use native t-sql to do this.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.