Article ID: 820543 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
When you use BizTalk Adapter for SQL Server, you might want to store a null value in the database that you are writing data to.
When you do an insert or an update, you can pass a value of IsNull as the value for a column. The IsNull value instructs BizTalk Adapter for SQL Server to store a null value in the column for that row. However, if you are running a stored procedure to pass the data, you cannot use a value of IsNull. Instead, you must change your stored procedure to assume a default value of null.
To insert null values in a column, change the stored procedure that you are running so that it assumes a null value for each column that allows null values.
When you call this stored procedure from BizTalk Adapter for SQL Server, and you do not pass a value for a column, the stored procedure inserts a null value in that column in the database.
The following is a sample stored procedure that updates products in the Northwind Products database: