根据列值得到一个组合列

[B525068254]

A表
F_clientID F_ItemID F_UnitID F_Grade F_Color F_BatchNo
281 16 2 700 芷青 0 281/16/2/700/芷青/0
281 16 2 600 中灰 0 281/16/2/600/中灰/0
281 16 30 1000 军绿 0 281/16/30/1000/军绿/0

select F_ClientID,F_UnitID,F_ItemID,F_Grade,F_color,F_BatchNo,
cast(F_ClientID as Varchar(30))+'/'+cast(F_UnitID as Varchar(30))+'/'+cast(F_ItemID as Varchar(30))+'/'+F_Grade+'/'+F_Color+'/'+F_BatchNo as F_BarCode from A


是得到这列值，但我想通过字段的计算获得这一列,字段中如何设置

[Neo_whl]

--这样？  用计算列
create table A
(
 F_ClientID int,
 F_UnitID int,
 F_ItemID int,
 F_Grade varchar(10),
 F_Color varchar(10),
 F_BatchNo varchar(10),
 F_BarCode as cast(F_ClientID as Varchar(30))+'/'+cast(F_UnitID as Varchar(30))+'/'+cast(F_ItemID as Varchar(30))+'/'+F_Grade+'/'+F_Color+'/'+F_BatchNo
)