Activity overview
Latest activity by srikmr
Here is the proble we are facing.
As i said in my earlier post we are having a sql_variant data type and it stores a DateTime value sometimes.
DATABASE 1 (DB1):
In table1 of DB1 we have few rows which have a date time value in this column (say the column name be DESCRIPTION which is of data type Sql_variant).
When i used the SELECT statement in Sql-Server Mgmt Studio i get the out put as below:
Query is: SELECT ID, DESCRIPTION from TABLE1
Result is like: 1, 2006-03-07 11:44:02.000
I can see that DESCRIPTION data is stored in the DB1 with a value of 2006-03-07 11:44:02.000
DATABASE2 (DB2):
In Table1 of DB2, we have a similar row.
I queried again for the data in Sql-Server Mgmt Studio, and i got the same result.
Query is: SELECT ID, DESCRIPTION from TABLE1
Result is like: 1, 2006-03-07 11:44:02.000
here too,
I can see that DESCRIPTION date is stored in the DB2 with a value of 2006-03-07 11:44:02.000
NOW I RUN THE SQLCompare against these two and get the result as they are not same. I have tried it using the UI and also the toolkit. Here is the output:
svValue 3/7/2006 11:44:02 AM <> 2006-03-07 11:44:02:000 The strange thing what i observed is:
1) The SqlDataCompare was showing the value from DB1 as
3/7/2006 11:44:02 AM instead of showing 2006-03-07 11:44:02.000
2) Surprisingly, The data from DB2 was showing as it is. i.e 2006-03-07 11:44:02.000 (which is as expected).
I wonder why SqlDataCompare is behaving in a different way while showing the data from DB1 and DB2.
If it were showing the same was as in DB1 then then its OK, but what i wonder is:
The same data is being shown differently from two similar rows of 2 databases.
Can you plese suggest a solution to overcome this problem. We need this to be solved very soon for our project.
Regards
Srikmr / comments
Here is the proble we are facing.
As i said in my earlier post we are having a sql_variant data type and it stores a DateTime value sometimes.
DATABASE 1 (DB1):
In table1 of DB1 we have few rows ...
how to ignore the primaryKey fields while comparision
Hi,
This query might look weird.
Here is my case;
i have a table Table1 in DataBase1. It has a primarykey column and couple of other columns. The primary key column is auto generated and the other ...
Thanks Chris for your prompt response.
I shall be waiting for your your answers for my my other question (question2).
Thanks
Srikmr / comments
Thanks Chris for your prompt response.
I shall be waiting for your your answers for my my other question (question2).
Thanks
Srikmr
Format difference of data in sql_variant datatype.
Hi,
I am having a column by name 'Description' in my table with the data type 'sql_variant'.
Our application is storing some data in that column, but it sometimes stores a Date value too.
In databa...