原因是有Transaction沒有Commit, 記得Commit
而且語法是
BEGIN TRAN
COMMIT
不是
BEGIN TRAN
COMMIT TRAN
參考來源: https://blog.sqlauthority.com/2007/04/25/sql-server-alternate-fix-error-1222-lock-request-time-out-period-exceeded/ https://docs.microsoft.com/en-us/sql/t-sql/language-elements/begin-transaction-transact-sql?view=sql-server-ver15
SQL Server
Grafana + Telegraf + InfluxDB 監控 SQL Server - SQL Server
Task Scheduler設定排程錯誤時發送Mail - Powershell
JOIN ON 常數的用途是什麼?跟放在WHERE一樣嗎?/ FULL JOIN要注意的事項- SQL Server
SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)
bart30508 (147)