p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_language thread: Re: altering multiple columns


Message #1 by jjboja@h... on Wed, 6 Mar 2002 19:03:39
Thanks Jay,

If documentation states that, the only thing left to do is to write my own 
code, and ask Microsoft to implement this in their next updates.

For all other intents and purposes (unless anyone has other ideas), this 
thread is closed.

Thanks to all,

JJ


>From: "Jay Turner" <jayt@c...>
>Reply-To: "sql language" <sql_language@p...>
>To: "sql language" <sql_language@p...>
>Subject: [sql_language] Re: altering multiple columns
>Date: Wed, 6 Mar 2002 19:44:56 -0800
>
>I looked at the documentation, you can only do one alter at a time using
>transact SQL.
>
> > -----Original Message-----
> > From: JJ Boja [mailto:jjboja@h...]
> > Sent: Wednesday, March 06, 2002 11:40 AM
> > To: sql language
> > Subject: [sql_language] Re: altering multiple columns
> >
> > Thank you Denis,
> >
> > I was afraid that it is true, and this is exactly what I have done,
>but
> > hope
> > for a better solution still exists...
> >
> > JJ
> >
> >
> > >From: "Denis Gobo" <dgobo@w...>
> > >Reply-To: "sql language" <sql_language@p...>
> > >To: "sql language" <sql_language@p...>
> > >Subject: [sql_language] Re: altering multiple columns
> > >Date: Wed, 6 Mar 2002 14:15:01 -0500
> > >
> > >ALTER TABLE table_name
> > >ALTER COLUMN column_1 int
> > >
> > >ALTER TABLE table_name
> > >ALTER COLUMN column_2 varchar(20)
> > >
> > >ALTER TABLE table_name
> > >ALTER COLUMN column_3 float
> > >
> > >Looks like you need an alter statement for every column
> >
> > _________________________________________________________________
> > Join the world's largest e-mail service with MSN Hotmail.
> > http://www.hotmail.com
> >
> >
> > to unsubscribe send a blank email to leave-sql_language-
> > 792625D@p...
>
>
>
>$subst('Email.Unsub').




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


  Return to Index