Original link: https://www.mssqltips.com/sqlservertip/2097/how-to-shrink-the-transaction-log-file-in-sql-server Desctiption: Shrink the transaction log file in SQL Server ...
TRUNCATE TABLE employee; --its delete all the data of table but can't reset series if any TRUNCATE TABLE employee RESTART IDENTITY; --for restart the series of employee id after delete data ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results