Tuesday, June 2, 2009

Can we pass null as a parameter value in SQL Stored Procedure with .Net?

Simply passing null as a parameter value to Stored Procedure will be considered as parameter not passed & will throw exception as parameter not found.For passing null value as a parameter of Stored Procedure System.DBNull.Value should be used.

For more information refer:
http://msdn.microsoft.com/en-us/library/system.dbnull(vs.71).aspx

No comments: