2021年10月10日
Sql Server 游标遍历数据 示例
摘要： select * from aaaselect * from bbb DECLARE @bb varchar(50) DECLARE @id int DECLARE My_Cursor CURSOR --定义游标FOR (SELECT id,bb FROM aaa) --查出需要的集合放到游标中OP 阅读全文
posted @ 2021-10-10 16:47 limitpjz 阅读(158) 评论(0) 推荐(0)
Mysql配置步骤
摘要： 步骤1： 步骤2： ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyPass@123' PASSWORD EXPIRE NEVER;ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_pa 阅读全文
posted @ 2021-10-10 16:46 limitpjz 阅读(52) 评论(0) 推荐(0)
TCP返回信号
摘要： using System;using System.Net;using System.Net.Sockets;using System.Text; namespace ConsoleApplication1{ class Program { static void Main(string[] arg 阅读全文
posted @ 2021-10-10 16:43 limitpjz 阅读(111) 评论(0) 推荐(0)
附近车场KPI
摘要： <!doctype html><html><head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="initial-scale= 阅读全文
posted @ 2021-10-10 16:40 limitpjz 阅读(34) 评论(0) 推荐(0)
C#批量更新或插入数据
摘要： 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 阅读全文
posted @ 2021-10-10 16:35 limitpjz 阅读(296) 评论(0) 推荐(0)