insert into CusMovieType(customerID) select customerID from view_customerID
--如果customerID不是自增列,直接插入 insert into CusMovieType(customerID) select customerID from view_customerID--如果是自增列: set identity_insert CusMovieType on insert into CusMovieType(customerID) select customerID from view_customerIDset identity_insert CusMovieType off 不过这个方法有时候也会失败
insert into CusMovieType(customerID)
select customerID from view_customerID
insert into CusMovieType(customerID)
select customerID from view_customerID--如果是自增列:
set identity_insert CusMovieType on
insert into CusMovieType(customerID)
select customerID from view_customerIDset identity_insert CusMovieType off
不过这个方法有时候也会失败