![]() SQL Prompt always produces warnings when we update such tables, because we did not write any WHERE condition. To ensure this, we always use some constraints, like these:ĭummyID tinyint CONSTRAINT DEFAULT (1),ĬONSTRAINT PRIMARY KEY (DummyID),ĬONSTRAINT CHECK (DummyID=1), ![]() We have several tables with various configuration settings, which will always have a single row.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |