There’s now a wide range of objects that a database developer can use to solve problems. For this post or two I’m considering certain objects (as implemented in MS SQL Server) and how I think they are probably best used . Continue reading Database Object Types – Some Design Considerations
Monthly Archives: July 2009
Using the User-defined Table types with ADO.Net structured parameter type
Late in March I released (started using a lot) a small C#/SQL Server project. It utilises the new User-Defined Table Type in SQL Server 2008 and the “structured” parameter type in ADO.NET. This allows a table originated on the client to be passed in to a stored procedure as a parameter. Oracle has had table data types for a while of course, and there are still some limitations to the SQL Server version, but it’s certainly very easy to use. Continue reading Using the User-defined Table types with ADO.Net structured parameter type
Enforcing the Table Type Returned by a Sql Function
I’d like to enforce the user-defined table type returned by a sql function, making the following code possible (I haven’t of course defined the function so it won’t execute): Continue reading Enforcing the Table Type Returned by a Sql Function
blog.philipsymons.com 