3,725 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;"
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