开发者

Is It possible to Transpose Unlimited rows into column using PIVOT in SQL Server?

Is It possible to Transpose Unlimited rows into colu开发者_运维知识库mn through PIVOT in SQL Server? if YES then How? I need because i have huge number of cities in table so i can't add all cities in FOR City IN of PIVOT.


Is It possible to convert Unlimited rows into column through PIVOT in SQL Server?

No. You can have max 4,096 columns in a select statement. http://msdn.microsoft.com/en-us/library/ms143432.aspx

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜