Re: Insert blocks of data into a table
From: Narayana Vyas Kondreddi <answer_me_at_hotmail.com>
Date: Mon, 24 Sep 2001 11:51:09 +0530
Message-ID: <xdAr7.511$YP.17857_at_news.cpqcorp.net>
Date: Mon, 24 Sep 2001 11:51:09 +0530
Message-ID: <xdAr7.511$YP.17857_at_news.cpqcorp.net>
Yes you can, as long as the table DDL of Table1 and Table2 are same, otherwise you will have to include a column list in INSERT and SELECT statements.
-- HTH, Vyas SQL Server FAQ, articles, code samples, best practices, interview questions and much more _at_ http://vyaskn.tripod.com/ Alan <alanpltse_at_yahoo.com.au> wrote in message news:9njsfg$7j9$1_at_merki.connect.com.au...Received on Mon Sep 24 2001 - 08:21:09 CEST
> Can I use the following command:
>
> Insert into Table1
> Select * from Table2 where Table2.Field1 = '123'
>
> Note: the select statement return more than 1 row
>
>