[houssam11350]

لنفرض أن الجدول لديك اسمه employees

كود :

SELECT FirstName , TheDate  INTO tem_emp FROM  employees;
delete from employees
DBCC CHECKIDENT('employees', RESEED, 0) --reset identity column
insert into employees (FirstName , TheDate) SELECT FirstName , TheDate   FROM tem_emp;
drop table tem_emp;