임시 테이블 사용


Declare @sTable table
( nIndex int
, sName varchar(16)
, sID varchar(16))

Insert @Table values(1,'1','1')
Insert @Table values(2,'2','2')
Insert @Table values(3,'3','3')
Insert @Table values(4,'4','4')
Insert @Table values(5,'5','5')

--values=&gt;
--Select*
--From sTest
--Where Index = 45

Select *
From @sTable

Declare @sTable table

( nIndex int

, sName varchar(16)

, sID varchar(16))

Insert @Table values(1,'1','1')

Insert @Table values(2,'2','2')

Insert @Table values(3,'3','3')

Insert @Table values(4,'4','4')

Insert @Table values(5,'5','5')

--values=>

--Select*

--From sTest

--Where Index = 45

Select *

From @sTable