SQL Authors
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment