Thanks Brian. That is exactly what I have decided. Your answer helps!

Neo

I am a "hunt and pecker". But amazingly I have improved over the years from one finger to one finger each hand .

Learning "typing" is still on...

I need to add the scenario.

I generate the script for this application and my clients install on their database servers. So, the question is not the password control but its...

That is right. A package in Oracle can contain more than one stored procedure and function. I guess you have the answer as you have already hinted about DTS package...

That works but with an addition of DESC

SELECT [name] FROM test ORDER BY (CASE WHEN [name] IS NULL THEN 1 ELSE 0 END) DESC, [name]

Thanks for your help.

NeoNash

I guess you doing a Force Restore, right?

Or is it something else.

Also, could you please post the code & error

Thanks,

NeoNash

Edited by - NeoNash on 04/23/2002 6:33:14 PM

Is it because the memory is shooting high? Are those four tables really huge?

Could you please post more details.

Thanks,

NeoNash

Henrik,

"Null" always appears at the top in SQLserver. If you have a solution to make it appear at the bottom of the list please let me know.

Thanks,

NeoNash

You are correct. Oracle is case-sensitive. That is why we have to be careful while developing applications which support both Oracle and SQLserver.

It is a good question. I act as both developer and DBA.

The main problem being a developer is that unrealistic target is provided and it is expected you to...

After logging into Query Analyzer make sure you are in the right database before issuing any query especially DDLs, and DMLs.

This is very true when the same user shares multiple...

It is 11 years I am working with database especially Oracle. After handling so much of problem with that I started working on SQLServer. It is been more than 3...

Or developers write queries anyway they want and expect you to make it fly.

NeoNash

"deleted" and "inserted" are not exact but equivalent to Oracle's :old and :new.

But both deleted and inserted are tables unlike :old and :new.

Wow! That helps.

Thanks Andy.

NeoNash