那一天我二十一岁，在我一生的黄金时代。我有好多奢望。我想爱，想吃，还想在一瞬间变成天上半明半暗的云。后来我才知道，生活就是个缓慢受锤的过程，人一天天老下去，奢望也一天天消失，最后变得像挨了锤的牛一样。可是我过二十一岁生日时没有预见到这一点。我觉得自己会永远生猛下去，什么也锤不了我
posted @ 2010-05-11 18:21 duwamish 阅读(20) 评论(0) 编辑
代码
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()
posted @ 2010-05-11 13:50 duwamish 阅读(8) 评论(0) 编辑