使用字符串的Sql Server IN子句 [英] Sql Server IN Clause using string

问题描述

How to remove single Quote from given select Query. It is give me Converstion failed when converting the varchar value '1,2,3' to data type int.

SELECT * FROM Member
WHERe MemberId IN ('1,2,3')

推荐答案

解决了这里，

数据类型转换问题 [ ^ ]



I一年前被问到同样的问题;）

Solved here,
data type converting issue[^]

I was asked the same question a year ago ;)

这篇关于使用字符串的Sql Server IN子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！