Use a T-SQL variable:

   declare @r int

   set @r = 5678

   select * from reg where regis = @r

Or use a template script in Query Analyzer:

   select * from reg

  ...

DTS will not make up table names at random, it will put the data in the table you've designed it to use.  (I know, you can use an ActiveX script...

SQL Server does not maintain individual creation dates for columns, just for the table.

I assume you mean another filegroup?  If there all multiple files in the same filegroup the table will be spread across all of them.  To control filegroup placement you just...

An index scan is not always bad.  If you're retreiving a large fraction of the table, an index scan feeding into a merge join would be faster than a loop...

Assuming you're content with keeping the table1 rows where there is a table2 duplicate, exclude the matching records from the second part of the union:

select * from table1

union

select * from table2 t2

where...

Part of your question was "What is the difference?"

An exact numeric type (money, smallmoney, decimal, numeric) stores an exact representation of a decimal number by storing each digit separately.

An approximate...

Why not just go ahead and do the update first, it will only affect existing records with matching PartNumberID.

Then insert the remaining records with something like this:

insert into table (...)

select tbl1.fld1, tbl1.fld2,...

Try this:

select

a,b,c,x01,y01,z01