[DATABASE/SQLSERVER] 테이블 변수 사용하기

icodebroker SQLSERVER 2024-06-18

■ 테이블 변수를 사용하는 방법을 보여준다.

▶ 예제 코드 (SQL)


DECLARE @Table TABLE
(
    ID              INT           NOT NULL,
    Name            NVARCHAR(50)  NOT NULL,
    [Description]   NVARCHAR(MAX) NOT NULL,
    DateTimeCreated DATETIME      NOT NULL,
    CreatorID       INT           NOT NULL,
    DateTimeUpdated DATETIME      NOT NULL,
    UpdatorID       INT           NOT NULL
);

INSERT INTO @Table
SELECT *
FROM   Voyager.dbo.Code;

SELECT * FROM @Table;

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

DECLARE @Table TABLE

(

ID INT NOT NULL,

Name NVARCHAR(50) NOT NULL,

[Description] NVARCHAR(MAX) NOT NULL,

DateTimeCreated DATETIME NOT NULL,

CreatorID INT NOT NULL,

DateTimeUpdated DATETIME NOT NULL,

UpdatorID INT NOT NULL

);

INSERT INTO @Table

SELECT *

FROM Voyager.dbo.Code;

SELECT * FROM @Table;