Sql server error: INSERT statement contrary to CHECK constraint

Question

The INSERT statement was contrary to the CHECK " ck_str_member_no" constraint . The conflict occurred in the database "C: \ DOCUMENTS AND SETTINGS \ KARTHIKEYAN \ DESKTOP \ KOK \ DB \ INFT3009_ASS1_C3104855.MDF", table "dbo.Members", column " str_member_no". Application completed.

I am using the .MDF file in my visual studio 2008 Express. How to solve it?

My insert Procedure:

---

ALTER PROCEDURE [dbo].[AddNewAGCMember] 
  -- Add the parameters for the stored procedure here
  @str_member_no varchar(6) = '', 
  @str_member_name varchar(50) = '',
  @str_member_password varchar(10) = '',    
  @str_addr_apartment_no varchar(10) = NULL,    
  @str_addr_building_name varchar(50) = NULL,   
  @str_addr_street_name varchar(50) = NULL, 
  @int_postal_code int = NULL,  
  @str_country_name varchar(50) = NULL, 
  @int_contact_no int = NULL,   
  @str_email_addr varchar(100) = '',    
  @date_registration date = ''  
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  -- Insert statements for procedure here
  INSERT INTO Members 
    (str_member_no,
     str_member_name,
     str_member_password,
     str_addr_apartment_no,
     str_addr_building_name,
     str_addr_street_name,
     int_postal_code,
     str_country_name,
     int_contact_no,
     str_email_addr,
     date_registration) 
  VALUES
    (@str_member_no, 
     @str_member_name,
     @str_member_password,
     @str_addr_apartment_no,
     @str_addr_building_name,
     @str_addr_street_name,
     @int_postal_code,
     @str_country_name,
     @int_contact_no,
     @str_email_addr,
     @date_registration);
END

---

Table structure:

• str_member_no, varchar (6), Unchecked
• str_member_name, varchar (50), Unchecked
• str_member_password, varchar (10), Unchecked
• str_addr_apartment_no, varchar (10), Verified
• str_addr_building_name, varchar (50), Verified
• str_addr_street_name, varchar (50), Verified
• int_postal_code, int, Checked
• str_country_name, varchar (50), Verified
• int_contact_no, int, Checked
• str_email_addr, varchar (100), Unchecked

• date_registration, date, Unchecked

  Unchecked
  

Answer 1

, . - , n - .

, , :

SELECT
name, definition 
FROM
    sys.check_constraints
WHERE
    name = 'ck_str_member_no'

, "".

, . .

, /, , :

ALTER TABLE dbo.Members
   DROP CONSTRAINT ck_str_member_no

Answer 2

-, INSERT 'str_member_no', SQL CHECK. - , , . , , CHECK , str_member_no 1500 ( , , ...) - "-".

DDL , INSERT, , ( ).

, str_member_no, , , , null ; , , , , , [custom] .

, , AddNewAGCMember() StoredProcedure; , , , , "".

Answer 3

MySQL, .

CHECK MySQL