Subscribe to this blog
Chad Miller
Archives: April 2012
Appending New Rows Only
I saw a question in the forums related to inserting new rows into a SQL Server table only if they didn’t exist. The current solution was using an ADO.NET DataTable , checking for new rows and then pushing the rows back to SQL Server by calling the Update method on… Read more
2 comments, 1,287 reads
Posted in Chad Miller on 27 April 2012
Backup Database Object
I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is easy to solve, but only if you’re familiar with SMO . Even so, there some more obscure aspects of SMO like URNs which not many people are aware of. If… Read more
5 comments, 505 reads
Posted in Chad Miller on 17 April 2012
Table-Valued Parameter Example
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case of table-valued parameters is for sending a list or array of items as parameter to a SQL Server stored procedure or function. This is more efficient than parsing strings or… Read more
1 comments, 531 reads
Posted in Chad Miller on 13 April 2012