SQL資料旋轉的問題

表A 

uaserid  uaserid1  uaserid2  uaserid3  
    1              3                4                5 

表B為空白表，如何獲得表A的資料插入表B，最終結果是 

id 
3 
4 
5 

解決方案:

if object_id('[A]') is not null drop table [A]gocreate table [A]([uaserid] int,[uaserid1] int,[uaserid2] int,[uaserid3] int)insert [A]select 1,3,4,5if object_id('[B]') is not null drop table [B]gocreate table [B]([id] int)insert into b(id)select uaserid1 from Aunion allselect uaserid2 from Aunion allselect uaserid3 from Aselect * from [B]--測試結果:/*id          ----------- 345（所影響的行數為 3 行）*/