Skip to content

Instantly share code, notes, and snippets.

@akehir
Created June 25, 2020 21:04
Show Gist options
  • Save akehir/4767641353aa3e783860851d5bc23295 to your computer and use it in GitHub Desktop.
Save akehir/4767641353aa3e783860851d5bc23295 to your computer and use it in GitHub Desktop.
/* prod */
TRUNCATE TABLE [SIX_SOC_Calculator].[dbo].[Options];
DELETE FROM [SIX_SOC_Calculator].[dbo].[Settings]
DBCC CHECKIDENT ('SIX_SOC_Calculator.dbo.Products',RESEED, 0);
DELETE FROM [SIX_SOC_Calculator].[dbo].[Products]
DBCC CHECKIDENT ('SIX_SOC_Calculator.dbo.Settings',RESEED, 0);
/* dev */
TRUNCATE TABLE SIX_SOC_Calculator_DEV.[dbo].[Options];
DELETE FROM SIX_SOC_Calculator_DEV.[dbo].[Settings]
DBCC CHECKIDENT ('SIX_SOC_Calculator_DEV.dbo.Products',RESEED, 0);
DELETE FROM SIX_SOC_Calculator_DEV.[dbo].[Products]
DBCC CHECKIDENT ('SIX_SOC_Calculator_DEV.dbo.Settings',RESEED, 0);
@akehir
Copy link
Author

akehir commented Sep 13, 2020

UPDATE [SIX_SOC_Calculator_DEV].[dbo].[Settings]
SET [Name] = 'Number of SIX Playbooks'
WHERE [Id] = 32;


UPDATE [SIX_SOC_Calculator_DEV].[dbo].[Settings]
SET [Name] = 'Number of Customer Playbooks'
WHERE [Id] = 33;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment