sql 中的 =* 运算符 [英] =* operator in sql

问题描述

我正在打字，手指很胖，当我打字时

I was typing along and fat finger something and when I typed

=*

在 sql 窗口中(2008 SSMS 连接到 2005 服务器)它变成蓝色作为关键字.

in the sql window (2008 SSMS connected to a 2005 server) it turned blue as a keyword.

我无法弄清楚或谷歌，这是做什么的.我知道 *= 但不知道 =*

I can not figure out, or google, what this does. I know *= but not =*

这个运算符是做什么的?

What does this operator do?

推荐答案

=* 是编写右外连接的旧方法.例如:

=* is an old way to write right outer joins. For example:

select  *
from    A
right outer join
        B
on      A.bid = B.id

以旧样式编写，例如:

select  *
from    A
,       B
where   A.bid =* B.id

这篇关于sql 中的 =* 运算符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！