CODEWITHSUNDEEP
sqlsql-serverdatabaseoracle-databaseclob
Julio
Julio

Reputation: 6368

EMPTY_CLOB() in Microsoft SQl server

Oracle has a CLOB type and the function EMPTY_CLOB().

I'm looking for an alternative for use in SQL server.

Thanks in advance.

Upvotes: 3

Views: 1738

Answers (1)

Pondlife
Pondlife

Reputation: 16240

A lot of older documentation and articles say that CLOB is equivalent to TEXT in MSSQL, but TEXT is now deprecated in favour of NVARCHAR(MAX). That assumes you have MSSQL 2005 or 2008, of course: 2000 only had TEXT.

As for EMPTY_CLOB(), I have no idea what it does but check out "Using Large-Value Data Types" in the MSSQL documentation for details of functions that you can use with NVARCHAR(MAX):

http://msdn.microsoft.com/en-us/library/ms178158.aspx

Upvotes: 5

Related Questions