79275459

Date: 2024-12-12 14:26:23
Score: 4.5
Natty:
Report link

I have the same issue when I have to set a variable from the result. So, to fix it I have to CAST the result to VARCHAR(300) and the result starts to work.

For example:

Original:

Select
   MyId
   MyName
From
   MyTable

Fix:

Select
   MyId
   CAST(MyName as AS NVARCHAR(300)) AS MyName
From
   MyTable
Reasons:
  • Blacklisted phrase (1): I have the same issue
  • Low length (0.5):
  • Has code block (-0.5):
  • Me too answer (2.5): I have the same issue
  • Low reputation (1):
Posted by: Aldo U.