No, I don't have such a procedure. I meant a single proc for each operation for *each* table. Otherwise you're into dynamic sql as you can read here: http://www.sommarskog.se/dynamic_sql.html

SP's can have default values for parameters. They can't have optional parameters. If I were you, I would rather do some more typing and have a single dedicated proc for...

OK, problem solved, but is there any other way to do this without UDF's?? Without temp tables?

Yes, do this at the client.

Since your question is not very specific, as a starter you might want to read BOL for CREATE TABLE. There is a whole chapter on temporary tables.

When you search BOL for "extended stored procedures" you'll find a basic example. In addition, this might be interesting. http://www.codeproject.com/database/xp_md5.asp

Here is a good example how to deal safely with these "global variables" in general.

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

In case if @@IDENTITY you might want to read up BOL for IDENT_CURRENT why...

That would also be a start, but to have some additional information about your system wouldn't be bad at all.

I've dropped you a PM.

Yes, everything in Oracle is bigger. Installation on 2 CD's and about 1.1 GB. Amount of RAM stolen and...

Can you give more information about the population process? Single INSERT or BULK? How many rows? What frequency? OLAP or OLTP? ....

See if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

I have collected some links that helped me getting started here:

http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/catid,47/

As for training: well, almost each training provider who offers MS certifications also offers Oracle certification courses.

At Oracle's...

Say if i build my mdf database in SQL server developer edition, load data, test data, run queries. Then send the mdf and log file to a server that has...

See if this helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Thanks for the explanation, Joe.

Not that I as a German deal terribly much with SSN, however as it is quite often mentioned it's...

ACH! du lieber!

Ach, du lieber Himmel or Ach, du meine Güte or something like that.

Hey, I appreciate it when someone tries my mother tongue

http://www.yohz.com offers a free QA like tool. Another one would be myLittleAdmin. I can't comment on both, because I don't use them.