Please answer questions SQL server 2008 edit table information database of information input repeat into cell read-only and no] method modified problem thank you thank you

CodePudding user response:

You can use the DELTE statement will remove these two lines, add a logo or design the structure specification for yes field

 DELETE [table name] WHERE [the column 1]='advocates thrifty in Harbin.. '- the two lines at the same time delete 
The ALTER TABLE [TABLE name] ADD serial number int IDENTITY (1, 1) NOT NULL, or ADD a column identifies specifications for field, after the data change this field can be deleted 

CodePudding user response:

Said you have a problem of new data, the phenomenon do not conform to the requirements of the database of certain constraints, can't submit (that is, save to disk), should check whether there is a unique index limit, the other database paradigm, the table should not be present in the same line, at least one identity column, database won't be able to differentiate between the two records have what distinction,