Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding a Column using SQL_DMO Expand / Collapse
Author
Message
Posted Friday, February 8, 2002 12:00 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 11:48 AM
Points: 6,783, Visits: 1,879
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
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #2567
Posted Monday, February 11, 2002 6:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 9:05 AM
Points: 976, Visits: 59
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
Posted Monday, February 11, 2002 7:16 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: 2 days ago @ 8:57 AM
Points: 8,369, Visits: 736
Not as detailed as I would like. Usefull but needs to be broadened a bit.




Post #27911
Posted Monday, February 11, 2002 11:39 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 11:48 AM
Points: 6,783, Visits: 1,879
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
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #27912
Posted Monday, September 23, 2002 3:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 8:17 AM
Points: 298, Visits: 335
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
Posted Tuesday, July 15, 2003 1:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse