看看sql server中是否有高手？

Question

這麼可能不可以？create view my_view
as
SELECT WorkBook.PsnSMCID,WorkBook.JobDate,
WorkBook.WorkStartTime,WorkBook.WorkEndTime, 
WorkBook.BC_Code, WorkBook.NorWorkTime, WorkBook.OverTime, 
WorkBook.SpeState1, WorkBook.SpeWorkTime1, WorkBook.SpeState2, 
WorkBook.SpeWorkTime2, WorkBook.FactWorkTime, WorkBook.ConState
FROM WorkBook
union
SELECT WorkBook_bak.PsnSMCID, WorkBook_bak.JobDate, 
WorkBook_bak.WorkStartTime, WorkBook_bak.WorkEndTime, 
WorkBook_bak.BC_Code, WorkBook_bak.NorWorkTime, 
WorkBook_bak.OverTime, WorkBook_bak.SpeState1, 
WorkBook_bak.SpeWorkTime1, WorkBook_bak.SpeState2, 
WorkBook_bak.SpeWorkTime2, WorkBook_bak.FactWorkTime, 
WorkBook_bak.ConfirmState
FROM WorkBook_bak;

Answer 1

你先设计器中建一个SELECT WorkBook.PsnSMCID, WorkBook.JobDate， 
WorkBook.WorkStartTime， WorkBook.WorkEndTime, 
WorkBook.BC_Code, WorkBook.NorWorkTime, WorkBook.OverTime, 
WorkBook.SpeState1, WorkBook.SpeWorkTime1, WorkBook.SpeState2, 
WorkBook.SpeWorkTime2, WorkBook.FactWorkTime, WorkBook.ConState
FROM WorkBook
然后保存并退出设计器，再查看这个示图的“属性”把
union
SELECT WorkBook_bak.PsnSMCID, WorkBook_bak.JobDate, 
WorkBook_bak.WorkStartTime, WorkBook_bak.WorkEndTime, 
WorkBook_bak.BC_Code, WorkBook_bak.NorWorkTime, 
WorkBook_bak.OverTime, WorkBook_bak.SpeState1, 
WorkBook_bak.SpeWorkTime1, WorkBook_bak.SpeState2, 
WorkBook_bak.SpeWorkTime2, WorkBook_bak.FactWorkTime, 
WorkBook_bak.ConfirmState
FROM WorkBook_bak
加上就可以了。