开发者

SQL Server 2000 pivot without temporary tables?

I'm trying to pivot some data in SQL Server 2000, but the user that runs开发者_如何转开发 the application only have read/write permissions. I've looked the solutions posted here, but all involving create/destroy temporary tables.


I think you may be a bit confused as to what temporary tables are.

You should be able to create a temp table (in memory) within your SQL statement. No extra permissions are necessary.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜