Warning: Pulling without specifying how to reconcile divergent branches is
Git failed with a fatal error.
Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.

正在从 origin 提取
提取时遇到错误: Git failed with a fatal error.
Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.

未能从远程存储库提取。请参见输出窗口了解更多详细信息。
Warning: Pulling without specifying how to reconcile divergent branches is
Git failed with a fatal error.
Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.

Unable to negotiate with fe80::8436:e651:6655:2e81%11 port 22: no matching key e
xchange method found. Their offer: diffie-hellman-group1-sha1,diffie-hellman-gro
up14-sha1
fatal: Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.

git config --global user.name "yourname"
git config --global user.email "[email protected]"

ssh-keygen.exe -t rsa -C "[email protected]"

Host *
    KexAlgorithms +diffie-hellman-group1-sha1

Unable to negotiate with 192.168.1.75 port 22: no matching key exchange method found. Their offer: diffie-hellman-group1-sha1,diffie-hellman-group14-sha1
Git failed with a fatal error.
Git failed with a fatal error.
Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.

Host 192.168.1.75
	Port 22
	IdentityFile C:\Users\YuanRui\.ssh\id_rsa.pub
    HostKeyAlgorithms +ssh-rsa
    PubkeyAcceptedKeyTypes +ssh-rsa
    KexAlgorithms +diffie-hellman-group1-sha1,diffie-hellman-group14-sha1
	
Host *
	HostKeyAlgorithms +ssh-rsa
	PubkeyAcceptedKeyTypes +ssh-rsa
    KexAlgorithms +diffie-hellman-group1-sha1,diffie-hellman-group14-sha1

.git/hooks/pre-push: line 32: node: command not found

Option   Explicit 
ValidationMode   =   True 
InteractiveMode   =   im_Batch 

Dim   mdl   '   the   current   model 

'   get   the   current   active   model 
Set   mdl   =   ActiveModel 
If   (mdl   Is   Nothing)   Then 
      MsgBox   "There   is   no   current   Model " 
ElseIf   Not   mdl.IsKindOf(PdPDM.cls_Model)   Then 
      MsgBox   "The   current   model   is   not   an   Physical   Data   model. " 
Else 
      ProcessFolder   mdl 
End   If 

'   This   routine   copy   name   into   comment   for   each   table,   each   column   and   each   view 
'   of   the   current   folder 
Private   sub   ProcessFolder(folder)    
      Dim   Tab   'running     table    
      for   each   Tab   in   folder.tables    
            if   not   tab.isShortcut then
                     if  trim(tab.comment)="" then'如果有表的注释,则不改变它.如果没有表注释.则把name添加到注释里面.
                        tab.comment   =   tab.name
                     end if  
                  Dim   col   '   running   column    
                  for   each   col   in   tab.columns   
                        if trim(col.comment)="" then '如果col的comment为空,则填入name,如果已有注释,则不添加;这样可以避免已有注释丢失.
                           col.comment=   col.name   
                        end if 
                  next    
            end   if    
      next    
  
      Dim   view   'running   view    
      for   each   view   in   folder.Views    
            if   not   view.isShortcut and trim(view.comment)=""  then    
                  view.comment   =   view.name    
            end   if    
      next    
  
      '   go   into   the   sub-packages    
      Dim   f   '   running   folder    
      For   Each   f   In   folder.Packages    
            if   not   f.IsShortcut   then    
                  ProcessFolder   f    
            end   if    
      Next    
end   sub

Option   Explicit 
ValidationMode   =   True 
InteractiveMode   =   im_Batch

Dim   mdl   '   the   current   model

'   get   the   current   active   model 
Set   mdl   =   ActiveModel 
If   (mdl   Is   Nothing)   Then 
      MsgBox   "There   is   no   current   Model " 
ElseIf   Not   mdl.IsKindOf(PdPDM.cls_Model)   Then 
      MsgBox   "The   current   model   is   not   an   Physical   Data   model. " 
Else 
      ProcessFolder   mdl 
End   If

Private   sub   ProcessFolder(folder) 
On Error Resume Next
      Dim   Tab   'running     table 
      for   each   Tab   in   folder.tables 
            if   not   tab.isShortcut   then 
                  tab.name   =   tab.comment
                  Dim   col   '   running   column 
                  for   each   col   in   tab.columns 
                  if col.comment="" then
                  else
                        col.name=   col.comment 
                  end if
                  next 
            end   if 
      next

      Dim   view   'running   view 
      for   each   view   in   folder.Views 
            if   not   view.isShortcut   then 
                  view.name   =   view.comment 
            end   if 
      next

      '   go   into   the   sub-packages 
      Dim   f   '   running   folder 
      For   Each   f   In   folder.Packages 
            if   not   f.IsShortcut   then 
                  ProcessFolder   f 
            end   if 
      Next 
end   sub

create or replace procedure show_space
( p_segname in varchar2,
  p_owner   in varchar2 default user,
  p_type    in varchar2 default 'TABLE',
  p_partition in varchar2 default NULL )
-- this procedure uses authid current user so it can query DBA_*
-- views using privileges from a ROLE and so it can be installed
-- once per database, instead of once per user that wanted to use it
authid current_user
as
    l_free_blks                 number;
    l_total_blocks              number;
    l_total_bytes               number;
    l_unused_blocks             number;
    l_unused_bytes              number;
    l_LastUsedExtFileId         number;
    l_LastUsedExtBlockId        number;
    l_LAST_USED_BLOCK           number;
    l_segment_space_mgmt        varchar2(255);
    l_unformatted_blocks number;
    l_unformatted_bytes number;
    l_fs1_blocks number; l_fs1_bytes number;
    l_fs2_blocks number; l_fs2_bytes number;
    l_fs3_blocks number; l_fs3_bytes number;
    l_fs4_blocks number; l_fs4_bytes number;
    l_full_blocks number; l_full_bytes number;

    -- inline procedure to print out numbers nicely formatted
    -- with a simple label
    procedure p( p_label in varchar2, p_num in number )
    is
    begin
        dbms_output.put_line( rpad(p_label,40,'.') ||
                              to_char(p_num,'999,999,999,999') );
    end;
begin
   -- this query is executed dynamically in order to allow this procedure
   -- to be created by a user who has access to DBA_SEGMENTS/TABLESPACES
   -- via a role as is customary.
   -- NOTE: at runtime, the invoker MUST have access to these two
   -- views!
   -- this query determines if the object is a ASSM object or not
   begin
      execute immediate 
          'select ts.segment_space_management
             from dba_segments seg, dba_tablespaces ts
            where seg.segment_name      = :p_segname
              and (:p_partition is null or 
                  seg.partition_name = :p_partition)
              and seg.owner = :p_owner
              and seg.segment_type = :p_type
              and seg.tablespace_name = ts.tablespace_name'
             into l_segment_space_mgmt
            using p_segname, p_partition, p_partition, p_owner, p_type;
   exception
       when too_many_rows then
          dbms_output.put_line
          ( 'This must be a partitioned table, use p_partition => ');
          return;
   end;


   -- if the object is in an ASSM tablespace, we must use this API
   -- call to get space information, else we use the FREE_BLOCKS
   -- API for the user managed segments
   if l_segment_space_mgmt = 'AUTO'
   then
     dbms_space.space_usage 
     ( p_owner, p_segname, p_type, l_unformatted_blocks,
       l_unformatted_bytes, l_fs1_blocks, l_fs1_bytes,
       l_fs2_blocks, l_fs2_bytes, l_fs3_blocks, l_fs3_bytes,
       l_fs4_blocks, l_fs4_bytes, l_full_blocks, l_full_bytes, p_partition);

     p( 'Unformatted Blocks ', l_unformatted_blocks );
     p( 'FS1 Blocks (0-25)  ', l_fs1_blocks );
     p( 'FS2 Blocks (25-50) ', l_fs2_blocks );
     p( 'FS3 Blocks (50-75) ', l_fs3_blocks );
     p( 'FS4 Blocks (75-100)', l_fs4_blocks );
     p( 'Full Blocks        ', l_full_blocks );
  else
     dbms_space.free_blocks(
       segment_owner     => p_owner,
       segment_name      => p_segname,
       segment_type      => p_type,
       freelist_group_id => 0,
       free_blks         => l_free_blks);

     p( 'Free Blocks', l_free_blks );
  end if;

  -- and then the unused space API call to get the rest of the 
  -- information
  dbms_space.unused_space
  ( segment_owner     => p_owner,
    segment_name      => p_segname,
    segment_type      => p_type,
    partition_name    => p_partition,
    total_blocks      => l_total_blocks,
    total_bytes       => l_total_bytes,
    unused_blocks     => l_unused_blocks,
    unused_bytes      => l_unused_bytes,
    LAST_USED_EXTENT_FILE_ID => l_LastUsedExtFileId,
    LAST_USED_EXTENT_BLOCK_ID => l_LastUsedExtBlockId,
    LAST_USED_BLOCK => l_LAST_USED_BLOCK );

    p( 'Total Blocks', l_total_blocks );
    p( 'Total Bytes', l_total_bytes );
    p( 'Total MBytes', trunc(l_total_bytes/1024/1024) );
    p( 'Unused Blocks', l_unused_blocks );
    p( 'Unused Bytes', l_unused_bytes );
    p( 'Last Used Ext FileId', l_LastUsedExtFileId );
    p( 'Last Used Ext BlockId', l_LastUsedExtBlockId );
    p( 'Last Used Block', l_LAST_USED_BLOCK );
end;

SQL> set serveroutput on;
SQL> exec show_space('table_name');

set echo on

drop table run_stats;
create global temporary table run_stats 
( runid varchar2(15), 
  name varchar2(80), 
  value int )
on commit preserve rows;

grant select any table to ops$tkyte;
create or replace view stats
as select 'STAT...' || a.name name, b.value
      from v$statname a, v$mystat b
     where a.statistic# = b.statistic#
    union all
    select 'LATCH.' || name,  gets
      from v$latch
    union all
    select 'STAT...Elapsed Time', hsecs from v$timer;


delete from run_stats;
commit;

create or replace package runstats_pkg
as
    procedure rs_start;
    procedure rs_middle;
    procedure rs_stop( p_difference_threshold in number default 0 );
end;
/

create or replace package body runstats_pkg
as

g_start number;
g_run1  number;
g_run2  number;

procedure rs_start
is 
begin
    delete from run_stats;

    insert into run_stats 
    select 'before', stats.* from stats;

    g_start := dbms_utility.get_cpu_time;
end;

procedure rs_middle
is
begin
    g_run1 := (dbms_utility.get_cpu_time-g_start);

    insert into run_stats 
    select 'after 1', stats.* from stats;
    g_start := dbms_utility.get_cpu_time;

end;

procedure rs_stop(p_difference_threshold in number default 0)
is
begin
    g_run2 := (dbms_utility.get_cpu_time-g_start);

    dbms_output.put_line
    ( 'Run1 ran in ' || g_run1 || ' cpu hsecs' );
    dbms_output.put_line
    ( 'Run2 ran in ' || g_run2 || ' cpu hsecs' );
    if ( g_run2 <> 0 )
    then
    dbms_output.put_line
    ( 'run 1 ran in ' || round(g_run1/g_run2*100,2) || 
      '% of the time' );
    end if;
    dbms_output.put_line( chr(9) );

    insert into run_stats 
    select 'after 2', stats.* from stats;

    dbms_output.put_line
    ( rpad( 'Name', 30 ) || lpad( 'Run1', 12 ) || 
      lpad( 'Run2', 12 ) || lpad( 'Diff', 12 ) );

    for x in 
    ( select rpad( a.name, 30 ) || 
             to_char( b.value-a.value, '999,999,999' ) || 
             to_char( c.value-b.value, '999,999,999' ) || 
             to_char( ( (c.value-b.value)-(b.value-a.value)), '999,999,999' ) data
        from run_stats a, run_stats b, run_stats c
       where a.name = b.name
         and b.name = c.name
         and a.runid = 'before'
         and b.runid = 'after 1'
         and c.runid = 'after 2'
         -- and (c.value-a.value) > 0
         and abs( (c.value-b.value) - (b.value-a.value) ) 
               > p_difference_threshold
       order by abs( (c.value-b.value)-(b.value-a.value))
    ) loop
        dbms_output.put_line( x.data );
    end loop;

    dbms_output.put_line( chr(9) );
    dbms_output.put_line
    ( 'Run1 latches total versus runs -- difference and pct' );
    dbms_output.put_line
    ( lpad( 'Run1', 12 ) || lpad( 'Run2', 12 ) || 
      lpad( 'Diff', 12 ) || lpad( 'Pct', 10 ) );

    for x in 
    ( select to_char( run1, '999,999,999' ) ||
             to_char( run2, '999,999,999' ) ||
             to_char( diff, '999,999,999' ) ||
             to_char( round( run1/decode( run2, 0, to_number(0), run2) *100,2 ), '99,999.99' ) || '%' data
        from ( select sum(b.value-a.value) run1, sum(c.value-b.value) run2,
                      sum( (c.value-b.value)-(b.value-a.value)) diff
                 from run_stats a, run_stats b, run_stats c
                where a.name = b.name
                  and b.name = c.name
                  and a.runid = 'before'
                  and b.runid = 'after 1'
                  and c.runid = 'after 2'
                  and a.name like 'LATCH%'
                )
    ) loop
        dbms_output.put_line( x.data );
    end loop;
end;

end;
/

/*
exec runStats_pkg.rs_start;
exec runStats_pkg.rs_middle;
exec runStats_pkg.rs_stop;
*/

set echo off
set verify off
column diff format a18
select a.name, b.value Value, to_char(b.value-&V,'999,999,999,999') diff
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and lower(a.name) like '%' || lower('&S')||'%'
/
set echo on

http-cache: C:\Users\YuanRui\AppData\Local\NuGet\v3-cache
global-packages: C:\Users\YuanRui\.nuget\packages
temp: C:\Users\YuanRui\AppData\Local\Temp\NuGetScratch
plugins-cache: C:\Users\YuanRui\AppData\Local\NuGet\plugins-cache

%userprofile%\AppData\Local\Temp\NuGet\TempCache

%userprofile%\AppData\Roaming\Code\Cache\Cache_Data
%userprofile%\AppData\Roaming\Code\CachedData

%programdata%\Package Cache

 	TF400986: 备份路径 \\192.168.1.62\00-TFS_Backup 不存在。请确保该路径存在并且你对其具有访问权限
 
 	TF401009: TFS 服务帐户 NT AUTHORITY\LOCAL SERVICE 无法访问网络共享。   请更改为可访问备份路径的帐户。
 
 	TF400997: SQL Server 服务正在作为 NT AUTHORITY\LocalService 运行。请将此帐户更改为可被授予对备份路径的权限的帐户。

Error: 未能加载文件或程序集“System.Management.Automation, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad36
4e35”或它的某一个依赖项。强名称验证失败。 (异常来自 HRESULT:0x8013141A)

SELECT
  a.TABLESPACE_NAME,
  a.BYTES / 1024 / 1024 "Sum MB",
  (a.BYTES - b.BYTES) / 1024 / 1024 "Used MB",
  b.BYTES / 1024 / 1024 "free MB",
  ROUND(((a.BYTES - b.BYTES) / a.BYTES) * 100, 2) 
  AS "percent_used"
FROM  (SELECT
        TABLESPACE_NAME,
        SUM(BYTES) bytes
      FROM DBA_DATA_FILES
      GROUP BY TABLESPACE_NAME) a,
      (SELECT
        TABLESPACE_NAME,
        SUM(BYTES) bytes,
        MAX(BYTES) largest
      FROM DBA_FREE_SPACE
      GROUP BY TABLESPACE_NAME) b
WHERE a.TABLESPACE_NAME = b.TABLESPACE_NAME
ORDER BY ((a.BYTES - b.BYTES) / a.BYTES) DESC

select name, value from v$sysstat
where name in ('db block gets from cache', 'consistent gets from cache', 'physical reads cache');

SELECT
  PARSING_SCHEMA_NAME,
  EXECUTIONS,
  DISK_READS,
  BUFFER_GETS,
  ROUND((BUFFER_GETS - DISK_READS) / BUFFER_GETS, 2) Hit_radio,
  ROUND(DISK_READS / EXECUTIONS, 2) Reads_per_run,
  SQL_TEXT
FROM V$SQLAREA
WHERE EXECUTIONS > 0
AND BUFFER_GETS > 0
AND (BUFFER_GETS - DISK_READS) / BUFFER_GETS < 0.8
ORDER BY 4 DESC;

SELECT sql_id,child_number,sql_text, elapsed_time 
  FROM (SELECT sql_id, child_number, sql_text, elapsed_time, cpu_time,
               disk_reads,
               RANK () OVER (ORDER BY elapsed_time DESC) AS elapsed_rank
          FROM v$sql)
 WHERE elapsed_rank <= 10

SELECT   wait_class, event, total_waits AS waits,
         ROUND (time_waited_micro / 1000) AS total_ms,
         ROUND (time_waited_micro * 100 / SUM (time_waited_micro) OVER (),
                2
               ) AS pct_time,
         ROUND ((time_waited_micro / total_waits) / 1000, 2) AS avg_ms
    FROM v$system_event
   WHERE wait_class <> 'Idle'
ORDER BY time_waited_micro DESC;

WITH ash_query AS (
     SELECT substr(event,6,2) lock_type,program, 
            h.module, h.action,   object_name,
            SUM(time_waited)/1000 time_ms, COUNT( * ) waits, 
            username, sql_text,
            RANK() OVER (ORDER BY SUM(time_waited) DESC) AS time_rank,
            ROUND(SUM(time_waited) * 100 / SUM(SUM(time_waited)) 
                OVER (), 2)             pct_of_time
      FROM  v$active_session_history h 
      JOIN  dba_users u  USING (user_id)
      LEFT OUTER JOIN dba_objects o
           ON (o.object_id = h.current_obj#)
      LEFT OUTER JOIN v$sql s USING (sql_id)
     WHERE event LIKE 'enq: %'
     GROUP BY substr(event,6,2) ,program, h.module, h.action, 
         object_name,  sql_text, username)
SELECT lock_type,module, username,  object_name, time_ms,pct_of_time,
         sql_text
FROM ash_query
WHERE time_rank < 11
ORDER BY time_rank;

SELECT object_name, VALUE row_lock_waits, 
       ROUND(VALUE * 100 / SUM(VALUE) OVER (), 2) pct
  FROM v$segment_statistics
 WHERE statistic_name = 'row lock waits' AND VALUE > 0
 ORDER BY VALUE DESC;

 WITH sessions AS 
       (SELECT /*+ materialize*/ username,sid,sql_id
          FROM v$session),
     locks AS 
        (SELECT /*+ materialize */ *
           FROM v$lock)
SELECT l2.type,s1.username blocking_user, s1.sid blocking_sid, 
        s2.username blocked_user, s2.sid blocked_sid, sq.sql_text
  FROM locks l1
  JOIN locks l2 USING (id1, id2)
  JOIN sessions s1 ON (s1.sid = l1.sid)
  JOIN sessions s2 ON (s2.sid = l2.sid)
  LEFT OUTER JOIN  v$sql sq
       ON (sq.sql_id = s2.sql_id)
 WHERE l1.BLOCK = 1 AND l2.request > 0

WITH pga AS 
    (SELECT sid,
            ROUND(SUM(CASE name WHEN 'session pga memory' 
                       THEN VALUE / 1048576 END),2) pga_memory_mb,
            ROUND(SUM(CASE name WHEN 'session pga memory max' 
                      THEN VALUE / 1048576  END),2) max_pga_memory_mb
      FROM v$sesstat  
      JOIN v$statname  USING (statistic#)
     WHERE name IN ('session pga memory','session pga memory max' )
     GROUP BY sid)
SELECT sid, username,s.module, 
       pga_memory_mb, 
       max_pga_memory_mb, substr(sql_text,1,70) sql_text
  FROM v$session s
  JOIN (SELECT sid, pga_memory_mb, max_pga_memory_mb,
               RANK() OVER (ORDER BY pga_memory_mb DESC) pga_ranking
         FROM pga)
  USING (sid)
  LEFT OUTER JOIN v$sql sql 
    ON  (s.sql_id=sql.sql_id and s.sql_child_number=sql.child_number)
 WHERE pga_ranking <=5
 ORDER BY  pga_ranking

WITH db_cache_times AS 
    (SELECT current_size current_cache_mb, 
            size_for_estimate target_cache_mb,
            (estd_physical_read_time - current_time) 
               cache_secs_delta
       FROM v$db_cache_advice,
            (SELECT size_for_estimate current_size,
                    estd_physical_read_time current_time
               FROM v$db_cache_advice
              WHERE  size_factor = 1
                AND name = 'DEFAULT' AND block_size = 8192)
       WHERE name = 'DEFAULT' AND block_size = 8192),
 pga_times AS 
     (SELECT current_size / 1048576 current_pga_mb,
             pga_target_for_estimate / 1048576 target_pga_mb,
             estd_time-base_time pga_secs_delta 
        FROM v$pga_target_advice , 
             (SELECT pga_target_for_estimate current_size,
                     estd_time base_time
                FROM v$pga_target_advice 
               WHERE pga_target_factor = 1))
SELECT current_cache_mb||'MB->'||target_cache_mb||'MB' Buffer_cache,
       current_pga_mb||'->'||target_pga_mb||'MB' PGA,
       pga_secs_delta,cache_secs_delta,
       (pga_secs_delta+cache_secs_delta) total_secs_delta
  FROM db_cache_times d,pga_times p
 WHERE (target_pga_mb+target_cache_mb)
        <=(current_pga_mb+current_cache_mb)
   AND (pga_secs_delta+cache_secs_delta) <0
 ORDER BY (pga_secs_delta+cache_secs_delta);

--alter system set workarea_size_policy=manual; --将pga内存管理设置为手动管理
--alter system set workarea_size_policy=auto;   --将pga内存管理设置为自动管理
show parameter workarea_size_policy;

SELECT c.owner,
         c.constraint_name,
         c.table_name,
         cc.column_name,
         c.status
    FROM dba_constraints c, dba_cons_columns cc
   WHERE c.constraint_type = 'R'
         AND c.owner NOT IN
                ('SYS',
                 'SYSTEM',
                 'SYSMAN',
                 'EXFSYS',
                 'WMSYS',
                 'OLAPSYS',
                 'OUTLN',
                 'DBSNMP',
                 'ORDSYS',
                 'ORDPLUGINS',
                 'MDSYS',
                 'CTXSYS',
                 'AURORA$ORB$UNAUTHENTICATED',
                 'XDB',
                 'FLOWS_030000',
                 'FLOWS_FILES')
         AND c.owner = cc.owner
         AND c.constraint_name = cc.constraint_name
         AND NOT EXISTS
                    (SELECT 'x'
                       FROM dba_ind_columns ic
                      WHERE     cc.owner = ic.table_owner
                            AND cc.table_name = ic.table_name
                            AND cc.column_name = ic.column_name
                            AND cc.position = ic.column_position
                            AND NOT EXISTS
                                       (SELECT owner, index_name
                                          FROM dba_indexes i
                                         WHERE     i.table_owner = c.owner
                                               AND i.index_Name = ic.index_name
                                               AND i.owner = ic.index_owner
                                               AND (i.status = 'UNUSABLE'
                                                    OR i.partitioned = 'YES'
                                                       AND EXISTS
                                                              (SELECT 'x'
                                                                 FROM dba_ind_partitions ip
                                                                WHERE status =
                                                                         'UNUSABLE'
                                                                      AND ip.
                                                                           index_owner =
                                                                             i.
                                                                              owner
                                                                      AND ip.
                                                                           index_Name =
                                                                             i.
                                                                              index_name
                                                               UNION ALL
                                                               SELECT 'x'
                                                                 FROM dba_ind_subpartitions isp
                                                                WHERE status =
                                                                         'UNUSABLE'
                                                                      AND isp.
                                                                           index_owner =
                                                                             i.
                                                                              owner
                                                                      AND isp.
                                                                           index_Name =
                                                                             i.
                                                                              index_name))))
ORDER BY 1, 2

delete from TargetFrameworks
where PackageKey in (select Key from Packages where id = 'Your.Package.Name');

delete from PackageTypes
where PackageKey in (select Key from Packages where id = 'Your.Package.Name');

delete from PackageDependencies
where PackageKey in (select Key from Packages where id = 'Your.Package.Name');

delete from Packages
where id = 'Your.Package.Name';

public static Image GetImageFromPath(string path)
{
	var bytes = File.ReadAllBytes(path);
	var ms = new MemoryStream(bytes);
	var img = Image.FromStream(ms);
	return img;
}

字典的序列化/反序列化不支持类型“System.Collections.Generic.Dictionary`2[[System.Int64, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]”，键必须为字符串或对象。
说明: 执行当前 Web 请求期间，出现未经处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.ArgumentException: 字典的序列化/反序列化不支持类型“System.Collections.Generic.Dictionary`2[[System.Int64, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]”，键必须为字符串或对象。

堆栈跟踪:

[ArgumentException: 字典的序列化/反序列化不支持类型“System.Collections.Generic.Dictionary`2[[System.Int64, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]”，键必须为字符串或对象。]
   System.Web.Script.Serialization.JavaScriptSerializer.SerializeDictionary(IDictionary o, StringBuilder sb, Int32 depth, Hashtable objectsInUse, SerializationFormat serializationFormat) +619

--

SQL> SELECT USERNAME, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'ADMIN';

USERNAME
                                                 DEFAULT_TABLESPACE
--------------------------------------------------------------------------------
------------------------------------------------ ------------------------------
ADMIN
                                                 XXX_DB

git clone ssh://tfs-server75:22/tfs/XXXProject/_git/WorkCode

git branch -r | grep -v '\->' | sed "s,\x1B\[[0-9;]*[a-zA-Z],,g" | while read remote; do git branch --track "${remote#origin/}" "$remote"; done
git fetch --all
git pull --all

git branch

git branch -r

git checkout xxxx_branch

var targetBitmap = new Bitmap(500, 600);
using (var graphic = Graphics.FromImage(targetBitmap))
{
	graphic.CompositingMode = CompositingMode.SourceCopy;
	graphic.CompositingQuality = CompositingQuality.HighQuality;
	graphic.InterpolationMode = InterpolationMode.HighQualityBicubic;
	graphic.SmoothingMode = SmoothingMode.HighQuality;
	graphic.PixelOffsetMode = PixelOffsetMode.HighQuality;

	String drawString = "TEST STRING";
	Font drawFont = new Font("Arial", 16);
	SolidBrush drawBrush = new SolidBrush(Color.Yellow);
	RectangleF drawRect = new RectangleF(0, 300, 500, 200);
	Pen blackPen = new Pen(Color.Black);
	graphic.DrawRectangle(blackPen, 0, 500, 600, 200);
	StringFormat drawFormat = new StringFormat();
	drawFormat.Alignment = StringAlignment.Far;
	graphic.DrawString(drawString, drawFont, drawBrush, drawRect, drawFormat);   
}

System.ArgumentException
  HResult=0x80070057
  Message=参数无效。
  Source=System.Drawing
  StackTrace:
   at System.Drawing.Graphics.CheckErrorStatus(Int32 status)
   at System.Drawing.Graphics.DrawString(String s, Font font, Brush brush, 
RectangleF layoutRectangle, StringFormat format)
   at Program.Main(String[] args) in ...

nginx: [emerg] CreateFile() "D:\Work\XX项目\nginx-1.20.1/conf/nginx.conf" failed (1113: No mapping for the Unicode character exists in the target multi-byte code page)

nginx: [emerg] "proxy_pass" cannot have URI part in location given by regular expression, or inside named location, or inside "if" statement, or inside "limit_except" block in D:\Work\nginx-1.20.1/conf/nginx.conf:49

		location  ~ (^/13.132.175.150:28008).*  {
			proxy_pass http://13.132.175.150:28008/;
			proxy_set_header Host                $host:$server_port;
			proxy_set_header X-Forwarded-For     $proxy_add_x_forwarded_for;
			proxy_set_header X-Forwarded-Proto   $scheme;
			proxy_set_header X-Forwarded-Port    $server_port;
		}

		location /13.132.175.150:28008/ {
			proxy_pass http://13.132.175.150:28008/;
			proxy_set_header Host                $host:$server_port;
			proxy_set_header X-Forwarded-For     $proxy_add_x_forwarded_for;
			proxy_set_header X-Forwarded-Proto   $scheme;
			proxy_set_header X-Forwarded-Port    $server_port;
		}

declare 
type ref_cur_type is ref cursor;
cur_list ref_cur_type;
v_sql varchar2(2000);
v_addr_id INTEGER;
v_address varchar2(50);
begin
  v_sql := 'select ADDR_ID, ADDRESS from T_DW_ADDR';
  open cur_list for v_sql;
  loop
    fetch cur_list into v_addr_id, v_address;
    update T_MON_TERMINAL set addr_id = v_addr_id where address = v_address;
    update T_LED_EQUIP set addr_id = v_addr_id where address = v_address;
    end loop;
    close cur_list;
    commit;
end;

> ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML 
ORA-06512: at "TEST.FUN_DROP_EMPTY_TABLE", line 19

> ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "TEST.FUN_DROP_EMPTY_TABLE", line 20
ORA-06512: at line 3

delimiter //
drop procedure if exists sp_drop_empty_table;
create procedure sp_drop_empty_table(dbname varchar(200), tablename varchar(200))
begin
  declare done int default false;
  declare v_index int;
  declare v_result text;
  declare v_cnt int;
  declare v_table varchar(200);
  declare cur_tables cursor for select table_name from information_schema.tables where lower(table_schema) = lower(dbname) and lower(table_name) like lower(concat(tablename, '%'));
  declare continue handler for not found set done = true;
  set v_index = 0;
  set v_result = '';

  open cur_tables;

  read_loop: loop
    fetch cur_tables into v_table;
    if done then
      leave read_loop;
    end if;
    set v_index = v_index + 1;
    set @sql_text = concat('select count(*) into @cnt from ', v_table, ';');
    prepare querystmt from @sql_text;
    execute querystmt;
    deallocate prepare querystmt;
    set v_cnt = @cnt;
    
    if v_cnt = 0 then
      -- if not set foreign_key_checks=0, will be:> 1217 - cannot delete or update a parent row: a foreign key constraint fails
      set foreign_key_checks=0;
      set @sql_text = concat('drop table ', v_table, ';');
      prepare dropstmt from @sql_text;
      execute dropstmt;
      deallocate prepare dropstmt;
      set foreign_key_checks=1;
    
      set v_result = concat(v_result, char(10), concat('table:', v_table, ' is empty, drop success.'));
    else
      set v_result = concat(v_result, char(10), concat('table:', v_table, ' has records, drop fail. total count=', v_cnt));
    end if;    
  end loop;

  close cur_tables;  
  
  if v_index = 0 then
    set v_result = concat('table:', tablename, ' does not exist.');
  end if;
  
  select v_result;
end;
//
delimiter ;

-- > 1336 - Dynamic SQL is not allowed in stored function or trigger

call sp_drop_empty_table('xx_db', 't_xxxx');

If you use the mysql client program to define a stored program containing semicolon characters, a problem arises. By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server.

float input = 106.6509332F;
Console.WriteLine(input);
Console.WriteLine(Convert.ToDecimal(input));

//输出
//106.6509
//106.6509

float input = 106.6509332F;
Console.WriteLine(input);
Console.WriteLine(Convert.ToDecimal((double)input));
Console.WriteLine(input.ToString("G9"));

//输出
//106.6509
//106.650932312012
//106.65093

float input2 = 865569.6509332F;
Console.WriteLine(input2);
Console.WriteLine(input2.ToString("G9"));

//输出
//865569.6
//865569.625

git log --pretty=tformat: --since="2022-07-05" --until="2022-07-21" --numstat | awk '{ add += $1; subs += $2; loc += $1 - $2 } END { printf "新增行数: %s, 移除行数: %s, 总行数: %s\n", add, subs, loc }'

git log --since="2022-07-05" --until="2022-07-21" --no-merges | grep -e 'commit [a-zA-Z0-9]*' | wc -l

git log --format='%aN' | sort -u | while read name; do echo -en "$name\t"; git log --author="$name" --pretty=tformat: --numstat | awk '{ add += $1; subs += $2; loc += $1 - $2 } END { printf "added lines: %s, removed lines: %s, total lines: %s\n", add, subs, loc }' -; done

Download https://repo.maven.apache.org/maven2/org/jetbrains/kotlin/kotlin-compiler-embeddable/1.7.10/kotlin-compiler-embeddable-1.7.10.jar (16.04 MB / 52.52 MB)

allprojects {
    repositories {
        maven { url 'file:///G:/maven'}
        mavenLocal()
        maven { url 'https://maven.aliyun.com/repository/central/'}
        maven { url 'https://maven.aliyun.com/repository/public/' }
        maven { url 'https://maven.aliyun.com/repository/google/' }
        maven { url 'https://maven.aliyun.com/repository/gradle-plugin/' }
        mavenCentral()
    }

    buildscript { 
        repositories { 
			maven { url 'https://maven.aliyun.com/repository/central/'}
			maven { url 'https://maven.aliyun.com/repository/public/' }
			maven { url 'https://maven.aliyun.com/repository/google/' }
			maven { url 'https://maven.aliyun.com/repository/gradle-plugin/' }
        }
    }
}

:: 判断windows服务是否存在
@echo off 
@set serviceName=aspnet_state

@sc query "%serviceName%" > nul
if not errorlevel 1060 (
	@echo %serviceName%服务存在
) else (
	@echo %serviceName%服务不存在
)
@pause

E:\Tools>fciv.exe -both fciv.exe
//
// File Checksum Integrity Verifier version 2.05.
//
                MD5                             SHA-1
-------------------------------------------------------------------------
e2c6d562bd35352b73c00a744e9c07c6 f5259423eb42664dec7a32ba6a7cf0d85d13e752 fciv.exe

D:\Software\Oracle>fciv.exe -md5 -sha1 winx64_12102_database_1of2.zip
//
// File Checksum Integrity Verifier version 2.05.
//
                MD5                             SHA-1
-------------------------------------------------------------------------
f7bf17b1d45f618c1b8c7261047838c5 ce30b8063b5d4e5ab387192e8e41b9d182ccd467 winx64_12102_database_1of2.zip

D:\Software\Oracle>fciv.exe -md5 -sha1 winx64_12102_database_2of2.zip
//
// File Checksum Integrity Verifier version 2.05.
//
                MD5                             SHA-1
-------------------------------------------------------------------------
bd6c1c3b4452402a1339e428e9bba353 dfacb3407df341304da35436fc890c5f00954825 winx64_12102_database_2of2.zip

E:\Tools>fciv.exe -help
//
// File Checksum Integrity Verifier version 2.05.
//

Usage:  fciv.exe [Commands] <Options>

Commands: ( Default -add )

        -add    <file | dir> : Compute hash and send to output (default screen).

                dir options:
                -r       : recursive.
                -type    : ex: -type *.exe.
                -exc file: list of directories that should not be computed.
                -wp      : Without full path name. ( Default store full path)
                -bp      : specify base path to remove from full path name

        -list            : List entries in the database.
        -v               : Verify hashes.
                         : Option: -bp basepath.

        -? -h -help      : Extended Help.

Options:
        -md5 | -sha1 | -both    : Specify hashtype, default md5.
        -xml db                 : Specify database format and name.

To display the MD5 hash of a file, type fciv.exe filename

Compute hashes:
        fciv.exe c:\mydir\myfile.dll
        fciv.exe c:\ -r -exc exceptions.txt -sha1 -xml dbsha.xml
        fciv.exe c:\mydir -type *.exe
        fciv.exe c:\mydir -wp -both -xml db.xml

List hashes stored in database:
        fciv.exe -list -sha1 -xml db.xml

Verifications:
        fciv.exe -v -sha1 -xml db.xml
        fciv.exe -v -bp c:\mydir -sha1 -xml db.xml

{
  "type": "https://tools.ietf.org/html/rfc7231#section-6.5.1",
  "title": "One or more validation errors occurred.",
  "status": 400,
  "traceId": "00-36e71dbf52b567b263bc21218b44c679-754419d31dc03116-00",
  "errors": {
    "Id": [
      "The Id field is required."
    ],
    "Name": [
      "The Name field is required."
    ],    
    "RequestUrl": [
      "The RequestUrl field is required."
    ],
    "Description": [
      "The Description field is required."
    ]
  }
}

public class DemoViewModel
{
        public string? Id { get; set; }

        public string? Name { get; set; }

        public string? RequestUrl { get; set; }

        public string? Description { get; set; }
}

services.AddControllers(options =>
{
    options.SuppressImplicitRequiredAttributeForNonNullableReferenceTypes = true;
});

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer>witadmin exportwitd /?
Microsoft(R) 工作项跟踪管理工具。
版权所有(C) Microsoft Corporation。保留所有权利。

导出工作项类型的 XML 定义。

用法: witadmin exportwitd /collection:collectionurl /p:project /n:typename [/f:filename] [/e:编码]
[/exportgloballists]

 /collection           指定 Azure DevOps 项目集合。请使用完全指定的 URL，如 http://servername:8080/tfs/Collection0。
 /p                    指定团队项目的名称。
 /n                    指定要导出的工作项类型的名称。
 /f                    为导出工作项类型 XML 指定目标文件。如果未指定，则将 XML 输出到显示器。
 /e                    指定用于导入 XML 文件的 .NET Framework 2.0 编码的名称。例如，/e:utf-7 将使用 Unicode
                       (UTF-7)编码。如有可能，自动检测编码。如果无法检测编码，则将使用 UTF-8。
 /exportgloballists    导出所引用的全局列表的定义。  如果未指定，则将省略全局列表定义。

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer>witadmin importwitd /?
Microsoft(R) 工作项跟踪管理工具。
版权所有(C) Microsoft Corporation。保留所有权利。

此命令将工作项类型 XML 定义文件导入到 Azure DevOps Server
上的团队项目中。如果已存在具有相同名称的工作项类型，则新的工作项类型定义将覆盖现有的定义。如果工作项类型尚不存在，则将
新建一个工作项类型。

用法: witadmin importwitd /collection:collectionurl [/p:project] /f:filename [/e:编码] [/v]

 /collection    指定 Azure DevOps 项目集合。请使用完全指定的 URL，如 http://servername:8080/tfs/Collection0。
 /p             指定要在其中导入新工作项类型的团队项目。  此操作是必需的(使用 validation-only 选项时除外)。
 /f             指定要导入的工作项类型 XML 定义文件。
 /e             指定用于导入 XML 文件的 .NET Framework 2.0 编码的名称。例如，/e:utf-7 将使用 Unicode
                (UTF-7)编码。如有可能，自动检测编码。如果无法检测编码，则将使用 UTF-8。
 /v             在不导入工作项类型、链接类型或全局工作流的 XML 定义情况下对其进行验证。

witadmin exportwitd /collection:http://192.168.1.108:8080/tfs/XXX项目集合 /p:LED项目 /n:需求 /f:request.xml
witadmin exportwitd /collection:http://192.168.1.108:8080/tfs/XXX项目集合 /p:LED项目 /n:任务 /f:task.xml

<!-- 修改前的xml节点 -->
<Group Label="计划">
  <Control Label="开始日期" Type="FieldControl" FieldName="Microsoft.VSTS.Scheduling.StartDate" ReadOnly="True" />
  <Control Label="完成日期" Type="FieldControl" FieldName="Microsoft.VSTS.Scheduling.FinishDate" ReadOnly="True" />
</Group>

<!-- 修改后的xml节点 -->
<Group Label="计划">
  <Control Label="开始日期" Type="DateTimeControl" FieldName="Microsoft.VSTS.Scheduling.StartDate" />
  <Control Label="完成日期" Type="DateTimeControl" FieldName="Microsoft.VSTS.Scheduling.FinishDate" />
</Group>

witadmin importwitd /collection:http://192.168.1.108:8080/tfs/XXX项目集合 /p:YYY项目 /f:request.xml
witadmin importwitd /collection:http://192.168.1.108:8080/tfs/XXX项目集合 /p:YYY项目 /f:task.xml

--题目1
SELECT CNO,
(SELECT COUNT(*) FROM T_STUDENT_COURSE_SCORE a WHERE scs.CNO = a.CNO and a.SCORE >= 60 AND a.SCORE < 70) AS '60-70',
(SELECT COUNT(*) FROM T_STUDENT_COURSE_SCORE a WHERE scs.CNO = a.CNO and a.SCORE >= 70 AND a.SCORE < 80) AS '70-80',
(SELECT COUNT(*) FROM T_STUDENT_COURSE_SCORE a WHERE scs.CNO = a.CNO and a.SCORE >= 80 AND a.SCORE < 90) AS '80-90',
(SELECT COUNT(*) FROM T_STUDENT_COURSE_SCORE a WHERE scs.CNO = a.CNO and a.SCORE >= 90 AND a.SCORE <= 100) AS '90-100'
FROM T_STUDENT_COURSE_SCORE scs
GROUP BY scs.CNO;

--题目2
DELETE FROM T_STUDENT_SCORE a
WHERE EXISTS (
	SELECT 1 
	FROM (SELECT b.ROWNUM, b.ROWID FROM T_STUDENT_SCORE b
			WHERE EXISTS (
				SELECT 1 FROM T_STUDENT_SCORE c
				WHERE c.SNAME = b.SNAME AND c.SCORE = b.SCORE
				GROUP BY c.SNAME, b.SCORE
				HAVING COUNT(*) > 1
			)
		)
	) cte
	WHERE cte.ROWNUM > 1 AND a.ROWID = cte.ROWID
);
commit

DELETE FROM T_STUDENT_SCORE 
WHERE ROWID NOT IN (
	SELECT MIN(ROWID) 
	FROM T_STUDENT_SCORE 
	GROUP BY NAME,SCORE
);
commit

<?xml version="1.0"?>
<configuration>
    <system.webServer>
        <validation validateIntegratedModeConfiguration="false" />
        <directoryBrowse enabled="true" />
        <staticContent>
            <remove fileExtension=".mp3" />
            <remove fileExtension=".mp4" />
            <remove fileExtension=".webm" />
            <remove fileExtension=".ogg" />
            <remove fileExtension=".ogv" />
            <remove fileExtension=".flv" />
            <remove fileExtension=".7z" />
            <remove fileExtension=".log" />
            <mimeMap fileExtension=".mp3" mimeType="audio/mpeg" />
            <mimeMap fileExtension=".mp4" mimeType="video/mp4" />
            <mimeMap fileExtension=".webm" mimeType="video/webm" />
            <mimeMap fileExtension=".ogg" mimeType="audio/ogg" />
            <mimeMap fileExtension=".ogv" mimeType="video/ogg" />
            <mimeMap fileExtension=".flv" mimeType="video/x-flv" />
            <mimeMap fileExtension=".7z" mimeType="application/octet-stream" />
            <mimeMap fileExtension=".log" mimeType="text/plain" />
        </staticContent>
    </system.webServer>
    <system.web>
        <authentication mode="None" />
        <sessionState mode="Off" />
        <profile enabled="false" />
        <httpModules>
            <clear/>
        </httpModules>
        <httpHandlers>
            <clear/>
            <add path="*" verb="GET,HEAD,POST" type="System.Web.DefaultHttpHandler" validate="True" />
            <add path="*" verb="*" type="System.Web.HttpMethodNotAllowedHandler" validate="True" />
        </httpHandlers>
    </system.web>
</configuration>

    public class AllowCorsAttribute : ActionFilterAttribute
    {
        public override void OnActionExecuting(ActionExecutingContext filterContext)
        {
            filterContext.RequestContext.HttpContext.Response.AddHeader("Access-Control-Allow-Origin", "*");
            filterContext.RequestContext.HttpContext.Response.AddHeader("Access-Control-Request-Method", "POST,GET,PUT,DELETE,OPTIONS");
            filterContext.RequestContext.HttpContext.Response.AddHeader("Access-Control-Allow-Headers", "Content-Type,X-Requested-With");
            
            base.OnActionExecuting(filterContext);
        }
    }

        public static void RegisterGlobalFilters(GlobalFilterCollection filters)
        {
            filters.Add(new AllowCorsAttribute());
        }

$.fn.datagrid.defaults.view.onBeforeRender = function(target, rows) {
    var dgState = $.data(target, 'datagrid');
    var opts = dgState.options;
    
    if (opts.rownumbers)
    {
        var rownumber = 0;
        if (opts.pagination) {
            rownumber += (opts.pageNumber - 1) * opts.pageSize + rows.length;
        }
        
        if (rownumber > 0) {
            var rowNumWidth = rownumber.toString().length * 10;
            if (rowNumWidth < 30) {
                rowNumWidth = 30;
            }
            $.fn.datagrid.defaults.rownumberWidth = rowNumWidth;

            dgState.ss.set(".datagrid-cell-rownumber", (rowNumWidth - 1) + "px");
            dgState.ss.set(".datagrid-header-rownumber", (rowNumWidth - 1) + "px");
        }
    }
};

vs_enterprise.exe --layout D:\vs2019layout --add Microsoft.VisualStudio.Workload.ManagedDesktop --add Microsoft.VisualStudio.Workload.NetWeb  --add Microsoft.VisualStudio.Workload.Node --add Component.GitHub.VisualStudio --includeOptional --lang zh-CN

VisualStudioSetup.exe --layout F:\vs2022layout --add Microsoft.VisualStudio.Workload.ManagedDesktop --add Microsoft.VisualStudio.Workload.NetWeb --add Microsoft.VisualStudio.Workload.Node --includeOptional --lang Zh-cn

x, y, z = 1, 2, 'Hello World!' 

#示例
#a1和a1引用的相同对象
a1 = a2 = 123

#b1和b2引用的不同对象
b1=123
b2=123 

#结果：True
a1 is a1 

#结果：False
b1 is b2