Recent content by Timcwilcox

Thanks for the help, the problem is i can use query analyser as it is an application that needs to be able to share the table. What i wanted to know is can i share a table so that multiple database can use it. DTP is no good as it has to be online. However i will investigate using triggers if...

Can i share tables on two or more databases on SQL 2000. I have looked in various documentation, and apart from using replication (which i do not beleive will resolve this) i cant see how to do it.

Please forgive my ignorance, but can someone post a solution for a very simple problem for a Oracle sql newbie. I have a transaction table (call it stock_trans) and a stock master table (call is stock) and one of the fields on the stock transaction table is a cost price. Is there a sql script...

Thanks for your help guys, just starting out with MSQL and NT. Previous used UNIX+INFORMIX, but times are a changing. I Think we can kill this thread now, as i have working triggers.

Thanks for this, however when the update trigger executes, it deletes all the rows from TABLE2 and then inserts the Updated row.

I have two tables TABLE1 and TABLE2, TABLE2 is a copy of TABLE1 and needs to be maintained. I am using the trigger below CREATE TRIGGER INSERT01 ON TABLE1 FOR INSERT AS INSERT INTO TABLE2 SELECT * FROM INSERTED GO CREATE TRIGGER DELETE01 ON TABLE1 FOR DELETE AS DELETE FROM TABLE2 SELECT *...

I have a SQL server table that i am not allowed to alter (call it stock), so i want to maintain another table with the same schema initially, but this schema will change in time (call it NewStock). The problem is i want to solve is when information is added, updated or removed from Stock, i...

I have a SQL table with a VARCHAR element that contains a number, i want to read this with a convert(numeric) statement, but it stops the SQL script when it reaches a value that is not numeric. How can i get the SQL script to wither skip past the data item, or use zero?

Thanks for the info, but perhaps i should have said that the machines are not linked which is why i want to generate the sql scripts.

On SQL7 and Informix you can use commands that generate an SQL script to create tables, based on a existing table, e.g you have a table called orders and you generate a file orders.sql that will create the table orders on another machine. Can you do the same with oracle 8.0.5 as i can not find...

Thanks Andy, this solved the problem.

I am very new to MSSQL7 and i am stuck with a program that appears to be very easy, but which i can not get to work. I have the following SQL script (I appologise for the TABLE/COLUMN names, but this is someone elses database) insert into XLABELS SELECT CONVERT(numeric, (MP640100.MP64004 /...