Adding a Column using SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Adding a Column using SQL_DMO

Adding a Column using SQL_DMO

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Friday, February 08, 2002 12:00 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/addingacolumnusingsql_dmo.asp>http://www.sqlservercentral.com/columnists/awarren/addingacolumnusingsql_dmo.asp

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #2567

Robert W Marda

Posted Monday, February 11, 2002 6:43 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 15, 2013 10:33 AM
Points: 976, Visits: 48

So where would I put this code so I can execute it? In a DTS task?

Robert Marda

Robert W. Marda
SQL Programmer
Ipreo

Post #27910

Antares686

Posted Monday, February 11, 2002 7:16 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

Not as detailed as I would like. Usefull but needs to be broadened a bit.

Post #27911

Andy Warren

Posted Monday, February 11, 2002 11:39 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Robert, I guess it would depend on what you were trying to do. Conceivably you could do it in a DTS package to create a table that matched your import file on the fly. Or in a user app that lets them add columns. Nothing special about doing it in DTS, you end up with the same result as if you did an alter table.

Antares, broadened in what direction?

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #27912

BobAtDBS

Posted Monday, September 23, 2002 3:18 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, October 10, 2011 2:00 PM
Points: 297, Visits: 329

Thanks for the ideas, Andy. It's pretty clear that we'll be using something like this as we make mods to our products. I'm not about to walk 400 something customers through EM to get a column added!

Student of SQL and Golf, Master of Neither

Student of SQL and Golf, Master of Neither

Post #27913

nctran

Posted Tuesday, July 15, 2003 1:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 28, 2008 5:46 PM
Points: 1, Visits: 4

Book online SQL-DMO did not explain how to insert Column into existing table. I searched everywhere to find some info but failed.

It would be very Nice if you can provide some Info about how to Insert Column using DMO

Thanks,

Post #27914

« Prev Topic | Next Topic »

Permissions