MS SQL

INSERT CLAUSE using SUB-QUERY

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Feb 2005

Posts: 175

Reputation: Letscode is an unknown quantity at this point

Solved Threads: 6

Letscode

Offline

Junior Poster

INSERT CLAUSE using SUB-QUERY

Oct 18th, 2005

I'm trying to populate a table from a sub-query.

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
CREATE TABLE test
(
ID int
)
 
 
INSERT INTO test
VALUES (SELECT [Customer Id] 
FROM   [Customers])
CREATE TABLE test
(
ID int
)


INSERT INTO test
VALUES (SELECT [Customer Id] 
FROM   [Customers])

QUESTION:
I know you can do this in ORACLE but Is something like this possible in T-SQL.

I can also write something like this in SQL which achieves the same result but I will lose the datatype,

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT [Customer Id] 
INTO test
FROM   [Customers]
SELECT [Customer Id] 
INTO test
FROM   [Customers]