Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing the values in 2 tables
Message
From
02/04/2009 11:56:19
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01392746
Message ID:
01392756
Views:
34
Hey Sergey!

How's it going? Yep, I want to compare all data, every column, every row. There is a primary key. I have rewritten a process that inputs 10 of thousands of records every night. So I want to compare the data in the new process to the old one. I have it written in Foxpro, where I scan, seek every record and compare the value in every field. It works fine, but I was just wondering if SQL Server had some niffty comand or tool.
BTW, I had a problem with the LEN command the other day and looked it up here on the thread, and you stated to some one to use DataLength instead.. thanks!

Thanks!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform