Thursday, December 29, 2011

SQL : Condition for all or fixed values

Select Emp_Code, Emp_Name, Emp_Address, Emp_Telephone, Emp_Postcode
From Employees A
Where (A.Emp_Code = @Emp_Code or isnull(@Emp_Code,'')='')

No comments:

Post a Comment