•
|
VARCHAR/NVARCHAR and LONGVARCHAR/NLONGVARCHAR columns are not padded with blanks to fill the columns. The significant data is terminated with a NULL character.
|
•
|
The LIKE predicate operates on the first 65500 bytes of the column data.
|
Any of the supported CONVERT data types except for GUID, BINARY, and LONGVARBINARY. The type parameter for CONVERT requires a prefix of “SQL_.” See CONVERT (exp, type [, style ]).
|
|
•
|
By providing a quoted string in the form 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' in which each x is a hexadecimal digit in the range 0-9 or A-F. For example, '1129619D-772C-AAAB-B221-00FF00FF0099' is a valid UNIQUEIDENTIFIER value.
|
•
|
•
|