With this new feautre, the client driver transparently retrieves data in large chunks so that application requests are satisfied without a round trip to the server (like a server cursor).
有了这个新特性,客户机驱动器透明地检索大块的数据以满足应用程序请求,而无需往返服务器(比如服务器游标)。
Say you come in one day and see a cursor moving independently or find packaged files of user data moved to the FTP server.
假设您某一天发现光标不受控制地移动,或者发现用户数据的打包文件被移动到FTP服务器。
Instead of using a cursor to iterate over the results, you can use the pivot functionality in SQL Server 2005.
您可以使用SQL Server 2005中的枢轴功能而不是游标来循环访问结果。
应用推荐