Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
- Parameters are not supported in a DDL statement.
String in SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Teradata
regexp_instr REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR
-
trim trim specified pad characters or bytes from a character or byte string
-
like %, _ like, case-insensitive You can also
like any (pattern_1, pattern_2, ...)like all …
Primary Key vs Index in SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
-
index is for distribution data index does not have to be unique
-
primary key must be unique and non null
-
primary keys are automatically indexed
Auto Increment in SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
http://plsql4all.blogspot.com/2014/08/auto-increment-column-in-teradata.html http://stackoverflow.com/questions/21982004/how-to-generate-automatic-number-in-teradata-sql https://forums.teradata.com/forum/enterprise/auto-increment-column
- Be careful with batch insert if there is an auto …