date:2016/3/29
questions:SELECT FieldName+'|'+FieldNum+'|'+Fieldtype+'|'+FieldRelation AS FieldName FROM TTKNOA.dbo.SC_FieldSearch WHERE TableName = 'CMI.ServiceListInfo' Order By OrderBy
是我太low了吗,刚看到这段代码还以为SQL中能用|和&位运算符,试了之后才发现这样的写法是讲上面几个字段的结果取出来之后用|进行分割显示在一个字段中。
FieldName|FieldNum|Fieldtype|FieldRelation
单位名称|CMI20.dbo.ServiceListInfo.UnitName|varchar|LIKE,=