Hello If i have a query like thi

[goransaler]

Hello

If i have a query like this

SELECT * FROM table1 WHERE exid = @exid


if i use this query and like to display all lines from table1
What value should @exid have to show all
or is this not possible

thankfull for answers

 

[swampBoogie]

You can use NULL and the following code

SELECT * FROM table1 WHERE exid = coalesce(@exid,exid)

which does not search for null though. If you want to handle all cases, you need to have two variables.

 

[goransaler]

thanks that worked fine