-- Backup existing data if needed IF EXISTS (SELECT * FROM sys.tables WHERE name = 'Users') BEGIN SELECT * INTO Users_Backup FROM Users; END
-- Use SSDT's SQL Server Unit Test -- Right-click on stored procedure > Create Unit Tests ssdt for visual studio 2022
ALTER TABLE [dbo].[Users] ENABLE CHANGE_TRACKING; -- Backup existing data if needed IF EXISTS
Need help with a specific SSDT feature or deployment scenario? ssdt for visual studio 2022