How to check if parameter is empty in SQL function?

Question

I have in my function this TVP parameter:

@SiteTypeId [dbo].[intArray]

How can I check if this parameter is empty?

Pரதீப் · Accepted Answer · 2016-10-30 01:39:40Z

1

How can I check if this parameter is empty? Here considering empty as zero records in table since it is a table valued parameter

You can check it using IF NOT EXISTS

IF NOT EXISTS (Select 1 from @SiteTypeId)
Begin
--statements
End

answered Oct 30, 2016 at 1:33

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1