DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

able_name = 'MW_OUT_DT', -- varchar(776)
@from = 'FROM MW_OUT_DT WHERE OUT_ID IN (SELECT OUT_ID FROM MW_OUT WHERE YEAR>=2021)' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'MW_OUT_DT', -- varchar(776)
@from = 'FROM MW_OUT_DT WHERE OUT_ID IN (SELECT OUT_ID FROM MW_OUT WHERE YEAR>=2021)' -- varchar(800)

DELETE FROM PL_MASTER
DELETE FROM PL_TRADEDETAIL
DELETE FROM PL_IMPORT
DELETE FROM PL_IMPORT_DT
DELETE FROM PL_IMPORT_LOG

EXEC dbo.sp_generate_inserts @table_name = 'AbpLanguageTexts', -- varchar(776)
@from = 'FROM AbpLanguageTexts' -- varchar(800)

UPDATE TL_USER SET EMAIL ='nhannvt@gsoft.com.vn'

SELECT * FROM AbpLanguageTexts

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000105')

UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000008' WHERE REQ_ID=@REQ_ID --- PR 2022124
UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000008' WHERE REQ_ID=@REQ_ID AND PROCESS_ID ='DMMS'
DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

SELECT * FROM dbo.SYS_PREFIX WHERE ID = 'ASS_CONFIRM_USE_DT' OR ID = 'ASS_CONFIRM_USE_MASTER'

https://uatamsgd3.vietcapitalbank.com.vn/