DavidYun

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理
  43 随笔 :: 0 文章 :: 6 评论 :: 15万 阅读
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  --为视图

  

posted on   David.Yun  阅读(781)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示