SQL 2000 - DRVTBL？

发布于 2024-07-30 08:35:17 字数 163 浏览 3 评论 0原文

我正在尝试了解我需要修复的历史存储过程。我找到了这个DRVTBL关键字，但我不知道它是什么意思？？？（这是sql2000数据库）

SELECT ...
FROM (      
      ...)
) DRVTBL

原文

I'm trying to understand a historical stored procedure I need to fix.
I found this DRVTBL key word, and I couldn’t find out what it means???
(This is a sql2000 database)

SELECT ...
FROM (      
      ...)
) DRVTBL

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

む无字情书 2024-08-06 08:35:18

从您发布的查询来看，DRVTBL 看起来像一个别名。其工作方式类似于 T-SQL 查询中的临时表。 SQL Server 2005 有此功能的高级版本，称为公用表表达式< /a>.

示例 -

SELECT *
FROM
    (
        SELECT
            Id,
            Name
        FROM Employee
        WHERE Name LIKE 'A%'
    ) EmployeeA
WHERE EmployeeA.Name = 'Albert'

这将创建一个别名表，其中包含名称以 A 开头的所有 Employee，而外部查询将依次选择名称为 <代码>阿尔伯特。

使用 CTE 可以将其写为 -

WITH EmployeeA AS
(
    SELECT
        Id,
        Name
    FROM Employee
    WHERE Name LIKE 'A%'

)
SELECT * FROM EmployeeA WHERE EmployeeA.Name = 'Albert'

DRVTBL, from the query you have posted, looks like an alias. The work like temporary tables in your T-SQL Query. SQL Server 2005 has a little bit advanced version of this functionality, called Common Table Expressions.

An example -

SELECT *
FROM
    (
        SELECT
            Id,
            Name
        FROM Employee
        WHERE Name LIKE 'A%'
    ) EmployeeA
WHERE EmployeeA.Name = 'Albert'

This will create an aliased table containing all the Employees whose name starts with A, and the outer query will, in turn, select the employees with the name Albert.

Same can be written using CTE as -

WITH EmployeeA AS
(
    SELECT
        Id,
        Name
    FROM Employee
    WHERE Name LIKE 'A%'

)
SELECT * FROM EmployeeA WHERE EmployeeA.Name = 'Albert'

回复收藏 0 原文