Posted by Erland Sommarskog on 04/18/06 01:42

ProgrammerGal (carolyn_graf@ahm.honda.com) writes:
> My delete statement ??? -- cant quite figure out the syntax of this
> one....
> select * from openquery([LinkedServer], 'delete from NotesTable') where
> lastName='Smith'
> (this doesnt work)

DELETE LinkedServer...NotesTable

You may need something between the dots as well, but I don't know Lotus
Notes.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Time Over 24 Hours
• Prev in forum: delete sql syntax for linked notes table
• Thread view: Re: delete sql syntax for linked notes table

[Reply to this message]