Bunch's Blog

One day I'll have a catchy subtitle, one day
posts - 87 , comments - 124 , trackbacks - 0

November 2011 Entries

Using Table Valued Parameters

In SQL Server 2008 you can use table valued parameters which can be pretty useful. In the example I use a very simple one to overcome SQL Server’s lack of having a parameter as an array. The example goes through creating the new type, using it in a stored procedure and calling it from an application (VB.Net in this example). You start off with creating the new type. Under Programmability/Types/User-Defined Table Types create a new table. Here I created a table with a single column to hold an int

Posted On Thursday, November 3, 2011 8:05 AM | Comments (2) |

Powered by: