SQL连接超时
来源:百度知道 编辑:UC知道 时间:2024/06/14 19:41:04
删除表前100条数据,提示连接超时
怎么回事?
DELETE FROM table
WHERE (BDE IN
(SELECT TOP 100 BDE
FROM table
ORDER BY BDE))
怎么回事?
DELETE FROM table
WHERE (BDE IN
(SELECT TOP 100 BDE
FROM table
ORDER BY BDE))
关了重开试试:)
SQL2005以上版本可用
with c
as
(SELECT TOP 100 *
FROM table ORDER BY BDE
)
delete c
估计是表被其它进程锁住了。可用事件控查器看原因