Search
About me
Carlos Bercero Carlos Bercero is a BI Consultant for one of the leading BI firm in Puerto Rico, Nagnoi, Inc. (nagnoi.com). His professional IT career started in 1995 playing many different roles in the IT industry. He is now specialized in Business Intelligence Solutions and Custom Application Development.
SQL Stored Procedure Array Parameters Dilemma, Solved with CLR

If you work actively with SQL Server and do most of the data operations using stored procedures, then I bet that at least once, you wanted to pass an array of values as a parameter to a stored procedure (or function). Just like you, I had the same situation. I’ve seen many approaches to this problem and all of them has their pros and cons. I’ve implemented a solution using a CLR Stored Procedure, that I find quite practical and well performing.

Read full article


Domain Registrations starting at $9.69
Powered by Carlos Bercero Blog Platform © 2009