data Type equivalent in SQL Server

What is the sqlserver equivalent of MS Access INT datatype?Arul,
From the Access docs:
ANSI SQL
data type Microsoft Jet
SQL data type
Synonym Microsoft SQL
Server data type
BIT, BIT VARYING BINARY (See Notes) VARBINARY,
BINARY VARYING
BIT VARYING BINARY, VARBINARY
Not supported BIT (See Notes) BOOLEAN, LOGICAL, LOGICAL1, YESNO BIT
Not supported TINYINT INTEGER1, BYTE TINYINT
Not supported COUNTER (See Notes) AUTOINCREMENT (See Notes)
Not supported MONEY CURRENCY MONEY
DATE, TIME, TIMESTAMP DATETIME DATE, TIME (See Notes) DATETIME
Not supported UNIQUEIDENTIFIER GUID UNIQUEIDENTIFIER
DECIMAL DECIMAL NUMERIC, DEC DECIMAL
REAL REAL SINGLE, FLOAT4, IEEESINGLE REAL
DOUBLE PRECISION, FLOAT FLOAT DOUBLE, FLOAT8, IEEEDOUBLE, NUMBER (See
Notes) FLOAT
SMALLINT SMALLINT SHORT, INTEGER2 SMALLINT
INTEGER INTEGER LONG, INT, INTEGER4 INTEGER
INTERVAL Not supported Not supported
Not supported IMAGE LONGBINARY, GENERAL, OLEOBJECT IMAGE
Not supported TEXT (See Notes) LONGTEXT, LONGCHAR, MEMO, NOTE, NTEXT
(See Notes) TEXT
CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER
VARYING CHAR (See Notes) TEXT(n), ALPHANUMERIC, CHARACTER, STRING, VARCHAR,
CHARACTER VARYING, NCHAR, NATIONAL CHARACTER, NATIONAL CHAR, NATIONAL
CHARACTER VARYING, NATIONAL CHAR VARYING (See Notes) CHAR, VARCHAR, NCHAR,
NVARCHAR
HTH
Jerry
"Arul" <Arul@.discussions.microsoft.com> wrote in message
news:CD7AAB64-2F05-4C97-B947-B3E47CD460F5@.microsoft.com...
> What is the sqlserver equivalent of MS Access INT datatype?|||We'll that didn't come over well. OK...INT.
HTH
Jerry
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23f2EB4FyFHA.2228@.TK2MSFTNGP11.phx.gbl...
> Arul,
> From the Access docs:
> ANSI SQL
> data type Microsoft Jet
> SQL data type
> Synonym Microsoft SQL
> Server data type
> BIT, BIT VARYING BINARY (See Notes) VARBINARY,
> BINARY VARYING
> BIT VARYING BINARY, VARBINARY
> Not supported BIT (See Notes) BOOLEAN, LOGICAL, LOGICAL1, YESNO BIT
> Not supported TINYINT INTEGER1, BYTE TINYINT
> Not supported COUNTER (See Notes) AUTOINCREMENT (See Notes)
> Not supported MONEY CURRENCY MONEY
> DATE, TIME, TIMESTAMP DATETIME DATE, TIME (See Notes) DATETIME
> Not supported UNIQUEIDENTIFIER GUID UNIQUEIDENTIFIER
> DECIMAL DECIMAL NUMERIC, DEC DECIMAL
> REAL REAL SINGLE, FLOAT4, IEEESINGLE REAL
> DOUBLE PRECISION, FLOAT FLOAT DOUBLE, FLOAT8, IEEEDOUBLE, NUMBER (See
> Notes) FLOAT
> SMALLINT SMALLINT SHORT, INTEGER2 SMALLINT
> INTEGER INTEGER LONG, INT, INTEGER4 INTEGER
> INTERVAL Not supported Not supported
> Not supported IMAGE LONGBINARY, GENERAL, OLEOBJECT IMAGE
> Not supported TEXT (See Notes) LONGTEXT, LONGCHAR, MEMO, NOTE, NTEXT
> (See Notes) TEXT
> CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER
> VARYING CHAR (See Notes) TEXT(n), ALPHANUMERIC, CHARACTER, STRING,
> VARCHAR, CHARACTER VARYING, NCHAR, NATIONAL CHARACTER, NATIONAL CHAR,
> NATIONAL CHARACTER VARYING, NATIONAL CHAR VARYING (See Notes) CHAR,
> VARCHAR, NCHAR, NVARCHAR
>
> HTH
> Jerry
> "Arul" <Arul@.discussions.microsoft.com> wrote in message
> news:CD7AAB64-2F05-4C97-B947-B3E47CD460F5@.microsoft.com...
>|||The datatype in sqlserver is varchar for the column I'm working on. I used
cast(column_name as int) when creating a view. I linked this view in access
db. When I join these two objects, its gives me a datatype mismatch error!
"Jerry Spivey" wrote:

> Arul,
> From the Access docs:
> ANSI SQL
> data type Microsoft Jet
> SQL data type
> Synonym Microsoft SQL
> Server data type
> BIT, BIT VARYING BINARY (See Notes) VARBINARY,
> BINARY VARYING
> BIT VARYING BINARY, VARBINARY
> Not supported BIT (See Notes) BOOLEAN, LOGICAL, LOGICAL1, YESNO BIT
> Not supported TINYINT INTEGER1, BYTE TINYINT
> Not supported COUNTER (See Notes) AUTOINCREMENT (See Notes)
> Not supported MONEY CURRENCY MONEY
> DATE, TIME, TIMESTAMP DATETIME DATE, TIME (See Notes) DATETIME
> Not supported UNIQUEIDENTIFIER GUID UNIQUEIDENTIFIER
> DECIMAL DECIMAL NUMERIC, DEC DECIMAL
> REAL REAL SINGLE, FLOAT4, IEEESINGLE REAL
> DOUBLE PRECISION, FLOAT FLOAT DOUBLE, FLOAT8, IEEEDOUBLE, NUMBER (Se
e
> Notes) FLOAT
> SMALLINT SMALLINT SHORT, INTEGER2 SMALLINT
> INTEGER INTEGER LONG, INT, INTEGER4 INTEGER
> INTERVAL Not supported Not supported
> Not supported IMAGE LONGBINARY, GENERAL, OLEOBJECT IMAGE
> Not supported TEXT (See Notes) LONGTEXT, LONGCHAR, MEMO, NOTE, NTEXT
> (See Notes) TEXT
> CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER
> VARYING CHAR (See Notes) TEXT(n), ALPHANUMERIC, CHARACTER, STRING, VARCHAR
,
> CHARACTER VARYING, NCHAR, NATIONAL CHARACTER, NATIONAL CHAR, NATIONAL
> CHARACTER VARYING, NATIONAL CHAR VARYING (See Notes) CHAR, VARCHAR, NCHAR,
> NVARCHAR
>
> HTH
> Jerry
> "Arul" <Arul@.discussions.microsoft.com> wrote in message
> news:CD7AAB64-2F05-4C97-B947-B3E47CD460F5@.microsoft.com...
>
>|||Check the values. I bet at least one of them is not numeric!
select *
from <table>
where (isnumeric(column) = 0)
ML|||Can you post the syntax of the query you are trying to run?
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Arul" <Arul@.discussions.microsoft.com> wrote in message
news:08463266-E902-47E5-A7D2-0E12C6AA3BA7@.microsoft.com...
> The datatype in sqlserver is varchar for the column I'm working on. I
> used
> cast(column_name as int) when creating a view. I linked this view in
> access
> db. When I join these two objects, its gives me a datatype mismatch
> error!
> "Jerry Spivey" wrote:
>|||how are you linking. most probably that is ado vs dao error in access. Chang
e
Controls to use ado by default in access.
Regards
R.D
--Knowledge gets doubled when shared
"Louis Davidson" wrote:

> Can you post the syntax of the query you are trying to run?
> --
> ----
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Arguments are to be avoided: they are always vulgar and often convincing.
"
> (Oscar Wilde)
> "Arul" <Arul@.discussions.microsoft.com> wrote in message
> news:08463266-E902-47E5-A7D2-0E12C6AA3BA7@.microsoft.com...
>
>