by
3,709 13

Null parameters in Stored Procedure

Do not use coalesce methodology, causes table scan
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/3006251/Null-parameters-in-Stored-Procedure?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
// Dont do this: LastName = COALESCE (@LastName, LastName) WHERE (LastName = @LastName OR @LastName IS NULL)
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus