|
Posted by Kart on 10/23/06 15:26
I agree.
You can trust SQL to do the job correctly or give an error. Just check
for @@ERROR to make sure that no error happened. I dont think you would
actually need to check whether the data got inserted properly.
ZeldorBlat wrote:
> tamatem wrote:
> > I made ahuge load script in SQL Server 2000 as i load data from many
> > tables(select some of each one collumns) into one single table and i
> > want to test the loaded data against the selected data to make sure
> > that the loaded data is the same the selected data
> > is there a code or tool to make this test or monitoring ?? please
> > urgent ....
>
> So you did a select ... into query? I'd be curious to know why exactly
> you want to compare the two tables. Do you not trust the server to do
> it correctly? It isn't really like a file copy or network transfer
> where it's subject to errors.
Navigation:
[Reply to this message]
|