RSS

INSERT CLAUSE using SUB-QUERY

Please support our MS SQL advertiser: Programming Forums

INSERT CLAUSE using SUB-QUERY

•

Join Date: Feb 2005

Posts: 175

Reputation: Letscode is an unknown quantity at this point

Rep Power: 4

Solved Threads: 5

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

(Toggle Plain Text)

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

(Toggle Plain Text)

SELECT [Customer Id] 
INTO test
FROM   [Customers]

Any suggestions is greatly appreciated.

Save White Tiger

DaniWeb Home > Forums > Web Development > Databases > MS SQL > INSERT CLAUSE using...

INSERT CLAUSE using SUB-QUERY

INSERT CLAUSE using SUB-QUERY

INSERT CLAUSE using SUB-QUERY