Lab Sql

I have a SQL CLR function like this one: public partial class UserDefinedFunctions { [Microsoft… Read more Clr Table-valued Function With Array Argument

In the infinte wisdom of the global DBA at a firm I am working at right now he has created a table … Read more Auto Increment Sql Value

Is it possible to pass a parameter of type 'table' with a column of type '[int] IDENTIT… Read more Identity Column In A Table-valued Parameter In Procedure, How To Define Datatable

I have some complex function that I want to use in number of queries. It gets some list of values a… Read more How To Pass User-defined Table Type To Inline Function

If I have a SQLDataRecord that includes a RowVersion column as shown in the code below. I always … Read more How Can I Include A Rowverson Column In A Table Valued Parameter When Calling A Stored Procedure?

I like to find a way to handle multiple updates to a sql db (with one singe db roundtrip). I read a… Read more Handle Multiple Db Updates From C# In Sql Server 2008

Using SQL Server 2012, is it possible to eliminate the need to declare a table-valued parameter (TV… Read more Create And Pass A Table-valued Parameter In A Single Line