set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER procedure [dbo].[proc_GetStoreBoxProductsForOther] @userid int as begin select storeid,shopid,shopname,canusetimes,unit,shopprice,isattach, istime,displaypic,flashdir,iwidth,iheight,iszorz,typeid,displaymode, userid,operation,oriposition,cemeteryid,displayout,isvipbuy from view_storeandstorezheuangzhi where userid=@userid and usingout=0 and parentid<=0 and ((heavenid in ( select [cemeterysid] from [cemeterys] where [userid]=@userid)) or (heavenid= '-1' or heavenid= '' )) end view_storeandstorezheuangzhi --为视图 |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步