newid()

最新推荐文章于 2024-08-14 07:03:06 发布

weixin_30790841

最新推荐文章于 2024-08-14 07:03:06 发布

阅读量112

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/duwamish/archive/2010/05/11/1732556.html

代码

select   top   5   *   from   ItemProfileCommonInfo   order   by   newid()

set statistics profile on
SET NOCOUNT ON;
select  top 6   a.[name],a.description,a.categoryid from dbo.ItemProfileCommonInfo a with(nolock)
where  a.Editdate>(getdate() -100) and  a.categoryid in (select categoryid from ItemCategory with(nolock) where description like N'%%'
or description like N'%%')
order by newid()

select  top 6   a.itemcode,a.[description],b.PriceFinal,a.ImageNameFull from ItemProfileCommonInfo a with(nolock)
join ItemProfilePriceSetting b with(nolock) on a.itemcode=b.itemcode
where  a.Editdate>(getdate() -100) and  a.categoryid in (select categoryid from ItemCategory with(nolock) where description like N'%%'
or description like N'%%')
order by newid()

转载于:https://www.cnblogs.com/duwamish/archive/2010/05/11/1732556.html