update share set wx_cont_url='http://weilian.creatrue.net/aspx/NewsInfo.aspx?id='+cast(share.id as varchar(50)) where wx_cont_url is null
select top 1 ROW_NUMBER() OVER (ORDER BY id desc) as rownumber, * from [dbo].[advertisement] where vipid=2 order By NewID()--随机获得一条广告