|
Subject:
|
How do you set a column to NULL in a parameter?
|
|
Posted By:
|
Aaron Edwards
|
Post Date:
|
4/7/2006 5:42:25 PM
|
I need to be able to set an int column in SQL2005 to null once in a while, within a parameter construct, i.e.
cmd.Parameters.Add(New SqlParameter("@fkSecondLevelPageID", 'null'))
I've tried 'null', vbNull and "", but none of them do the job.
Thanks!
Aaron
|
|
Reply By:
|
jbenson001
|
Reply Date:
|
4/7/2006 11:26:52 PM
|
try using:
System.Convert.DBNull
|
|
