Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Visual Studio 2005 For discussing Visual Studio 2005. Please post code questions about a specific language (C#, VB, ASP.NET, etc) in the correct language forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Studio 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 11th, 2008, 09:38 AM
Registered User
 
Join Date: May 2008
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue building a Setup project in vs2005 burwelj Visual Studio 2005 1 April 17th, 2008 12:08 PM
What is the different between VS2005 and VS.NET? zach007 Visual Studio 2005 4 September 11th, 2007 12:44 PM
Can I still use VS2005 Beta? Aaron Edwards ASP.NET 2.0 Basics 0 September 13th, 2006 07:34 PM
Can I still use VS2005 Beta? Aaron Edwards ASP.NET 2.0 Basics 1 December 12th, 2005 11:57 AM
C++ IDE acuratk C++ Programming 3 December 4th, 2004 03:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.