Tag Info

Hot answers tagged

30

To quote Joe Celko (not only can you find this reference all over the web and in his Wikipedia entry, but you will even see it on T-shirts at some conferences): Rows are not records. A lot of people point him out as a pedantic jerk who just likes to humble and verbally abuse newbies, and I will admit that is how he comes across. But I have also met him ...


25

Microsoft has in several places in their organization provided that the official name for tabular data storage per table-entry (to coin a taxonomic definition that serves my own purpose) is called a "ROW". I submit as evidence ROW_NUMBER, ROWCOUNT, ROWVERSION and the DataTable.Rows property, where a DataTable is a C# representation of a TSQL "table" object. ...


17

I've just searched through the document "Information technology — Database languages — SQL Part 2: Foundation (SQL/Foundation)", which defines the ANSI standard for SQL as implemented by all major RDBMSes. The word row is used primarily throughout the document several hundred times, as expected. The word record was only used to describe a record that is ...


10

Because relational databases are rarely used in isolation, in order to avoid confusion between other parts of systems, I always refer to tables and rows and columns. In a client applications, we typically have other constructs, including datareaders, datasets, datarows, datatables, etc - for instance "field" is often used for on-screen data entry and Pascal ...


7

Every individual transaction (statement) in SQL Server is atomic, meaning it passes or fails as a unit. If the 999,999th record fails on a constraint violation in a 1,000,000 row insert, all of the other rows get rolled back and the table is exactly as it was before the failed statement was attempted. The same applies for updates and deletes, as well as ...


5

The language keeps evolving. A few decades ago the literate people used "indices" instead of simpler "indexes". As we switched to "indexes", we eliminated an unnecessary complication and made the language more useful. The need to memorize a plural for "index" was pure overhead - it did not in any way help us communicate. Make no mistake, there used to be ...


2

Although your question is already answered very well. I would like to add my points too. May be you find it helpful upto some extend. Also my answer is not specific to SQL Server These words are used interchangeably. 1 2 3 4 -------------------------------------------------------------------- Row = Record = Tuple ...


1

INSERT INTO mytable (ID,`key`,`value`) VALUES (1106,'_views',1) ON DUPLICATE KEY UPDATE `value` = `value` + 1; and INSERT INTO mytable (ID,`key`,`value`) VALUES (1107,'_views',1) ON DUPLICATE KEY UPDATE `value` = `value` + 1; If your table has value defined as CREATE TABLE mytable ( ... value INT DEFAULT 1, ... ); then the INSERTs would be ...


1

Please read this but report: http://bugs.mysql.com/bug.php?id=69027 The workaround ("solution", really) to this is to change the password for the affected user to a post-4.1 hash. This is really a recommended best practice, regardless - password hashing and authorization process prior to 4.1 has notable security limitations (discussed in documentation at ...


1

The only information you have about 'when' a row entered the table is the ID of the inserting transaction. The sad news is that this is in no way connected to any real timestamp. So you either add the new column (where you can't figure out when the existing rows were inserted) - or probably you can create triggers on all tables which populate a transaction ...



Only top voted, non community-wiki answers of a minimum length are eligible