--把增加表属性的SQL放在最前面,以免后面因为缺少属性报错GO--添加需要的固定资产字段IFOBJECT_ID(t_AssetBarCodeFields)isNullBegincreatetablet_AssetBarCodeFields(FIDintidentity(1,1)primarykey,FKeyvarchar(50),FName_CHSnvarchar(30),FName_CHTnvarchar(30),FName_ENnvarchar(50),FMustFieldbitdefault(0))InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values(FAssetNumber,资产编码,...