Sql server 2008 的基础常识总结(国外英语资料).doc

Sql server 2008 的基础知识总结 Sql server 2008 basics summary Finished by sina weibo@marmatt SQL statements add columns, modify column types, modify columns, and delete columns. The change statement for the database SQL language can be used to modify the base table, which is typically formatted as: ALTER TABLE TABLE name [changing mode] Change the way: ? ADD a column: ADD column 1 column 1 Delete a column: DROP column 1 ? CHANGE the name of the column: CHANGE, new column name, new column name. Change the column name: MODIFY column 1 new data type As you can see, modifying the base table provides the following four changes: (1) the ADD: To add new columns and integrity constraints, the columns are defined in the same way as the columns in the CREARE TABLE statement, whose syntax format: ALTER TABLE TABLE name ADD column definition | integrity constraint . Because the new column added in this method automatically fills NULL values, you cannot specify NOT NULL constraints for the new columns that are added. (2) the DROP: To delete the specified integrity constraint, or the specified column, whose syntax is: ALTER TABLE TABLE name DROP [] ALTER TABLE TABLE name DROP COLUMN COLUMN name Note: some database systems do not allow this to delete columns in the database table (DROP COLUMN COLUMN name ). (3) CHANGE the way Used to modify certain columns in their syntax format: ALTER TABLE [TABLE name] CHANGE TO new column name new column data type - is wrong The EXECUTE sp_rename N dbo. Student table. Name, N name, COLUMN - correct (4) the MODIFY way For modifying the data types of certain columns, the syntax format: ALTER TABLE [TABLE name] [column name] [data type] Note: all MSSQL systems have their own functions (1) date and time type -datatime accuracy is three hundredths of a second The alter table student table Add creation time datetime default getdate () Insert into student form (student class, student name, student age, teacher number) values ( class , 7,