select top 1 title,url from postInfo where patindex(
(select id from VirtualUser where MemberId = (select id from Member where name = '032576')),VirtualUserName)
order by id desc错误:
消息 4145,级别 15,状态 1,第 1 行
在应使用条件的上下文(在 'order' 附近)中指定了非布尔类型的表达式。
(select id from VirtualUser where MemberId = (select id from Member where name = '032576')),VirtualUserName)
order by id desc错误:
消息 4145,级别 15,状态 1,第 1 行
在应使用条件的上下文(在 'order' 附近)中指定了非布尔类型的表达式。
(select id from VirtualUser
where MemberId = (select id from Member where name = '032576')),VirtualUserName)=true
order by id desc
(select id from VirtualUser
where MemberId = (select id from Member where name = '032576')),VirtualUserName)=1
order by id desc
select top 1 title,url from postInfo where patindex in(
(select id from VirtualUser where MemberId = (select id from Member where name = '032576')),VirtualUserName)
order by id desc
(select id from VirtualUser
where MemberId = (select id from Member where name = '032576')),VirtualUserName)=1
order by id desc
返回指定表达式中某模式第一次出现的起始位置;如果在全部有效的文本和字符数据类型中没有找到该模式,则返回零。
语法
PATINDEX ( '%pattern%' , expression )
参数
pattern
一个字符串。可以使用通配符,但 pattern 之前和之后必须有 % 字符(搜索第一个和最后一个字符时除外)。pattern 是短字符数据类型类别的表达式。
expression
一个表达式,通常为要在其中搜索指定模式的列,expression 为字符串数据类型类别。
返回类型
int
PATINDEX 是有返回值的。。http://yangze.javaeye.com/blog/606468
(select id from VirtualUser where MemberId = (select id from Member where name = '032576')),VirtualUserName) = 1
order by id desc
没有就是0