Alter table command ignored, Why? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Alter table command ignored, Why?

Message

From

08/04/2002 11:13:08

Michael Levy
Cincinnati, Ohio, United States

To

08/04/2002 10:41:37

Darren Ramsay
Gerrity Computers
Concord, Ontario, Canada

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Alter table command ignored, Why?

Miscellaneous

Thread ID:

00642194

Message ID:

00642219

Views:

25

You should be able to do the copy with just the INSERT..SELECT. Of course, you'll have to list the explicit columns.

INSERT INTO mytable (
c1,
c2,
c3)
SELECT
c1,
@newC2,
c3
FROM
mytable
WHERE
c2 = somevalue

-Mike

Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com

Click here to load this message in the networking platform