在进行联合查询判断等于的时候,发现判断text类型的字段会提示错误:
The data types varchar and text are incompatible in the equal to operator.
然后网上查询需要转换为varchar,
select cast(userID as varchar) from user
发现最多截取28个字符,因此需要加长度
cast(userID as varchar(max)) -- max进去相当于8000
在进行联合查询判断等于的时候,发现判断text类型的字段会提示错误:
The data types varchar and text are incompatible in the equal to operator.
然后网上查询需要转换为varchar,
select cast(userID as varchar) from user
发现最多截取28个字符,因此需要加长度
cast(userID as varchar(max)) -- max进去相当于8000