VS2005 IDE Issue
I have two table "t1" & "t2" as below:
create table t1 (a int PRIMARY KEY, b varchar(30), tstamp timestamp,)
create table t2 (a int, b varchar(30))
When i try to use VS2005 IDE --> Server Explorer --> Connect to DB --> Execute the stored procedure named "test",
exception "Failed to enable constraints. One or more rows contain values violating non-null, unique,
or foreign-key constraints." is thrown.
SP "test" has a simple select statement as shown below
SELECT
t1.tstamp
FROM
t1
INNER JOIN
t2
ON
t1.a = t2.a
The exception occurs only if the column of Timestamp Datatype is included.
Is there any restriction for Timestamp Datatype.
|