RSS

Tag Archive | "SQL"

SQL Server 2008 Table Valued Parameters

Sunday, December 23, 2007

10 Comments

Last two weeks I have been working on developing bulk data manipulations. And even before that I always wondered “What’s the best way to pass an array of values into a SQL Server stored procedure.” One option I found was OPENXML, which I blogged here. And I was trying out visual studio 2008 and SQL server [...]

Continue reading...

ADO.Net & OPENXML to Perform Bulk Database Operations

Tuesday, December 18, 2007

7 Comments

Last week at my work I had to write a tool to process few hundreds of thousand email files and insert their details to the MS SQL Server 2005 database. Doing it in traditional way might require much connectivity to the database and will consume many resources. I was wondering what if I could insert [...]

Continue reading...
Follow me