T-SQL - SQL Server 2008

SQL Server is a Microsoft database and reporting software. To view and manipulate data and tables T-SQL or transact SQL is used.

MAKE NEW TABLE (create data table, property definitions, set primary key, etc.)






DROP TABLE (same as remove/deleting a table)






TRUNCATE TABLE (delete all the data in the table but keep the table and table structure)








SELECT(select data for viewing)








SELECT (select data)
INTO (Insert into a specific table)






MERGE (Merge two tables)






STORED PROCEDURES


Setting Variables