DECLARE @Numero Int SET @Numero=something DELETE FROM Hit WHERE Numero<@NumeroThis is the other code involved in the deadlock:
DECLARE @AddUser Int DECLARE @AddDate DateTime DECLARE @ProcessID Int DECLARE @Page NVarChar DECLARE @Lap Int DECLARE @IP NVarChar DECLARE @QueryStrin NVarChar DECLARE @NoServer Int DECLARE @InputStream NVarChar DECLARE @OutputStream NVarChar DECLARE @Log NVarChar DECLARE @SQLCountSQLExec Int DECLARE @SQLCountSQLUpdate Int DECLARE @SQLCountSQLInsert Int DECLARE @SQLCountSQLDelete Int DECLARE @Server NVarChar SET @AddUser=0 SET @AddDate='2013-12-29 15:20:03' SET @ProcessID=5776 SET @Page='default.aspx' SET @Lap=-1 SET @IP='something' SET @QueryStrin='' SET @NoServer=4 SET @InputStream='' SET @OutputStream='' SET @Log='' SET @SQLCountSQLExec=0 SET @SQLCountSQLUpdate=0 SET @SQLCountSQLInsert=0 SET @SQLCountSQLDelete=0 SET @Server='something' INSERT INTO Hit (AddUser,AddDate,ProcessID,Page,Lap,IP,QueryStrin,NoServer,InputStream,OutputStream,Log,SQLCountSQLExec,SQLCountSQLUpdate,SQLCountSQLInsert,SQLCountSQLDelete,Server) VALUES (@AddUser,@AddDate,@ProcessID,@Page,@Lap,@IP,@QueryStrin,@NoServer,@InputStream,@OutputStream,@Log,@SQLCountSQLExec,@SQLCountSQLUpdate,@SQLCountSQLInsert,@SQLCountSQLDelete,@Server)