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
Writing a CLR Stored Procedure on SQL Server

As I mentioned in my previous posts, CLR objects on SQL Server can be very useful in certain scenarios. Here I will show you how to create, deploy and test a simple CLR stored procedure. This stored procedure will return a file list from the file system upon the specified path.

Read full article
What is a Stored Procedure in SQL Server

A Stored Procedure is a single or a set of SQL statements typically involving some (or a lot of) logic typically designed to accomplish a business data operation. Think of it as a T-SQL script stored in the database itself. Best practices suggests that all data-centric business logic operations should be encapsulated in stored procedures at the database level.

Read full article


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