Posted by Erland Sommarskog on 10/02/79 11:53

(dwightsmail@gmail.com) writes:
> I am getting close to understanding that, but how do I take the
> consequence and control table information with the hazard insert? Will
> the related consequences be inserted with the 'Fog'?

I'm not sure that I understand the question. But it's not that if you
enter a row in Hazards, that there automatically will be a row in
Consequences as consequences. Unless, that is you set up a trigger. But
since the consequence data need more data, that is not really meaningful.

Some people prefer to use the Open Table functionality that is in
Enterprise Manager or SQL Server Management Studio where you can enter
data in a grid. Personally, I find that about slower than typing up a
number of INSERT statments with help of some copy-and-paste skills.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Scripting table with rows values
• Prev in forum: Text Import Finding Table to Import to Problem
• Thread view: Re: query to populate child table

[Reply to this message]