Novick Software
SQL Server Consulting Design Programming Tuning

  andy novick is a sql server mvp

 

 

Creating SQL Server User-Defined Types with the .Net CLR

User-Defined Types (UDT) are a new feature of SQL Server 2005 (f.k.a. Yukon).  These types may be used as the type in a column or used as the type for a local variable.  Unlike standard SQL Server types, these types are created using .Net in languages such as C# and VB.Netj.

Download slides.     Download Code Samples.

SQL Server 2005 allows the creation of user-defined types using the .Net CLR.  That's right, they're written in a .Net language such as C# or Visual Basic.Net.

  • Using SQL Types and .Net Types
  • Working with the SQL Server managed data provider inside the type.
  • Using SQL Types from client code in ADO.Net

The presentation also touches on high level topics such as:

  • When is it appropriate to use .Net code versus T-SQL

Scheduled Presentations:

Microsoft Code Camp IV
Sept. 24-25 2005

Mini-Code Camp

SQL Server Programming: From 2000 to 2005

October 22, 2005

Register

   

 


RSS as HTML

Personal Blog

 
New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule