Answers for "ms sql delete rows"

SQL
2

sql server delete row

DELETE FROM my_table WHERE id = 3;
DELETE FROM my_table;                   -- All rows
DELETE TOP 10 FROM my_table;            -- First 10 rows
DELETE TOP 10 PERCENT FROM my_table;    -- First 10% of rows
Posted by: Guest on April-17-2021
1

delete row mssql

DELETE FROM table_name WHERE condition;

-- Note: Be careful when deleting records in 
-- a table! Notice the WHERE clause in the DELETE 
-- statement. The WHERE clause specifies which record(s) 
-- should be deleted. If you omit the WHERE clause, all records 
-- in the table will be deleted!
Posted by: Guest on February-22-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language