Avoiding IF ELSE due to variable been NULL

by 
  SELECT * 
  FROM Customers
  WHERE EXISTS (SELECT OrderID INTERSECT SELECT @OrderID)

Will do this efficiently.

See Undocumented Query Plans: Equality Comparisons for more about this.

More Related Contents:

  1. T-SQL: Export to new Excel file
  2. SQL MERGE statement to update data
  3. How to get the last record per group in SQL
  4. T-SQL substring – separating first and last name
  5. How to get week number of the month from the date in sql server 2008
  6. T-SQL strip all non-alpha and non-numeric characters
  7. Recursive Child/Parent queries in T/SQL
  8. I dont know sql syntax for my table [closed]
  9. CROSS JOIN vs INNER JOIN in SQL
  10. How to check if a column exists in a SQL Server table
  11. Multiple INSERT statements vs. single INSERT with multiple VALUES
  12. Generate Dates between date ranges
  13. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  14. How to print VARCHAR(MAX) using Print Statement?
  15. Common Table Expression, why semicolon?
  16. T-SQL split string based on delimiter
  17. INSERT INTO vs SELECT INTO
  18. SQL Recursive CTE: Finding objects linked by property
  19. Why is SQL Server 2008 Management Studio Intellisense not working?
  20. Reporting Services permissions on SQL Server R2 SSRS
  21. Convert decimal time to hours and minutes
  22. Do clustered indexes have to be unique?
  23. How do I prevent a database trigger from recursing?
  24. How to implement polymorphic associations in an existing database
  25. What is the default transaction isolation level for SQL Server with ADO.NET?
  26. How to combine results of two queries into a single dataset
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  29. COALESCE Function in TSQL
  30. Stored procedure hangs seemingly without explanation

Leave a Comment