![Configuration setting to deal with Optional Parameters while creating SQL Service Instance – Uncode K2 Configuration setting to deal with Optional Parameters while creating SQL Service Instance – Uncode K2](https://vijaydk2guy.files.wordpress.com/2017/12/3.jpg?w=840)
Configuration setting to deal with Optional Parameters while creating SQL Service Instance – Uncode K2
![SQL SERVER - The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. - SQL Authority with Pinal Dave SQL SERVER - The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/nulltozero.jpg)
SQL SERVER - The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. - SQL Authority with Pinal Dave
![Sql server, .net and c# video tutorial: Part 68 - Optional parameters in sql server stored procedures Sql server, .net and c# video tutorial: Part 68 - Optional parameters in sql server stored procedures](http://1.bp.blogspot.com/-iWyitZg65BY/UiowIh2dRLI/AAAAAAAAEsA/d8FyBLgYdQI/s1600/sql+server+stored+procedure+optional+parameters.png)