Friday, April 8, 2016

MS VS2015 - Cannot filter columns with null

In Visual Studio 2015 in the sql datatable filter menu, there is no option to filter columns where the value is null. When entering is null into the filter view, the 'is null' is removed.

Steps: Open Visual Studio > Connect via SQL Server Object Explorer > Right click on table > View Data > Click on filter button > select filter field on any column > type "is null" > press enter or click on another field.

No comments:

Post a Comment