SQL (Updating data)
Exec sp_columns <table_name>
Command which is executed to list all the columns in the specified table
SET XACT_ABORT ON
Turns the Autocommit feature off.
SET XACT_ABORT OFF
Turns the Autocommit feature on.
COMMIT TRANSACTION
Use the COMMIT TRANSACTION command to make updates permanent
DELETE
Use the DELETE command to delete existing rows from a table
DROP TABLE
Use the DROP TABLE command to delete a table and all of its data.
What is an INSERT command containing a SELECT command used for?
Use the INSERT command containing a SELECT command to select the desired data to be included from the existing table.
INSERT
Use the INSERT command to add new rows to a table
ROLLBACK TRANSACTION
Use the ROLLBACK TRANSACTION command to reverse any updates that have not been committed.
How do you add a column to a table?
To add a column to a table, use the ALTER TABLE command with an ADD clause.
How do you change a specific value in a column to null?
To change a specific value in a column to null, use the SET clause followed by the column name, use a condition to select the row, then use an equal sign, and the word NULL.
How do you change all values in a column to null?
To change all values in a column to null, use the SET clause followed by the column name, an equal sign, and the word NULL.
How do you change the characteristics of a column?
To change the characteristics of a column, use the ALTER TABLE command with a MODIFY clause.
CREATE TABLE
To create a new table from an existing table, first create the new table by using the CREATE TABLE command.
UPDATE
Use the UPDATE command to change existing data in a table.