Main Article    Beyond T-SQL: Digging into the CLR

In the long list of data types that the SqlClient.SqlTypes namespace exposes, you find lots of familiar data types to choose from. But which of these data types match the T-SQL data types you use in your server-side procedures? Table A lists T-SQL-to-SqlTypes conversions that I used in the main article, noting the quirks you need to be aware of. I've been told that the most recent builds of Visual Studio 2005 and SQL Server 2005 are more tolerant of native (as opposed to SqlTypes) data types. You can find the complete conversion list at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqltypes.asp.

End of Article


You must log on before posting a comment.

If you don't have a username & password, please register now.