62,046
社区成员
发帖
与我相关
我的任务
分享
string query=string.Format("UPDATE [BuildNetHouse].[dbo].[Keyword] SET [Count] =isnull([Count],0) + 1 WHERE id in (SELECT TOP 5 dbo.Keyword.ID FROM Keyword WHERE 1=1 {0} order by dbo.Keyword.Placeholder desc {1})",Where,OrderBy1)
UPDATE [BuildNetHouse].[dbo].[Keyword]
SET [Count] = CASE WHEN [Count] IS NULL THEN 1 ELSE [Count]+1 END
WHERE id in (SELECT TOP 5 dbo.Keyword.ID
FROM Keyword
WHERE 1=1 '+@Where+'
order by dbo.Keyword.Placeholder desc '+@OrderBy1+')
不知道是不是这个意思?楼主是不是应该把count字段设默认值为0啊?