SQL从其他表插入新表

发布于 2024-12-08 15:03:58 字数 227 浏览 8 评论 0原文

CREATE TABLE #Temporary
(
HoursThisYear int,
HoursLastYear int,
HoursBefore2010 int
)

INSERT 
INTO #Temporary (HoursThisYear)
SELECT SUM(Hours) WHEN Year = '2011' FROM WorkFlow

我对此很陌生,不确定我在做什么。

CREATE TABLE #Temporary
(
HoursThisYear int,
HoursLastYear int,
HoursBefore2010 int
)

INSERT 
INTO #Temporary (HoursThisYear)
SELECT SUM(Hours) WHEN Year = '2011' FROM WorkFlow

I am very new at this, and not sure what I am doing.

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

扫码二维码加入Web技术交流群

发布评论

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

评论(3

说谎友 2024-12-15 15:03:58

假设您正在寻找有关 INSERT 语法的帮助。

INSERT INTO #Temporary 
    (HoursThisYear)
    SELECT SUM(Hours) 
        FROM WorkFlow
        WHERE Year = '2011' 

Assuming you're looking for help on the INSERT syntax.

INSERT INTO #Temporary 
    (HoursThisYear)
    SELECT SUM(Hours) 
        FROM WorkFlow
        WHERE Year = '2011' 
浅浅淡淡 2024-12-15 15:03:58
CREATE TABLE #Temporary ( HoursThisYear int, HoursLastYear int, HoursBefore2010 int )

INSERT INTO #Temporary (HoursThisYear) 
    SELECT SUM(Hours) 
    FROM WorkFlow
    WHERE Year = '2011' 
CREATE TABLE #Temporary ( HoursThisYear int, HoursLastYear int, HoursBefore2010 int )

INSERT INTO #Temporary (HoursThisYear) 
    SELECT SUM(Hours) 
    FROM WorkFlow
    WHERE Year = '2011' 
不离久伴 2024-12-15 15:03:58

这应该有效

CREATE TABLE #Temporary
(
HoursThisYear int,
HoursLastYear int,
HoursBefore2010 int
)

INSERT 
INTO #Temporary (HoursThisYear)
SELECT SUM(Hours) 
FROM WorkFlow
WHERE Year = '2011'

this should work

CREATE TABLE #Temporary
(
HoursThisYear int,
HoursLastYear int,
HoursBefore2010 int
)

INSERT 
INTO #Temporary (HoursThisYear)
SELECT SUM(Hours) 
FROM WorkFlow
WHERE Year = '2011'
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文