Google Groups Home
Help | Sign in
Data Compare
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  2 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Vicegodgiarc  
View profile
 More options May 9, 12:40 am
From: Vicegodgiarc <vicegodgi...@hotmail.com>
Date: Thu, 8 May 2008 21:40:08 -0700 (PDT)
Local: Fri, May 9 2008 12:40 am
Subject: Data Compare
Hi,

I ahve been comparing two identical SQLServer tables with the
following schema:
Position Name Data Type Nullable Length Digits
1 Log_Time_Date... datetime false 23 3
2 Occurrence_No varchar false 9 0
3 Log_Entry text true 2147483647 0
4 Username varchar true 50 0
5 Manual_Entry smallint true 5 0

Seems that the Log_Entry has not been matching correctly, even when
reducing the set comparison to only a few rows.

Is there an issue comparing text?

Regards
Craig


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
DB Solo  
View profile
 More options May 9, 8:09 am
From: "DB Solo" <mhant...@gmail.com>
Date: Fri, 9 May 2008 08:09:19 -0400
Local: Fri, May 9 2008 8:09 am
Subject: Re: Data Compare
Seems to work correctly as far as I can tell. Could you post/email the
CREATE TABLE statement and a couple of INSERT statements for both
sides that would demonstrate the problem?

Marko


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google