EDIT

That is not what I am saying because we are not talking about foreign key but DRI you can have a foreign key that is not DRI but to be...

Let me correct that the columns are renamed in the second table which was not really two identical columns.  Sorry about that.

Kind regards,

Gift Peddie

You can but you cannot use them in DRI because the columns participating in DRI is keeping track of each other in delete and update so your current table will...

To get DRI it must still be CompanyID and not CompanyID1 and CompanyID2 so just do ANSI SQL ALTER Table and change the column names to match because in DRI...

EDIT

Let me clear some confusion for you IDENTITY is a property and I could not see CompanyID or CompanyName in table two so your DRI(declarative referential integrity) is invalid.  Some of...

That is correct Numeric and Decimal is like Real and Float.

Kind regards,

Gift Peddie

The first time I saw Money's problems was 1999-2000 SQL Server 7.0 with Coldfusion front end Money was averaging 96-98 cents on the dollar, and the person was given less...

That is not correct you have to use Float if your application need math functions in most RDBMS(relational database management systems) MySQL included and not just for binary math. Let...

Float is usually used for money but converted to Decimal or Numeric to persist because in SQL Server you can set precision and scale in Decimal or Numeric and not...

That is correct but Joe Celko will make you understand it almost easy and Peter Gulutzan is also readable but Chris Date is very dry but very eye opening of the...

Let me use my current project as an example, some of my reports uses complex time components the reason we use Oracle on the Algebra end of the project because...

Views and Subqueries cannot be really compared, Views are compared to stored procs and Subqueries are compared to JOINs or UNION.  JOINs are the same in performance to Subqueries and...

That is correct SQL Server TimeStamp is a derived data type SQL Server uses internally so you need Java datetime to do conversion.  Hope this helps.

Kind regards,

Gift Peddie

 I take both DBA and Programmer contracts because I do data as ANSI SQL and relational Algebra.  I write ANSI SQL, Java in the...

Nope still exist albeit disabled by default.  And finally the account requirement is documented. 

http://msdn2.microsoft.com/en-us/library/ms175046.aspx

Kind regards,

Gift Peddie