Shulou(Shulou.com)06/01 Report--

CREATE PROCEDURE [dbo]. [dxd_mx]

@ dxd_id VARCHAR 120 =''

AS

BEGIN

-- set nocount on

Declare @ sql1 nVARCHAR 4000

SET @ sql1='select * from (SELECT ROW_NUMBER () OVER (ORDER BY t1.n ASC) AS M1 AS * from (SELECT ROW_NUMBER () OVER (ORDER BY id DESC) AS n, ID,dxd_id, yqs,yhs,guanghao FROM lxcy_dxd_mx_v WHERE dxd_id='''+@dxd_id+''' or dxd_id='''') T1 WHERE n

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.