大尾巴狼

所谓大尾巴狼,就是装腔作势。

只返回DB架构信息

SET NO_BROWSETABLE ON is an undocumented option performed for Remote Data Service (RDS) ActiveX Data Connector (ADC) connections to SQL Server. Enabling this option makes every SELECT statement act as though FOR BROWSE had been appended to the statement, but bypasses the temporary table that FOR BROWSE normally pipes the results through. The net effect is to add keys and timestamps to the query as hidden output columns so the client can update specific rows (updateable cursors) without separate trips to the server to pick up the meta-data and munging the query to get the appropriate columns.

 SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;select * from sb_channel SET FMTONLY OFF; SET NO_BROWSETABLE OFF;

posted on 2005-10-14 13:43  大尾巴狼  阅读(917)  评论(0编辑  收藏  举报

导航