How can I send null value to clr function?

Question

When I'm trying to create a clr fucntion with nullable paramete (any kind), the function does not created in the DB.

Does anyone know how can I do it?

thanks.

Answer 1

You need to create your CLR function using SqlType parameters instead of regular parameter types, See http://msdn.microsoft.com/en-us/library/system.data.sqltypes.aspx for a reference for the SqlType parameters that you can use.

Answer 2

DB: SQL Server 2008 I'm using .NET vs2008 clr functions

nevermind the code I was trying to send null to a date parameter, when I used the SqlDateTime type I could do it, it allows sending null (SqlDateTime.Null).

thanks a lot.