Oh yeah. The Insert Into, Select blah is the bees knees!
One of my faves. :)
On Wed, Dec 1, 2010 at 1:20 PM, Judah McAuley wrote:
>
> Yeah, that's essentially the same thing as the other bulk insert syntax:
>
> INSERT INTO Table (X)
> SELECT (Y) FROM OtherTable
>
> Handy stuff on occasion.
>
>
Yeah, that's essentially the same thing as the other bulk insert syntax:
INSERT INTO Table (X)
SELECT (Y) FROM OtherTable
Handy stuff on occasion.
Judah
On Wed, Dec 1, 2010 at 9:22 AM, G Money wrote:
>
> When inserting multiple rows of literal data, instead of:
>
> INSERT INTO Table (X) VALUE
i had no idea... nice!
On Wed, Dec 1, 2010 at 12:22 PM, G Money wrote:
>
> When inserting multiple rows of literal data, instead of:
>
> INSERT INTO Table (X) VALUES (1);
> INSERT INTO Table (X) VALUES (2);
> Etc, Etc
>
> You can just do:
>
> INSERT INTO Table (X) VALUES (1), (2), Etc, Etc..
When inserting multiple rows of literal data, instead of:
INSERT INTO Table (X) VALUES (1);
INSERT INTO Table (X) VALUES (2);
Etc, Etc
You can just do:
INSERT INTO Table (X) VALUES (1), (2), Etc, Etc.
I learn new things every day, but rarely shortcuts that are this basic!
Anyway, you
