I totally agree with that.. Microsoft should put a big flashing sign that it's copying/deleting all the content of the table underneath it all.

But then again why would DBAS exists...

could this do the job (never worked with 65 compatibility)

CREATE FUNCTION [dbo].[fnReplace] (@String as varchar(8000), @Search as char(1), @Replace as varchar(1))

RETURNS varchar(8000) AS

BEGIN

Declare @i as...

Hehe didn't see that one comming 🙂

DECLARE @datestring varchar(8)

No offense Guus Kramer but why not use enterprise manager if you're gonna do it the same way it does it but without the User interface?? Other than can...

I'm not expert at non-equal joins and I jut can't see the problem.. hopefully somebody else will find the solution.

Good luck.

can you post the table data along with the expected results and the current results so we can work out the join?

Been there, done that... it's always so simple once you have the solution 🙂

If I understand correctly you problem, I think it's pretty much the same probleme as trying to save an image in the DB. I think what you need is...

Can't you simply merge the 2 logics?? >>

Insert into a (key1,key2,data) (Select Key1, Key2, data from tblB B where not exists (Select * from a A where A.key1 = B.Key1...

Good.. I just wish I had had an Oracle server to do some tests.. would have saved us a lot of typing :-).

I think I got you mixed up. OPENROWSET can be used in two ways :

in the first exemple I showed you I used all the information required to setup...

I think it's surprising they don't have a lot more... think about how many GB of text they published over the years... if only their software had so few...

Antares686.. on a more serious note, it is forbidden to use raiserror in a UDF. I however found a nice workaround :

CREATE FUNCTION [dbo].[fnTest] ()

RETURNS int...

Not that's normal. What it means is that the syntaxe in your query is wrong. Have you tried my query in the previous message?

I also thaught you could...

I think the first thing to do is to see if the link to oracle is working. In entreprise manager open the server where you added the linked server,...