List of SQL Server Proprietary Data Types?

Could someone point me to a list of SQL Server proprietary data types? Tried
searching this forum and the web but couldn't find a full published list.
Thanks.
NaveenTry,
select [name]
from master.dbo.systypes
go
AMB
"Naveen" wrote:

> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen|||That seems to be a list of all data types in SQL Server. I should have been
more clear. I meant non-ANSI compliant datatypes in SQL Server.
"Alejandro Mesa" wrote:
> Try,
> select [name]
> from master.dbo.systypes
> go
>
> AMB
> "Naveen" wrote:
>|||So, get a list of ANSI data types, and say:
SELECT [name] FROM master.dbo.systypes
WHERE [name] NOT IN ('type1', 'type2', etc)
Obviously, SQL Server doesn't have a flag called ANSI_COMPLIANT...
A
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:67059C80-35BA-4251-AB3F-0E442E582F2A@.microsoft.com...
> That seems to be a list of all data types in SQL Server. I should have
> been
> more clear. I meant non-ANSI compliant datatypes in SQL Server.
> "Alejandro Mesa" wrote:
>|||Some info here:
http://www.karaszi.com/SQLServer/in...i_datatypes.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:498D2709-8186-4F4D-88E1-9B5CAACA3D65@.microsoft.com...
> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen