Updating blob fields in mssql
I develop software that stores a lot of data in one of its database tables (SQL Server version 8, 9 or 10).
So the use case will be as below – Note: This implementation will work only from SQL Server 2008 and later versions (as MERGE statement introduced from SQL Server 2008). With SQL Server we have the following options based on the size required. The Oracle equivalent of these datatypes would be the NUMBER datatype specifying a precision based on the size required and a scale of 0.