How to insert or Update NULL value using sqlsrv_query

Question

If you use soemthing like $stmt = sqlsrv_query( $connecttest, $SQL, $params);

How do you update or insert NULL into an image field or varchar field when using parameters?

Thanks

Answer 1

I believe, you are using PHP.

can you try passing null to the positional parameters in the php function.

$params = array (null , 1 ,......);

Answer 2

Hi PamelaWhittaker-2747,

Please try to specify NULL to parameter as others mentioned.
And here is a similar thread which might be helpful.

Best Regards,
Amelia