Is there anytype type for SQL Server

Question

Like a parameter in an ISNULL function?

Something we can use to determine:

create function getvalue ( @param1 varchar(max), @param2 varchar(max), @value anytype ) return anytype as ... 

Answer 1

It looks like you are looking for the sql_variant data type .

Answer 2

Short answer no. sql_variant will let you get closer, but not quite.

If sql_variant is not enough, you can overcome this by specifying a few null parameters of all the corresponding types, but that is not very.