Set-Location -Path "cert:\LocalMachine\My"
$OldCert = (Get-ChildItem -Path 56f4cc4ac43dbf0aa1bbc8d8fb4317ab22128c5d)
New-SelfSignedCertificate -CloneCert $OldCert -NotAfter (Get-Date).AddMonths(999)

Truncate TableName;//无日志清表

    MenuFunction menuFunction;
    menuFunction = new MenuFunction(menuItemDisplayStr(xxx), MenuItemType::Display);

    Args args = new Args();
    args.record(_task);
    args.caller(_caller);
    menuFunction.run(args);

cd "C:\Temp\sqlpackage-win7-x64-en-US-15.0.5084.2"
SqlPackage.exe /a:import /sf:C:\Temp\test.bacpac /tsn:. /tdn:AxDB_202308188 /TargetTrustServerCertificate:True /p:CommandTimeout=7200

//kill all conections.

-- Create the sql to kill the active database connections 

declare @execSql varchar(1000), @databaseName varchar(100)
-- Set the database name for which to kill the connections
set @databaseName = 'AxDB'
set @execSql = ''

select @execSql = @execSql + 'kill ' + convert(char(10), spid) + ' '
from master.dbo.sysprocesses where db_name(dbid) = @databaseName
and DBID <> 0
and spid <> @@spid exec(@execSql)
GO

-- modified DB name.

ALTER DATABASE AxDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE --单用户模式
ALTER DATABASE AxDB MODIFY NAME = AxDB_Dev240228
ALTER DATABASE AxDB_DEL SET MULTI_USER --多用户模式

导入Bak文件
RESTORE DATABASE [DbTest]
FROM

disk = N'C:\File\bak.bak'

WITH

FILE =1,
REPLACE,
RECOVERY,
STATS=5;

Num2Str

    num2str
    (
    moneyReal,
    -1, // Minimum number of characters to output into the string. -1 means infinite number of characters

    -1, // Required number of digits to the right of the decimal. -1 means infinite number of digitis

    DecimalSeparator::Dot,    // 1
    ThousandSeparator::Comma  // 2
    );