22,300
社区成员




SELECT wordID,keyword,totalCount,monthCount,createTime,
ROW_NUMBER() OVER(ORDER BY monthCount DESC) POS
FROM TSM_SearchWord
WHERE 1= 1
---以下条件可以作为一个整体字符串动态拼接传递进来
and col1=isnull(@col1,col1)
and col2=isnull(@col2,col2)
或者
and isnull(col1,'9999')=isnull(@col1,isnull(col1,'9999'))