我正在尝试将
MySQL查询转换为MsSql查询,但我遇到了麻烦.这是我的查询:
MySQL的
SELECT *,
(SELECT count(books.id)
FROM books
WHERE books.status = 1
AND FIND_IN_SET(categories.id, books.multiple_category_id)) AS book_count
FROM categories, books
WHERE categories.parent_id=0
AND categories.status=1 ;
SQL我试过了
SELECT *,
(SELECT count(books.id)
FROM books
WHERE books.status = 1
AND CHARINDEX(categories.id, books.multiple_category_id) > 0) AS book_count
FROM categories, books
WHERE categories.parent_id=0
AND categories.status=1 ;
我得到的错误是:
Argument data type int is invalid for argument 1 of charindex function.
有没有人有任何想法?
提前致谢!