Latest data Articles - Page 10

Learn about 10 things your O/R mapping tools must have to be more efficient.

When you write to an underlying table via a CLR database object, a number of questions come up. Get the answers—along with a breakdown of how System.Transactions, a new .NET namespace, can help.

Get an introduction to the extended SQL Server 2005 trigger functionality that Data Definition Language (DDL) triggers provide for both databases and servers.

Go one step beyond the Standard Template Library (STL) with the Database Template Library (DTL), which offers many advantages over the traditional procedural approach to database access.

When you write code to be run inside SQL Server 2005, you usually want to deal with other database objects. Learn how to write a CLR-stored procedure that uses a simple table valued function to handle that scenario in a couple of ways.

You can use CRL to author a number of database objects. Follow a canonical example that explains the main steps involved in using and creating a CLR object inside SQL Server 2005.