set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER procedure [dbo].[proc_GetStoreBoxProductsForOther]@userid intasbeginselect storeid,shopid,shopname,canusetimes,unit,shopprice,isattach,istime,displaypic,flashdir,iwidth,iheight,iszorz,typeid,displaymode,userid,operation,oriposition,cemeteryid,displayout,isvipbuy fromview_storeandstorezheuangzhi whereuserid=@userid andusingout=0andparentid<=0and((heavenid in (select [cemeterysid] from [cemeterys] where [userid]=@userid)) or (heavenid='-1' or heavenid=''))end view_storeandstorezheuangzhi  --为视图