is there any way to use an if statement in a SQL Server.
I have written a code in an asp. I want to check the code
in SQL.

    strUpdate = "update tblCustRate set dtRateFrom =" & ndateFrom & _
                ", dtRateTo =" & ndateUntil& _
                ", decHourlyRate=" & nHourlyRate
                '" where iEmpID=" &iEmpID&_
                '" and iTaskID= " & iTaskID &_
                '" and iProjDetID=" & iProjDetID
        if resType ="E" then
         strUpdate= strUpdate & " where iEmpID= " & iEmpID &_
                  " and iTaskID= " & iTaskID &_
                  " and iProjDetID=" & iProjDetID
         else
          strUpdate=strUpdate & " where iSubcontID = " & iSubcontID &_
                  " and iTaskID= " & iTaskID &_
                  " and iProjDetID= " & iProjDetID
         end if

You can create a Stored Procedure in SQL Server.

IF <Boolen Expression>
BEGIN
   Your SQL Statements
END
ELSE
BEGIN
   Your SQL Statements
END

will any one write the stored procedure. Since I am the new to the sql. I dont know how? Thanks