GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--=============================================
-- Author:
-- Create date:
-- Description:
--=============================================
CREATE PROCEDURE ResetaID
@TABELA as sysname
AS
BEGIN
EXEC('DELETE FROM ' + @TABELA )
EXEC('DBCC CHECKIDENT(' + @TABELA + ', reseed, 0)')
END