Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
674 B
5
Indexable
Never
//Nisbah
DELETE FROM mns_parameterSetting;
DBCC CHECKIDENT ('bsi.mrms.mns_parameterSetting', RESEED, 0)
DELETE FROM mns_report;
DBCC CHECKIDENT ('bsi.mrms.mns_report', RESEED, 0)
DELETE FROM mns_parameterFilter;
DBCC CHECKIDENT ('bsi.mrms.mns_parameterFilter', RESEED, 0)
DELETE FROM mns_parameterFilterMaster;
DBCC CHECKIDENT ('bsi.mrms.mns_parameterFilterMaster', RESEED, 0)

//Stress
DELETE FROM stress_MarketRisk;
DBCC CHECKIDENT ('bsi.mrms.stress_MarketRisk', RESEED, 0)
DELETE FROM stress_liquidityRisk;
DBCC CHECKIDENT ('bsi.mrms.stress_liquidityRisk', RESEED, 0)
DELETE FROM stress_parameter_setting;
DBCC CHECKIDENT ('bsi.mrms.stress_parameter_setting', RESEED, 0)
Leave a Comment