----Create new table and insert into table using SELECT INSERTSELECT FirstName, LastNameINTO TestTableFROM Person.ContactWHERE EmailPromotion = 2 ALTE......
----Create new table and insert into table using SELECT INSERT
SELECT FirstName, LastName
INTO TestTable
FROM Person.Contact
WHERE EmailPromotion = 2
ALTER TABLE [dbo].[phone]
ADD inactive_date DATETIME NULL
ALTER TABLE [dbo].[person]
ALTER COLUMN [lastname] VARCHAR(35) NULL
CREATE TABLE jobs
(
job_id smallint IDENTITY(1,1) PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL DEFAULT
min_lvl tinyint NOT NULL CHECK (min_lvl >= 10),
max_lvl tinyint NOT NULL CHECK (max_lvl <= 250)
)
不能给View添加primary key，以前表里面的关键字到view里面也就不是关键字了。
穿插一个oracle操作："SELECT TABLE_NAME FROM USER_TABLES" 用来察看一个表，而MySQL下就是简单的"show databases" and "show tables"
参考：
http://blog.sqlauthority.com/2007/08/15/sql-server-insert-data-from-one-table-to-another-table-insert-into-select-select-into-table/
http://www.sqlinfo.net/sqlserver/sql_server_Alter_Add_column.php
|
