隐藏某些字段SQL Server 2008中的表数据 [英] Hide Some feild Data of tables in SQL Server 2008

问题描述

从字段中检索数据时。它会正确地获取它，就像这样;



IncidentClassificationEnum.Hardware

IncidentClassificationEnum.Printing

IncidentClassificationEnum.Email



我可以隐藏一些数据（IncidentClassificationEnum）。这是可能的，因为我搜索了所有的表，但无法找到这样的表只有这个。在SCSM上它只能取，像这样;



硬件

打印

电子邮件



而且，在我的自定义报告中，我也想要如上所述的获取类别。



如果有可能请告诉我很快。



提前致谢。

When I retrieve data from a field. it will fetch it properly, like this;

IncidentClassificationEnum.Hardware
IncidentClassificationEnum.Printing
IncidentClassificationEnum.Email

Can i hide some data (IncidentClassificationEnum) from it. Is this possible because i searched out all tables but cant find such table which have this only. On SCSM it can fetch only, Like this;

Hardware
Printing
Email

And, in my custom report i also want fetch category like as above.

If it is possible then kindly tell me soon.

Thanks in advance.

推荐答案

hi，



在你的查询中尝试这个，



从tablename






问候，

Prakash.T

try this in your query,

select REPLACE(yourfieldname,''ncidentClassificationEnum.'','''') from tablename



regards,
Prakash.T

这篇关于隐藏某些字段SQL Server 2008中的表数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！