T-sql null parameters

Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. This is the place for advice and discussions 18 7. Sign in to vote. In SQL can we pass optional parameter to the function. Tuesday, April 21, AM. Well, it depends. And then you can call the function with select dbo. Monday, July 13, AM. Question remains though, is there a specific order in which to prioritize the criteria in the WHERE clause? I am not sure what you mean in your 2nd post by "specific order in which to prioritize the criteria".

The query you posted does all 3 of your tests successfully. All 3 parameters are optional. How to show first row group by part id and compliance type based on priorities of Document type? Query to list all the databases that have a specific user. T-sql query to find the biggest table in a database with a clustered index. Skip to main content. Find threads, tags, and users Hey What am i doing wrong here?

Current Visibility: Visible to all users. Re signing: msdn. Note: I've never had to sign something in real life Show 1 more comment. I would handle it this way. Brendan Enrick Brendan Enrick 4, 2 2 gold badges 25 25 silver badges 40 40 bronze badges. I've found, like the OP, that with more than a couple of these it quickly kills the performance, as it can't easily identify the most useful index etc. Do not use this example. If you pass in null for " Thing" and want to pull all values including null , this will NOT work.

MikeTeeVee Yes, you're correct. If that is your circumstance, then yes you should use a different approach. If you don't allow nulls on the column then this approach is fine. Tim Lentine Tim Lentine 7, 5 5 gold badges 32 32 silver badges 39 39 bronze badges.

Sean Bright Sean Bright k 17 17 gold badges silver badges bronze badges. I've never noticed an measurable difference and I'll always take readability over a few extra millis unless there are SLA requirements to the contrary. Regards, Tim. Tim Tim 1 1 gold badge 1 1 silver badge 9 9 bronze badges. Karmic Coder Karmic Coder 17k 5 5 gold badges 31 31 silver badges 41 41 bronze badges. Like you I wrongly assumed "statement should short-circuit to true if thing is null, and would therefore not require a table scan.

Josh Mein Josh Mein 27k 12 12 gold badges 73 73 silver badges 84 84 bronze badges. If the Thing column value is also Nullable, then use the foll. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.