MSSQL_TOP

  • 1321
  • 0

摘要:MSSQL_TOP


--# 分段刪除資料列
--------------------------------------------------------
WHILE
 (SELECT COUNT(*) FROM mng_player_DELETE ) > 0
BEGIN
 DELETE TOP (10)
 FROM mng_player_DELETE
END

-- #
-- INSERT TOP(100)
-- UPDATE TOP(100)
--------------------------------------------------------