Visual Studio 2013 SSDT - Data Editing - IS NULL Does Not Work As a Filter

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:

enter image description here

enter image description here

+4
3

, , IS (NOT) NULL .

+7

, .

, =, - . , , , .

, , . 0.

Create MyTable 
(  Id    int primary key,
     ...
   MyNum  int
);

MyNum, :

[Id] - [Id] = IsNull([MyNum],0)

[Id] - [Id] 0 [MyNum] = stuff

, NULL 0.

, - ,

concatenate([OtherStringCol],'XYZZY') = ISNull([MyStrCol],concatenate([OtherStringCol],'XYZZY'))

"XYZZY" , , [MyStrCol] = [OtherStringCol]. , "XYZZY" .

+1

, SQL- "IS NULL" .

1-
2- " "
3- SQL IS NULL

.

-1

All Articles