• subscribe
December 03, 1999 05:53 PM

SQL Server Data Field Types

SQL Server Pro
InstantDoc ID #7719

SQL Server data field types are similar to those for Jet databases, but with some distinct differences. For example, Jet's long integer data type corresponds to the int data type for SQL Server, and the integer data type for Jet matches the smallint type in SQL Server. The text and ntext data types in SQL Server align with the memo data types from Jet. Jet has a hyperlink data type that has no counterpart in SQL Server, and the timestamp column in SQL Server isn't available with Jet databases. These and other differences point to the need for Access developers to become familiar with SQL Server data types. For more information on SQL Server data types, see SQL Server Books Online (BOL) in the Microsoft SQL Server Programmer's Kit. The same documentation in BOL is available in the Microsoft Developer Network (MSDN) library CD-ROMs that ship with Microsoft Office 2000 Developer Edition (MOD).



ARTICLE TOOLS

Comments
  • Anonymous User
    7 years ago
    Jun 22, 2005

    total crap

  • Anonymous User
    7 years ago
    Jun 06, 2005

    loads of addvert no info

  • Anonymous User
    7 years ago
    Jan 03, 2005

    is it possible to store data beyond 255 characters on Ms-SQL server 2000 database

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 ...