摘要: /*查询执行SQL升级前后,存储过程的参数数量变化*/ --升级前 select a.id,b.name, count(1) as c_count into TT99812 from syscolumns a join (select id,name from sysobjects where OB 阅读全文
posted @ 2024-12-24 15:47 wsh3166Sir 阅读(1) 评论(0) 推荐(0) 编辑
摘要: package main const MyKey = `MIIEvQIBADANBgkqSkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDj/3+USBaoVSSklSdmnKAEmFIIarRzt/fJXixNUWsCfBCCOO+pURwAlqNvRVQqE2dtcr5uE0 阅读全文
posted @ 2024-08-06 16:34 wsh3166Sir 阅读(29) 评论(0) 推荐(0) 编辑
摘要: 字符串转日期 SELECT CONVERT(datetime,'19490224') --: 1949-02-24 00:00:00.000 SELECT CONVERT(datetime,'1949/02/24') -- : 1949-02-24 00:00:00.000 SELECT CONVE 阅读全文
posted @ 2024-05-15 15:34 wsh3166Sir 阅读(508) 评论(0) 推荐(0) 编辑
摘要: package main import ( "database/sql" "fmt" "mylog" "time" ) type Middleware struct{} /*如遇错误,执行额外任务*/ func (m *Middleware) Println(v interface{}) { if 阅读全文
posted @ 2024-05-14 10:06 wsh3166Sir 阅读(6) 评论(0) 推荐(0) 编辑
摘要: <script> const music = new Audio('med/CanonInD.mp3'); music.loop =true; document.addEventListener("DOMContentLoaded", function(event) { console.log("页 阅读全文
posted @ 2024-05-13 22:11 wsh3166Sir 阅读(43) 评论(0) 推荐(0) 编辑
摘要: 直接上代码 package main import ( "encoding/json" "fmt" "strconv" ) type Result struct { RequestID string `json:"request_id"` Code string `json:"code"` Msg 阅读全文
posted @ 2024-02-15 21:55 wsh3166Sir 阅读(79) 评论(0) 推荐(0) 编辑
摘要: select job_id,step_name,message, cast( ( cast( LEFT ( run_date, 4 ) AS VARCHAR ) + '-' + SUBSTRING( cast( run_date AS VARCHAR ), 5, 2 ) + '-' + cast( 阅读全文
posted @ 2024-01-16 10:57 wsh3166Sir 阅读(25) 评论(0) 推荐(0) 编辑
摘要: 网页客户端 : <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" con 阅读全文
posted @ 2024-01-06 17:11 wsh3166Sir 阅读(6) 评论(0) 推荐(0) 编辑
摘要: 用nginx代理不知道为什么内网能用,外网用不了,改用go写个代理临时用下,直接上代码 package main import ( "fmt" "io" "log" "net" ) var addr string = "0.0.0.0:51415" //代理服务端口 var dest_addr st 阅读全文
posted @ 2023-12-13 20:37 wsh3166Sir 阅读(27) 评论(0) 推荐(0) 编辑
摘要: 引入jS<script type="text/javascript" src="/Public/js/jquery.2.2.4.min.js"></script> <script type="text/javascript" src="/Public/js/jquery.table2excel.js 阅读全文
posted @ 2023-08-25 13:00 wsh3166Sir 阅读(164) 评论(0) 推荐(0) 编辑