I was going to truncate a table in sqlserver database but it seems to be went in deadlock. Apart from this if issue persist regularly then use delete command instead of truncate command.
List of Deadlock
SELECT
SESSION_ID
FROM SYS.DM_EXEC_REQUESTS
WHERE BLOCKING_SESSION_ID != 0
Kill the deadlock:
kill SESSION_ID
Generate a range of consecutive/Sequence numbers (1 to 100) using a MySQL query, see below. Replace 100 number as per your choice, so it will generate sequence of numbers 1 to number you will going to replace
select t0.rn+t1.rn+t2.rn+t3.rn as Sequence
from
(select 0 rn union select 1 rn union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 rn union select 10 rn union select 20 union select 30 union select 40 union select 50 union select 60 union select 70 union select 80 union select 90) t1,
(select 0 rn union select 100 rn union select 200 union select 300 union select 400 union select 500 union select 600 union select 700 union select 800 union select 900) t2,
(select 0 rn union select 1000 rn union select 2000 union select 3000 union select 4000 union select 5000 union select 6000 union select 7000 union select 8000 union select 9000) t3
where
t3.rn<=100
and t2.rn<=100
and t1.rn<=100
and t0.rn+t1.rn+t2.rn+t3.rn<=100
and t0.rn+t1.rn+t2.rn+t3.rn<>0
order by 1
