• subscribe
June 22, 2004 12:00 AM

Mapping T-SQL Data Types to SqlTypes

SQL Server Pro
InstantDoc ID #42874

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.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...