Re: SQLSTATE = 23000 error
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 07/01/04
- Next message: Matt Tapia: "Linked Server and Verify Connection"
- Previous message: Steve Kass: "Re: SQLSTATE = 23000 error"
- In reply to: ylona schneider: "SQLSTATE = 23000 error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Jul 2004 21:01:09 +0530
hi ylona,
First off, this is SQL Server forum, you may find some relevent Sybase forum
on the net. But looking at the error description its obvious that you are
getting primary key constraint violation error whose reason is same across
any RDBMS.
The insert statement that you are running, tries to insert such a value in
the table which is duplicating value for PRIMARY KEY constraint column
(which should be unique across the table.) If this constraint is broken you
will get this error.
Refer to following url to know more about primary keys.
http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/8_des_04_13.htm
to know the primary key of the table slc_order in SQL Server i will use
following system stored procedures.
--1)
sp_pkeys table_name
--or
--2)
sp_help table_name
you will have to find out equivalent command in Sybase.
-- Vishal Parkar vgparkar@yahoo.co.in | vgparkar@hotmail.com
- Next message: Matt Tapia: "Linked Server and Verify Connection"
- Previous message: Steve Kass: "Re: SQLSTATE = 23000 error"
- In reply to: ylona schneider: "SQLSTATE = 23000 error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
