Join
-
MSSQL DELETE 및 DELETE JOINIT/SQL 2024. 4. 22. 13:33
MSSQL DELETE 문과 FROM 및 JOIN 절을 사용한 DELETE 문을 살펴봅니다. 구문 -- Syntax for SQL Server and Azure SQL Database [ WITH [ ,...n ] ] DELETE [ TOP ( expression ) [ PERCENT ] ] [ FROM ] { { table_alias | | rowset_function_limited [ WITH ( table_hint_limited [ ...n ] ) ] } | @table_variable } [ ] [ FROM table_source [ ,...n ] ] [ WHERE { | { [ CURRENT OF { { [ GLOBAL ] cursor_name } | cursor_variable_name } ]..