作者查詢 / retsamsu
作者 retsamsu 在 PTT [ Database ] 看板的留言(推文), 共152則
限定看板:Database
看板排序:
全部Database152Visual_Basic96C_Sharp64Google61MobilePay44Android34creditcard26HOT_Game24Gossiping21EZsoft19Windows18Baseball17Fund17ADS15MobileComm15CGI-Game12learnyf12Lifeismoney11Ruby11Ingress10Instant_Mess10Japan_Travel10Doraemon8Bank_Service7China_Travel7kapilands7Browsers6iOS6YAKYU5Ajax4Linux4share4drawing3e-shopping3GameDesign3Hanson-Wu3joke3OOAD3PHP3pts3puzzle3YP89-3043BigPeitou2CMWang2CodeJob2mobile-game2THU_BA20002Tigers2AllTogether1Blog1BoardGame1Boy-Girl1Cardinals1CYCUEL95A1Doctor-Info1e-coupon1FJU-ACCR941Haruhi1IME1India1KS94-3131License1marvel1NTHU-EE-CAPT1NTUE-DC991NTUST-EE5041NY-Mets1PCman1PDA1Road1Sangokumusou1SWORD1TFSHS61th3021TVCard1Zhongshan1<< 收起看板(75)
2F→: chatgpt https://imgur.com/a/n9MJJdk03/17 09:49
2F→: SET @sql = 'select' +@i+ 'FROM table where ...';02/25 16:34
3F→: 記得要 into 到 temp table02/25 16:37
4F→: 然後 EXEC (@sql) 再 select temp table 就有你要的02/25 16:37
1F→: 這個有看過了嗎? https://ibm.co/37iM9Og08/03 13:52
1F→: 單就你要縮小 transaction log 你可以備份 log07/12 08:29
2F→: 但是要考慮一下有沒有其他 replication/backup 方法用到07/12 08:30
3F→: log 而造成 replication/backup 異常的作業07/12 08:31
2F推: 試試看 https://bit.ly/35MzXWA09/18 20:52
1F推: https://github.com/sujunmin/SQLServerTraceFilePars09/13 21:23
2F→: er 小弟拙作,用 Powershell 與 bcp select 抓特權作業09/13 21:23
3F→: 並且寄信,不嫌棄可以參考一下~09/13 21:23
4F推: 設個排程跑可以幾乎即時的狀態抓亂做事的 user09/13 21:26
2F→: -t "," -q07/08 13:32
1F推: 最近剛好有在討論 https://reurl.cc/mnNDgG06/04 18:54
2F→: 先考慮能不能存吧06/04 18:54
1F→: 幫你找一下 https://reurl.cc/MvjYWn05/07 13:34
1F→: https://reurl.cc/jd0O2D01/16 17:18