可選擇式複製資料欄位
有時要複製整個資料內容除了那個被玩成幾萬個id的欄位首先要先複製一個架子,
create table Websites1 ( Id int identity(1,1) primary key not null, Name nvarchar(50) not null, Age int not null, Sex char(1) not null )
INSERT INTO Websites1 (name, Age, Sex)
SELECT name, Age, Sex FROM Websites
頁:
[1]