Is it possible to determine the type of a local variable at runtime in TSQL?
For example, say I wanted to do something along these lines:
IF ( @value IS INTEGER )
Or
IF ( TYPEOF(@value) = <whatever> )
Does anyone know of any way to accomplish this?
EDIT: This is not for a specific task, this is more of a general knowledge question. I do appreciate answers that indicate that the type should be known since it is declared within the same batch, I am curious as to whether the type can be determined at runtime.
run this
declare @d int
select @d = 500
if cast(sql_variant_property(@d,'BaseType') as varchar(20)) = 'int'
print 'yes'
else
print 'no'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With