随机读取数据库中某条信息的SQL语句写法

来源:互联网 发布:淘宝ea凝胶有用吗 编辑:程序博客网 时间:2024/06/05 02:15

随机读取数据库中某条信息的SQL语句写法:以备日后使用!

SELECT     TOP (1) OBJECTID, DRAI_PUMP_ID, SYS_ID, DRAI_PUMP_NAME, DRAI_PUMP_TYPE, DRAI_PUMP_TYPE_FEAT, DRAI_PUMP_ADD,
                      DRAI_PUMP_PHONE, DRAI_PUMP_POST_CODE, DRAI_PUMP_STATE, RingRoad, DRAI_PUMP_COM_DSN, DRAI_PUMP_COM_BUILD,
                      DRAI_PUMP_COM_MNG, MaintainsUnit, FinishDate, RunDate, ReBuildDate, DRAI_PUMP_FLOW_DSN_Y, DRAI_PUMP_FLOW_DSN_W,
                      DRAI_PUMP_FLOW_FACT_Y, DRAI_PUMP_FLOW_FACT_W, DRAI_PUMP_POW_DSN_Y, DRAI_PUMP_POW_DSN_W, DRAI_PUMP_POW_FACT_Y,
                      DRAI_PUMP_POW_FACT_W, DRAI_PUMP_POW_SUM_Y, DRAI_PUMP_POW_SUM_W, DRAI_PUMP_LEVEL_DSN_Y, DRAI_PUMP_LEVEL_DSN_W,
                      DRAI_PUMP_LEVEL_MAX_Y, DRAI_PUMP_LEVEL_MAX_W, DRAI_PUMP_LEVEL_MIN_Y, DRAI_PUMP_LEVEL_MIN_W, DRAI_PUMP_AREA_USE,
                      DRAI_PUMP_PLAN, DRAI_PUMP_PROFILE, GrillPlatX, GrillPlatY, GrillPlatElev, GroundElev, DesRainstormReP, DesCoefficient, ServiceRange,
                      ServiceArea, DRAI_PUMP_TO_RIV, Outlet_Id, MapSheetId, IsUse, In_Com, In_Date, In_Use, VersionId, Remark, KEY_ID, Shape
FROM         sde.tDrai_Pump_St
ORDER BY NEWID()

原创粉丝点击