MSSQL Table 29 codes

1 A double pound sign denotes a global temporary object that is visible to all connections as long as the connection that created it i

2 A statement that qualifies the table to be deleted

3 Add columns to a table

4 Add to columns to a table then check the table structure

5 Add value from two columns as the computed column

6 Aliasing the table helps the readability of your query

7 Alter table to add column

8 Alter table to change column data type

9 Alter table to drop a column

10 Alter table to drop table column

11 Calculated and Derived Columns

12 Check table existence

13 Computed columns are (by default) virtual columns not physically stored in the table

14 Copying Selected Rows from a Table

15 CREATE TABLE statement contains the table name, its column definitions in parentheses For each column, a name, data type specificati

16 Create temporary table for numbers

17 Drop a table if necessary

18 If table exists, rename and create new one

19 Local temporary tables are removed at the end of the current session

20 Reference column index

21 Rename the column name

22 SELECT data INTO a table

23 Subqueries

24 SYNTAX of altering table

25 System procedure sp_rename modifies the name of an existing table

26 Timing the delete and truncate statements

27 To view the properties of a table

28 TRUNCATE a TABLE

29 Use aggregate function in sub-query