QQs'Note

sqlcmd -S .\SqlExpress
NET START/PAUSE/CONTINUE/STOP/ MSSQLSERVER

create table [ent].[tabletemp](
	[Id] [uniqueidentifier] NOT NULL,
	[Name] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

create schema ent

ALTER SCHEMA ent TRANSFER OBJECT::dbo.table1;  

EXEC storedProcedure1 @param='01'

CREATE TABLE [dbo].[Group](
	[ID] [uniqueidentifier] NOT NULL,
	[CreateTime] [datetime2](7) NULL,
	[Name] [nvarchar](80) NULL,
	[Valid] [bit] NOT NULL,
	[UpdateTime] [datetime2](7) NULL,
	[Comment] [nvarchar](500) NULL,
    CONSTRAINT [AK_Group_Name] UNIQUE ([Name])
) ON [PRIMARY]

select * from table1 where name='abc' collate Chinese_PRC_CS_AI_WS 

SQL_Latin1_General_CP1_CS_AI
Latin1_General_CS_AI

SELECT SERVERPROPERTY(N'Collation')

SELECT * from ::fn_helpcollations()

STUFF ( character_expression , start , length , character_expression )

SELECT CAST(t1.num AS varchar) from t1;
SELECT CONVERT(varchar, t1.num) from t1;

ALTER TABLE dbo.Table1 DROP CONSTRAINT PK_Table1 // 移除原主键
ALTER TABLE dbo.Table1 DROP COLUMN SerialNumber // 移除列
ALTER TABLE dbo.Table1 ADD ID uniqueidentifier NOT NULL default newID()

select  * from t_dw CONNECT BY PRIOR id = parentID START WITH id='dw001'

-- 根节点 /
update t_dw set orgLvl=HierarchyID::GetRoot() where parentID is null
-- 子树   /1/,/2/
update t_dw set orgLvl=HierarchyID::Parse('/1/') where name='dw1'
update t_dw set orgLvl=HierarchyID::Parse('/2/') where name='dw2'
-- 叶    /1/3/
update t_dw set orgLvl=HierarchyID::Parse('/1/1/') where name='dw1-a'

insert t_dw (id,name,ParentID,orgLvl) 
values(newid(),'dw1-b','xxxxxxxxxxxxxxx',
HierarchyID::Parse('/1/').GetDescendant(CAST('/1/1/' AS hierarchyid), NULL))

SELECT CAST('/1/2/' AS hierarchyid).GetLevel() -- 结果：2

SELECT name, orgLvl.ToString()
FROM t_dw
WHERE orgLvl.IsDescendantOf(CAST('/1/' AS hierarchyid)) = 1

SELECT name, orgLvl.ToString()
FROM t_dw
WHERE orgLvl.GetAncestor(2) = HierarchyID::Parse('/1/')

DECLARE @CurrentNode hierarchyid , @OldParent hierarchyid, @NewParent hierarchyid 
select  @CurrentNode=orgLvl from t_dw where name='dw_x'; -- /1/1/
select  @OldParent=orgLvl from t_dw where name='dw_old'; -- /1/
select  @NewParent=orgLvl from t_dw where name='dw_new'; -- /3/
UPDATE t_dw  
SET OrgNode = @CurrentNode.GetReparentedValue(@OldParent, @NewParent)   
WHERE OrgNode = @CurrentNode ; -- /3/1/ 
GO  

select schema_name(t.schema_id) as [Schema], t.name as TableName,i.rows as [RowCount] 
from sys.tables as t, sysindexes as i 
where t.object_id = i.id and i.indid <=1

; with cte(rownum)as(
    select row_number () over(partition by [Col1], [Col2] order by Col3) from [table]
)
delete from cte where rownum > 1

select @@version

SELECT id, first_name, last_name, phone, birth_date, sex
 FROM persons 
 WHERE id = 10

res = db.execSql(sql);
name = res[0]["FIRST_NAME"];

p = Person.get(10);
name = p.first_name;

result = await _context.employees.Where(employee => employee.level == highlvl)
    .Include(employee => employee.department)
    .ThenInclude(department => department.bills).ToListAsync();

sudo apt-get install vsftpd

service vsftpd restart

yum install git gcc gcc-c++ make automake autoconf libtool pcre pcre-devel zlib zlib-devel openssl-devel wget vi -y

apt install git gcc g++ make automake autoconf libtool libpcre3 libpcre3-dev zlib1g zlib1g-dev  libssl-dev wget vi

Function LCIDtoTAG 
    ${case} "1036"
    Push "fr_FR"
    ${break}
    ${case} "1049"
    Push "ru_RU"
    ${break}
    ${case} "1041"
    Push "ja_JP"
    ${break}
    ${case} "2052"
    Push "zh_CN"
    ${break}
    ${default}
    Push "en_US"
    ${break}
    ${endswitch}
FunctionEnd
Section
    Call LCIDtoTAG
    Pop $0
SectionEnd

StrCmp $1 "" +1 +2
DetailPrint "parameter is empty"

DetailPrint "parameter is not empty"

!ifndef TARGETDIR
!ifdef NSIS_UNICODE
!define TARGETDIR "..\binU"
!else
!define TARGETDIR "..\bin"
!endif
!endif

!addplugindir "${TARGETDIR}"

npm install @ngx-translate/core @ngx-translate/http-loader --save

import {TranslateModule} from '@ngx-translate/core';

export function createTranslateLoader(http: HttpClient) {
  return new TranslateHttpLoader(http, './assets/i18n/', '.json');
}
@NgModule({
    imports: [
        BrowserModule,
        HttpClientModule,
        TranslateModule.forRoot({
            loader: {
            provide: TranslateLoader,
            useFactory: createTranslateLoader,
            deps: [HttpClient]
      },
      defaultLanguage: 'en'
        })
    ],
    bootstrap: [AppComponent]
})
export class AppModule { }

export class AppComponent {
    constructor(translate: TranslateService) {
        // this language will be used as a fallback when a translation isn't found in the current language
        translate.setDefaultLang('en');
         // the lang to use, if the lang isn't available, it will use the current loader to get them
        translate.use('en');
    }
}

<p>{{"sayHi" | translate}}</p>

<p>{{'sayHiWithParameter' | translate:userObj}}</p>

<p>{{ 'ROLES.' + role | uppercase | translate }}</p>

src
├───assets
│   ├───i18n
│   │       en.json
│   │       fr.json
│   │       zh.json

{
    "introductionHeader":"你好",
    "ROLE":{
        "ADMIN": "管理员"，
        "USER": "用户"
    },
    "sayHiWithParameter":"你好，{{pride}}的{{lastname}}}先生"
}

translate.get('HELLO', {value: 'world'}).subscribe((res: string) => {
    console.log(res);
    //=> 'hello world'
});

msgid ""
msgstr ""
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=1; plural=0;\n"
"X-Language: zh_CN\n"
"X-Qt-Contexts: true\n"

#: ../scanflow/res/qml/Dialog/AboutDialog.qml:25
msgctxt "AboutDialog|"
msgid "About"
msgstr "关于"

#: ../scanflow/res/qml/Dialog/AboutDialog.qml:52
msgctxt "AboutDialog|"
msgid "Product Version"
msgstr "产品版本"

<h1>{{ "AboutDialog|.About" |translate}}</h1>

msgctxt "ErrorMessage|"
msgid ""
"Application preferences have been damaged. Reinstall the application to "
"solve the problem."
msgstr ""
"Předvolby aplikace byly poškozeny. Problém vyřešíte opětovnou instalací "
"aplikace."
====>
{
    ...
    "ErrorMessage|":{
        msgctxt:"ErrorMessage|",
        msgid:"Application preferences have been damaged. Reinstall the application to solve the problem.",
        msgstr:["Předvolby aplikace byly poškozeny. Problém vyřešíte opětovnou instalací aplikace."]
    }
}

getValue(target, key) {
    /** @type {?} */
    let keys = typeof key === 'string' ? key.split('.') : [key];
    key = '';
    do {
        key += keys.shift();
        if (isDefined(target) && isDefined(target[key]) && (typeof target[key] === 'object' || !keys.length)) {
            target = target[key];
            key = '';
        }
        else if (!keys.length) {
            target = undefined;
        }
        else {
            key += '.';
        }
    } while (keys.length);
    return target;
}

public getTranslation(lang: string): Observable<any> {
    return this._http
        .get(`${this._prefix}/${lang}${this._suffix}`, { responseType: 'text' })
        .pipe(
            map((contents: string) => this.parse(contents)));
}

/**
* Parse po file
* @param contents
* @returns {any}
*/
public parse(contents: string): any {
    let translations: { [key: string]: object | string } = {};

    const po = gettext.po.parse(contents, 'utf-8');
    if (!po.translations.hasOwnProperty(this.domain)) {
        return translations;
    }

    Object.keys(po.translations)
        .forEach(domain => {
            if (domain.length === 0) { return; }
            if (po.translations[domain].msgstr) { // there is no msgctxt
                translations[domain] = po.translations[domain].msgstr;
            } else {
                // context
                translations[domain] = {};
                Object.keys(po.translations[domain]).forEach(key => {
                    let translation: string | Array<string> = po.translations[domain][key].msgstr.pop();
                    if (translation instanceof Array && translation.length > 0) {
                        translation = translation[0];
                    }
                    if (key.length > 0 && translation.length > 0) {
                        translations[domain][key] = translation;
                    }
                });
            }
        });
    return translations;
}

import { TranslatePoHttpLoader } from './edited-po-loader';
export function createTranslateLoader(http: HttpClient) {
	return new TranslatePoHttpLoader(http, 'assets/i18n', '.po');

import {MissingTranslationHandler, MissingTranslationHandlerParams} from '@ngx-translate/core';

export class MyMissingTranslationHandler implements MissingTranslationHandler {
    handle(params: MissingTranslationHandlerParams) {
        return 'some value';
    }
}
@NgModule({
    imports: [
        BrowserModule,
        TranslateModule.forRoot({
            missingTranslationHandler: {provide: MissingTranslationHandler, useClass: MyMissingTranslationHandler},
            useDefaultLang: false
        })
    ],
    providers: [

    ],
    bootstrap: [AppComponent]
})
export class AppModule { }

npx source-map-explorer dist/main.js --no-border-checks

SELECT * FROM LocalExport where 
SSO=IIF(@SSO is null, SSO, @SSO)
and SN=IIF(@SN is null, SN, @SN)

SELECT * from LocalExport where 
(ISNULL(@SSO, '')='' OR SSO=@SSO)
and (ISNULL(@SN, '')='' OR SN=@SN)

SET @SQL='select * from LocalExport where 1=1';
IF  @SSO is not null
BEGIN
    SET @SQL=@SQL+' AND SSO=@SSO'
END
IF  @SN is not null
BEGIN
    SET @SQL=@SQL+' AND SN=@SN'
END
EXEC sp_executesql  @SQL