https://blog.youkuaiyun.com/ucfjeplzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/ucfjepl/article/details/6263617https://blog.youkuaiyun.com/ucfjepl/article/details/6263617ucfjeplSun, 20 Mar 2011 22:49:00 +0800select *   FROM View_VehicleContractInfo vci WITH(NOLOCK)
   LEFT JOIN AuctionVehicle av WITH(NOLOCK)
    ON vci.VehicleContractID = av.VehicleContractID
    AND av.AuctionID = (SELECT MAX(AuctionVehicle.AuctionID) FROM AuctionVehicle ]]>https://blog.youkuaiyun.com/ucfjepl/article/details/6053140https://blog.youkuaiyun.com/ucfjepl/article/details/6053140ucfjeplFri, 03 Dec 2010 15:43:00 +0800jsp中，让ie提示用户下载文件而不是直接打开，把报头设置为以下信息即可：response.setContentType("application/binary");//指明文件类型为二进制格式的文件。response.setHeader("Content-Disposition","attachment;filename=theFileName");//theFileName就是文件的完整名称，包括后缀名，因为这样，浏览器才会提示文件的类型图标和文件的完整名称。]]>