DECLARE @TestCode varchar(10) = 'SP0000'; -- Replace 'SP0000' with desired Test_Code

-- Insert into tbl_lab_setup_Test
INSERT INTO tbl_lab_setup_Test (
    Test_Code,
    Test_Group_Code,
    Test_Seq,
    Test_Name,
    Test_Display_Name,
    Test_Display_Name_Hide_Print_Flag,
    Test_Type_Code,
    Test_Order_Status_Flag,
    Test_Data_Type_Code,
    Specimen_Type_Code,
    Test_His_Code,
    Test_Checkup_Code,
    Test_Send_Out_Flag,
    Test_Preliminary_Enable_Flag,
    Test_Inactive,
    Test_Method_Code,
    Test_Profile_Option_Flag,
    Test_Checkup_Flag,
    Test_Profile_Option_Share_Code_Flag
)
VALUES (
    @TestCode,
    'OL',
    '',
    N'SPECIAL TEST',
    N'SPECIAL TE',
    '0',
    '0',
    '1',
    '02',
    '29',
    'XXX',
    '',
    '0',
    '0',
    '0',
    '',
    '0',
    '0',
    '0'
);

-- Insert into tbl_lab_setup_log_Test
INSERT INTO tbl_lab_setup_log_Test (
    Test_Code,
    Test_Group_Code,
    Test_Seq,
    Test_Name,
    Test_Display_Name,
    Test_Display_Name_Hide_Print_Flag,
    Test_Type_Code,
    Test_Order_Status_Flag,
    Test_Data_Type_Code,
    Specimen_Type_Code,
    Test_His_Code,
    Test_Checkup_Code,
    Test_Send_Out_Flag,
    Test_Preliminary_Enable_Flag,
    Test_Inactive,
    Test_Method_Code,
    Test_Profile_Option_Flag,
    Test_Checkup_Flag,
    Test_Profile_Option_Share_Code_Flag,
    Test_Trx_By
)
VALUES (
    @TestCode,
    'OL',
    '',
    N'SPECIAL TEST',
    N'SPECIAL TE',
    '0',
    '0',
    '1',
    '02',
    '29',
    'XXX',
    '',
    '0',
    '0',
    '0',
    '',
    '0',
    '0',
    '0',
    'admin'
);

-- Insert into tbl_lab_setup_Test_Control
INSERT INTO tbl_lab_setup_Test_Control (
    Test_Code,
    Test_Auto_Test_Comment,
    Test_Auto_Result_Text,
    Test_Send_HIS_Text,
    Test_Default_Value_Text,
    Test_TAT_R_Days,
    Test_TAT_R_Hours,
    Test_TAT_R_Minutes,
    Test_TAT_S_Days,
    Test_TAT_S_Hours,
    Test_TAT_S_Minutes,
    Comment_Type_Code,
    Test_Share_Code_Flag,
    Test_Default_Value_Flag,
    Test_Comment_Type_Flag,
    Test_Send_HIS_Flag,
    Test_Limit_Result_Access_Flag,
    Test_Blind_Result_Display_Flag,
    Test_Auto_Result_Flag,
    Test_Scan_File_Flag,
    Test_Text_Keyin_Flag,
    Test_Text_Column_Print_Flag,
    Test_Critical_Flag,
    Test_Blank_Result_Flag,
    Test_Sp_Barcode_Flag,
    Test_Routine_Flag,
    Test_Ref_Text_Flag,
    Test_Ref_Text_Value,
    Test_Countable,
    Test_Package_Flag,
    Test_Package_Price,
    Test_Blind_Result_Display_Authen_Flag,
    Test_Pending_Time_Flag,
    Test_Pending_Time_Day,
    Test_Pending_Time_Hours,
    Test_Pending_Time_Miniutes,
    Test_Report_Flag,
    Test_Report,
    Test_Block_Result,
    Test_Block_Result_Flag,
    Test_Barcode_Copy_Flag,
    Test_Barcode_Copy,
    Test_Cost,
    Test_OutLab_Flag,
    Test_OutLab_Code,
    Test_Result_Equal_Pre1_Flag,
    Test_Click_Formula_Flag,
    Test_Blood_Group_Color,
    Test_OutLab_Specimen_Code,
    Test_Report_Show_Dialog_Print_On_App
)
VALUES (
    @TestCode,
    N'',
    N'',
    N'',
    N'รอผล 5-7 วันทำการ',
    '0',
    '00',
    '00',
    '0',
    '00',
    '00',
    '000',
    '0',
    '1',
    '0',
    '0',
    '0',
    '0',
    '0',
    '1',
    '0',
    '0',
    '1',
    '0',
    '0',
    '1',
    '0',
    N'',
    '1',
    '0',
    '0.00',
    '0',
    '0',
    '0',
    '00',
    '00',
    '0',
    N'',
    N'',
    '0',
    '0',
    '',
    '0.00',
    '0',
    '000000',
    '0',
    '0',
    '0',
    ''
);

-- Insert into tbl_lab_setup_Test_Result_Short_Text
INSERT INTO tbl_lab_setup_Test_Result_Short_Text (
    Test_Code,
    Short_Text_Result_Code,
    Test_Abnormal_Flag,
    Test_Alert_Flag,
    Not_Show_Flag,
    Short_Text_Seq
)
VALUES (
    @TestCode,
    '212',
    '0',
    '0',
    '0',
    '001'
);