我需要检查变量是否具有值。
declare @name varchar(20) set @name = (SELECT Product_Name FROM tb_new_product_Name_id WHERE Product_Name = @productName) if (@name ) // here I need to check it
怎么做?谢谢
试试这个
if (@name is null or @value = '') //it will indicate whether it contains a value or not