Tag Archives: Condition in WHERE Clause

SQL Condition in WHERE Clause

How would you set a condition in where clause in SQL Server? For example you have a parameter @ProjectID. If @ProjectID is 1, then select all employee with EmployeeNo 1000. If @ProjectID=2 then select all employee with employeeNo betweeen 1000 … Continue reading

Posted in SQL Server 2008 | Tagged , | Leave a comment