I have some procedure return null string.
EXEC sp_Name @name OUT
EXEC sp_list @list OUT
select @message = 'The following students name are: ' + @name + CHAR(13) +
'The following list are : ' + @list
if EXEC sp_Name and sp_list both return the value, the message has content, but if EXEC sp_list @list OUT return null, the whole message is empty.
EXEC sp_Name @name OUT still has value. How to show message which sp_Name has value but sp_list return null
Thank you very much!