Blog

Implemented I/O SQL Server Data Types in {3S} SQL Smart Security

Apr 2

Written by:
4/2/2012 7:35 PM  RssIcon

Main SQL Server Data Types Supported by SQL Server 2005 Supported by SQL Server 2008-R2 Supported by SQL Server 2012 Implemented by {3S} Smart Security
bigint YES YES YES YES
binary YES YES YES YES
bit YES YES YES YES
char YES YES YES YES
date NO YES YES YES
datetime YES YES YES YES
datetime2 NO YES YES YES
datetimeoffset NO YES YES YES
decimal YES YES YES YES
float YES YES YES YES
hierarchyid NO YES YES NO - coming soon
image YES YES YES YES
int YES YES YES YES
money YES YES YES YES
nchar YES YES YES YES
ntext YES YES YES YES
numeric YES YES YES YES
nvarchar/nvarchar(max) YES YES YES YES
real YES YES YES YES
smalldatetime YES YES YES YES
smallint YES YES YES YES
smallmoney YES YES YES YES
sql_variant YES YES YES YES
text YES YES YES YES
time NO YES YES YES
timestamp YES YES YES YES
tinyint YES YES YES YES
uniqueidentifier YES YES YES YES
varbinary/varbinary(max) YES YES YES YES
varchar/varchar(max) YES YES YES YES
xml YES YES YES YES

Other SQL Server Data Types Supported by SQL Server 2005 Supported by SQL Server 2008-R2 Supported by SQL Server 2012 Implemented by {3S} Smart Security
Geography
NO
YES, CLR
YES, CLR
NO - in the future
Geometry
NO
YES, CLR
YES, CLR
NO - in the future
User Defined Data Types
YES YES YES NO - in the future
User-Defined Table Types => Table-valued parameters
NO YES YES NO - in the future
Data Type/User-Defined Type
YES, CLR
YES, CLR
YES, CLR
NO - in the future


Additional Notes:
  • SSMS >> {3S} SQL Smart Security >> Options... >> Encryption >> WITH ENCRYPTION:
  • Database objects encryption by means of built-in MS SQL Server WITH ENCRYPTION mechanism for non-supported I/O parameters.

Additional References:


Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 

Blog

You must be logged in and have permission to create or edit a blog.

Search

Archive

Recent Comments

There are no recent comments on this blog.