[dba-SQLServer] SQL Server linked to Teradata

Thanks,

 

I have those...its just the CREATE and DROP syntax I can't seem to find.

 

Thanks,

 

Mark
 
> Date: Tue, 24 Mar 2009 11:01:18 -0700
> From: fhtapia at gmail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] SQL Server linked to Teradata
> 
> Sorry, it's generally used as
> SELECT * FROM OPENQUERY(LinkServer, 'Select Field From Table')
> 
> or for Inserts
> 
> INSERT OPENQUERY(LinkServer, 'Select Field From Table')
> Values('Value')
> 
> DELETE OPENQUERY(LinkServer, 'Select Field From Table')
> 
> Etc...
> -Francisco
> http://sqlthis.blogspot.com | Tsql and More...
> 
> 
> On Tue, Mar 24, 2009 at 10:47 AM, Mark A Matte <markamatte at hotmail.com>wrote:
> 
> >
> > Thanks Francisco,
> >
> >
> >
> > I get an error (from SQL Server) "Incorrect syntax near 'OpenQuery'"
> >
> > when I use: OpenQuery(LinkedServerName, 'Drop Table TableName')
> >
> >
> >
> > Any ideas?
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Mark
> >
> >
> >
> > > Date: Tue, 24 Mar 2009 10:24:10 -0700
> > > From: fhtapia at gmail.com
> > > To: dba-sqlserver at databaseadvisors.com
> > > Subject: Re: [dba-SQLServer] SQL Server linked to Teradata
> > >
> > > you should be able to execute any number of the Teradata's commands by
> > > issuing the command via OpenQuery
> > > It will be constructed as such: OpenQuery(LinkedServerName, 'Drop Table
> > > TableName') or what ever the command is for TeraData (sorry I am not as
> > > familiar with this engine so I cannot help).
> > >
> > >
> > >
> > > -Francisco
> > > http://sqlthis.blogspot.com | Tsql and More...
> > >
> > >
> > > On Tue, Mar 24, 2009 at 7:25 AM, Mark A Matte <markamatte at hotmail.com
> > >wrote:
> > >
> > > >
> > > >
> > > > Hello All,
> > > >
> > > >
> > > >
> > > > I have successfully linked SQL Server2005 to Teradata. I can pull data
> > > > from...and insert records into Teradata.
> > > >
> > > >
> > > >
> > > > I have NOT been able to create or drop a table in Teradata from SQL
> > Server.
> > > >
> > > >
> > > >
> > > > Can anyone help with syntax ( or if even possible)...or what
> > approach???
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > >
> > > >
> > > > Mark A. Matte
> > > >
> > > > _________________________________________________________________
> > > > Internet Explorer 8 – Now Available. Faster, safer, easier.
> > > > http://clk.atdmt.com/MRT/go/141323790/direct/01/
> > > > _______________________________________________
> > > > dba-SQLServer mailing list
> > > > dba-SQLServer at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > > http://www.databaseadvisors.com
> > > >
> > > >
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> >
> > _________________________________________________________________
> > Express your personality in color! Preview and select themes for Hotmail®.
> >
> > http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=TXT_MSGTX_WL_HM_express_032009#colortheme
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 

_________________________________________________________________
Internet Explorer 8 – Now Available. Faster, safer, easier.
http://clk.atdmt.com/MRT/go/141323790/direct/01/