Query: Condense Sql based on parameter values

[smitpatel]

No description provided.

[AndriySvyryd]

@smitpatel Can you give an example? Is this like short-circuiting?

[smitpatel]

            AssertSql(
                @"@__p_0='ALFKI' (Size = 5)

SELECT TOP(2) [c].[CustomerID], [c].[Address], [c].[City], [c].[CompanyName], [c].[ContactName], [c].[ContactTitle], [c].[Country], [c].[Fax], [c].[Phone], [c].[PostalCode], [c].[Region]
FROM [Customers] AS [c]
WHERE ([c].[CustomerID] = @__p_0) AND @__p_0 IS NOT NULL");

Remove @__p_0 IS NOT NULL term of it is already not null.

[smitpatel]

@maumar - This is probably done.