I am trying to filter out some row of a table using ssdt (left click on the table, view data, sort and filter)
Here I just need to add IS NULLas a condition in the field nvarchar.
But as soon as I apply the filter, I get an error message:
Incorrect syntax next to the SET keyword
Looking at the request written by the editor, I see that in the request fldName =, there are no signs of verificationNULL
How can i do this?
This is the result:
SELECT TOP 1000 [Ktyi_TS002_IdTipoDocumento] ,
[nvc_TS002_TipoDocumento] ,[nvc_TS002_IdFunzioneControllo] ,[bit_TS002_Annullato]
FROM [dbo].[TS002_TipoDocumento]
WHERE [nvc_TS002_IdFunzioneControllo] =
These are some images of the data editor found on google to show what I'm talking about who does not know ssdt:

