• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

large CLR types on SQL Server

Can someone name the large CLR types for me? Are nvarchar(max), varchar(max) etc. considered large CLR types?
0
YZlat
Asked:
YZlat
  • 2
1 Solution
 
ZberteocCommented:
I think only XML, and spatial data types, geometry and geography, are implemented as CLR in SQL server. All the others are native SQL. The thing with varchar and nvarchar (max) is that they are now used instead of the deprecated image, text and ntext types.
0
 
YZlatAuthor Commented:
What i need is the names for those types so I could query sys tables for them
0
 
ZberteocCommented:
xml, geometry, geography
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now