摘要:
c# using System.Diagnostics; Stopwatch stopwatch = Stopwatch.StartNew(); //业务 long milliseconds = stopwatch.ElapsedMilliseconds; js // 创建两个日期对象 var st 阅读全文
摘要:
步骤1: 步骤2: ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyPass@123' PASSWORD EXPIRE NEVER;ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_pa 阅读全文
摘要:
Merge into @TableName AS T Using #TmpTable AS S ON (T.Type = S.Type) WHEN MATCHED THEN UPDATE SET T.[TypeDesc]=S.[TypeDesc] WHEN NOT MATCHED THEN INSE 阅读全文
摘要:
Sql 字符串按指定字符转多行(表值函数) 方法一 select * from SplitToTable('12+3+4545+2322','+')select * from SplitToTable('12,3,4545,2322',',') ALTER FUNCTION [dbo].[Split 阅读全文
摘要:
select tr.name as [触发器],ta.name as [表名],tr.is_disabled as [是否禁用], tr.is_instead_of_trigger AS [触发器类型], case when tr.is_instead_of_trigger = 1 then 'IN 阅读全文