sql - SQL Server 2012中的LEFT OUTER JOIN的SQL语法

由于缺少对*=（LEFT OUTER JOIN）运算符的支持，我们在SQL Server 2012中遇到问题。

谁能告诉我以下在SQL Server 2008上正常运行的SQL的SQL Server 2012正确语法是什么？

SELECT
    t7410.name, t7408.type, t7410.length,
    t7410.status, t7410.prec, t7410.scale,
    t7409.type
FROM
    dbo.syscolumns t7410, dbo.systypes t7408,
    dbo.sysobjects t7409, dbo.sysusers t7411,
    master.dbo.syslogins t7412
WHERE
    t7410.id = t7409.id
    AND t7411.uid = t7409.uid
    AND t7409.name = 'GENERAL'
    AND t7409.type IN ('U', 'S', 'V')
    AND t7410.usertype *= t7408.usertype
    AND t7412.sid = t7411.sid
    AND t7412.name = user_name()
ORDER BY
    t7410.colid ASC

最佳答案

为什么不使用ANSI JOIN语法编写此代码：

SELECT t7410.name, t7408.type, t7410.length,
    t7410.status, t7410.prec, t7410.scale,
    t7409.type
FROM dbo.syscolumns t7410
INNER JOIN dbo.sysobjects t7409
    ON t7410.id = t7409.id
INNER JOIN dbo.sysusers t7411
    ON t7411.uid = t7409.uid
INNER JOIN master.dbo.syslogins t7412
    ON t7412.sid = t7411.sid
LEFT JOIN dbo.systypes t7408
    ON t7410.usertype = t7408.usertype
WHERE t7409.name = 'GENERAL'
    AND t7409.type IN ('U', 'S', 'V')
    AND t7412.name = user_name()
ORDER BY t7410.colid ASC