抱错:参数数据类型 ntext 对于 len 函数的参数 1 无效
SELECT u.UserName, u.RealName, g.GroupID, g.GroupName, g.UserIDs, g.UserNames, g.ModuleID, g.ReMark
FROM dbo.T_UserGroup AS g INNER JOIN
dbo.T_User AS u ON u.UserID IN (SUBSTRING(g.UserIDs, 2, LEN(g.UserIDs) - (LEN(g.UserIDs) - 2)))
g.UserIDs 是Ntext类型的, Len()方法不支持
要把g.UserIDs 转化成Varchar 如何做?
SELECT u.UserName, u.RealName, g.GroupID, g.GroupName, g.UserIDs, g.UserNames, g.ModuleID, g.ReMark
FROM dbo.T_UserGroup AS g INNER JOIN
dbo.T_User AS u ON u.UserID IN (SUBSTRING(g.UserIDs, 2, LEN(g.UserIDs) - (LEN(g.UserIDs) - 2)))
g.UserIDs 是Ntext类型的, Len()方法不支持
要把g.UserIDs 转化成Varchar 如何做?
SELECT DATALENGTH('DDD')
--3