I am attempting to translate Oracle SQL to SQL Server SQL. In the Oracle script there is a standard Oracle reference to a deleted vale in a trigger. The column is referenced ":old.Query_id". it is used in a WHERE statement this way " WHERE Query_Table_Column_Hits.Quert_ID = :old.Query_Id" I get a syntax error at the ":" so I am assuming that the ":old" is not a good reference to the deleted value. What would be a good reference?