QQ75026717的博客

delete Patientfrom Patient as aaleft join (select min(id) as id from Patientgroup by patientid) as bbon aa.id = bb.idwhere bb.id is null

–清除存储过程缓存DBCC FREEPROCCACHE–清除会话缓存DBCC FREESESSIONCACHE–清除系统缓存DBCC FREESYSTEMCACHE(‘All’)–清除所有缓存DBCC DROPCLEANBUFFERS

declare @ServiceUrl varchar(200)set @ServiceUrl=‘http://localhost:180/xxx.asmx/Sync?Comd=’+@Comd+’&input=’+@input+’’–Webservice 地址，方法名称，入参。Declare @Object as IntDeclare @ResponseText as nvarchar(4000)EXEC sp_OACreate ‘MSXML2.XMLHTTP’, @Object OUT

/****** Object: Job [任务名称] Script Date: 2020/12/11 10:30:18 /BEGIN TRANSACTIONDECLARE @ReturnCode INTSELECT @ReturnCode = 0/ Object: JobCategory [[Uncategorized (Local)]]] Script Date: 2020/12/11 10:30:18 ******/IF NOT EXISTS (SELECT name FROM

仅用于自己记录一下。方便以后使用。如有雷同，实属巧合public class ServiceUtility{private const string VERIFY_REISTPATIENTIMG_API_URI = “/api/Verify/ReistPatientImg”; #region 动态调用 /// <summary> /// 实例化WebServices /// </summary> /// <param name="

public static string CallWebApi(string Uri, string RequestJson){//请求路径string url = Uri; //定义request并设置request的路径 WebRequest request = WebRequest.Create(url); request.Method = "post"; //初始化request参数 string postDat

代码比较简单。随便建一个窗体类就行public partial class Form1 : Form{public Form1(){InitializeComponent();}Dictionary<string, Action> BtnActions;private void Form1_Load(object sender, EventArgs e){BtnActions = new Dictionary<string, Action> {{“处理”,Pro

SELECT CASE WHEN FLOOR(DATEDIFF(DY,‘1973-10-31’,GETDATE())/365.25) = 0 THEN ‘’ + CONVERT(VARCHAR, 1) ELSE ‘’ + CONVERT(VARCHAR, FLOOR(DATEDIFF(DY,‘1973-10-31’,GETDATE())/365.25)) END AS Age

var l2 = dt.AsEnumerable().ToList().Select(x => x.Field(“ID”)).ToList();DataTable new dt = new DataTable();newdt = dt.Clone(); // 克隆dt 的结构，包括所有 dt 架构和约束,并无数据；DataRow[] rows = dt.Select(conditions); // 从dt 中查询符合条件的记录；DataTable.Select(“City Like ‘B%’”

//[ToolboxBitmap(typeof(DataGrid))]public partial class UCDataGridView : DataGridView{//鼠标移动进来改变颜色private bool _CellColorOnchange = false;private bool _PaintCell = true;private bool _canRefresh = true;private List _columns = new List();//鼠标移动到行上时的颜

git statusgit diffgit checkout – “文件路径” 撤销文件git diff +shift+insertgit add .//git pullgit commiti 进入vi编辑写注释esc退出:wqgit pull

update test1set test1.name=test2.name,test1.age=test2.agefrom test1inner join test2on test1.id=test2.id

自己写的，相目中用到的取某一JSON字段中，某个字字段的值。SELECT tt.Pat_ID,tt.a,tt.b,tt.a-tt.b AS execCount FROM (SELECT Pat_ID,CONVERT(INT,SUBSTRING(SUBSTRING(Step_4_Infor,CHARINDEX(‘Fractions_Tx":’, Step_4_Infor) + 15,CHARINDEX(’",“ProgressDetail’, Step_4_Infor)- CHARINDEX(