评论会员:游客 时间:2012/02/07
RaisKazi:在SQLServer中使用这个支点。有更多的信息,看看下面的链接。imgsrc=
阿米尔Mahfoozi
评论会员:游客 时间:2012/02/07
,喜jagadeesh你的问题是有点晦涩,但一般到多个列一列是一个通用的方法:codeprelang="SQL"spanclass="code-keyword"select/span*,spanclass="code-string"'/spanspanclass="code-string"muslim'/spancol1,spanclass="code-string"'/spanspanclass="code-string"'/spancol2,spanclass="code-string"'/spanspanclass="code-string"'/spancol3spanclass="code-keyword"from/spantable1spanclass="code-keyword"where/spanreligion=spanclass="code-string"'/spanspanclass="code-string"muslim'/spanspanclass="code-keyword"union/spanspanclass="code-keyword"select/span*,spanclass="code-string"'/spanspanclass="code-string"'/spancol1,spanclass="code-string"'/spanspanclass="code-string"hindu'/spancol2,spanclass="code-string"'/spanspanclass="code-string"'/spancol3spanclass="code-keyword"from/spantable1spanclass="code-keyword"where/spanreligion=spanclass="code-string"'/spanspanclass="code-string"hindu'/spanspanclass="code-keyword"union/spanspanclass="code-keyword"select/span*,spanclass="code-string"'/spanspanclass="code-string"'/spancol1,spanclass="code-string"'/spanspanclass="code-string"'/spancol2,spanclass="code-string"'/spanspanclass="code-string"jain'/spancol3spanclass="code-keyword"from/spantable1spanclass="code-keyword"where/spanreligion=spanclass="code-string"'/spanspanclass="code-string"jain'/span/pre/code希望它帮助