Update an nvarchar(max) column to null [closed]

Update an nvarchar(max) column to null [closed]

References

Reference NO 1

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f46b7e6a-686b-4077-86f8-9de87602fa54/action?threadDisplayName=cannot-insert-null-value-in-nvarcharmax-field-in-linked-sql-server-table-using-sql-server-native

Reference NO 2

http://stackoverflow.com/questions/979269/inserting-null-in-an-nvarchar-fails-in-msaccess

Reference NO 3

http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx

Reference NO 4

http://dba.stackexchange.com/questions/47797/convert-all-ntext-columns-to-nvarcharmax

Reference NO 5

https://drupal.org/node/1958592

Reference NO 6

http://www.g-productions.nl/index.php?name=sp_cdc_create_change_enumeration_wrapper_function

Reference NO 7

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=157162

Reference NO 8

http://decipherinfosys.wordpress.com/2007/07/24/update-textntext-or-varcharmax-data-type-columns-in-sql-server/