sql query if parameter is null select all

by

Try this:

SELECT * 
FROM MY_TABLE 
WHERE @parameter IS NULL OR NAME = @parameter;

More Related Contents:

  1. SQL JOIN – WHERE clause vs. ON clause
  2. SQL – HAVING vs. WHERE
  3. Conditional WHERE clause in SQL Server
  4. Left Join With Where Clause
  5. Passing multiple values for a single parameter in Reporting Services
  6. Parameterize an SQL IN clause
  7. What is the difference between HAVING and WHERE in SQL?
  8. including parameters in OPENQUERY
  9. Filter Table Before Applying Left Join
  10. Does the order of where clauses matter in SQL?
  11. How to set table name in dynamic SQL query?
  12. Pass table as parameter into sql server UDF
  13. How to use parameters “@” in an SQL command in VB
  14. SQL server ignore case in a where expression
  15. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  16. Is a JOIN faster than a WHERE?
  17. What’s the difference between “where” clause and “on” clause when table left join?
  18. Can we pass parameters to a view in SQL?
  19. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  20. “Order By” using a parameter for the column name
  21. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  22. Check if a parameter is null or empty in a stored procedure
  23. Oracle date “Between” Query
  24. Parameterise table name in .NET/SQL?
  25. Call stored procedure with table-valued parameter from java
  26. Convert from string to datatime in sql [duplicate]
  27. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  28. GROUP BY and aggregate sequential numeric values
  29. How to pass variable as a parameter in Execute SQL Task SSIS?
  30. Query a Table’s Foreign Key relationships

Leave a Comment