SQL显示表子段信息的语句
select Sys.Name,replace(cast(y.value as nvarchar(500)),'{1}','') as Value from KSFL_ElectronicCommerce..SysColumns sys left join
sys.extended_properties y on y.major_id=sys.id and y.minor_id=sys.colorder
where y.name='MS_Description' and sys.id=object_id('{0}') and cast(y.value as nvarchar(500)) like '%{1}%'";
umn_name AS Name
select Sys.Name,replace(cast(y.value as nvarchar(500)),'{1}','') as Value from KSFL_ElectronicCommerce..SysColumns sys left join
sys.extended_properties y on y.major_id=sys.id and y.minor_id=sys.colorder
where y.name='MS_Description' and sys.id=object_id('{0}') and cast(y.value as nvarchar(500)) like '%{1}%'";
umn_name AS Name