Showing posts with label triedsearching. Show all posts
Showing posts with label triedsearching. Show all posts

Friday, March 9, 2012

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