•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,851 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,115 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 11464 | Replies: 1
 |
•
•
Join Date: Feb 2005
Posts: 175
Reputation: 
Rep Power: 4
Solved Threads: 5
Junior Poster
I'm trying to populate a table from a sub-query.
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,
Any suggestions is greatly appreciated.
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,
SELECT [Customer Id] INTO test FROM [Customers]
Any suggestions is greatly appreciated.
Save White Tiger
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Problem with MySQL Query (Database Design)
- updating a database (ASP.NET)
- Controlling GridView with a ListBox(multible selections enabled) (ASP.NET)
- Trying to return query results (ColdFusion)
- help!! update mysql problem (MySQL)
- Access INSERT problem (MS Access and FileMaker Pro)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- ADO data control problem (Visual Basic 4 / 5 / 6)
Other Threads in the MS SQL Forum
- Previous Thread: sql*plus or pl/sql question
- Next Thread: Help with a stored procedure
