bulk insert
to insert CSV data into a table. dbcc …
are the database console commands. if
to conditionally execute statements depending on a boolean expression. kill
terminates processes. reconfigure
, apparently needed sometimes after executing sp_configure
. throw
statement. while
to iterate over a block of statements until a certain condition becomes false.