Tag Archives: SQL
T-SQL: Previous and Next Modified Date
Normally queries like this are not really solved in T-SQL; rather a front end UI like WebI is capable of navigating through the records. However if you intend doing it in T-SQL (eg. derived table in universe), then here’s how … Continue reading
Insert, update and delete statements
Flynet: Insert, update and delete statements work according to same principle as normal select statement.
Fieldnames must be unique
Flynet: Output columnnames have to be unique, in aggragations thus: SELECT (~field1~*field2) as alias, (field1*~field2~) as alias2 FROM …. OR SELECT (field1*field2) as ~alias~, (field1*field2) as ~alias2~ FROM …. AND NOT LIKE SELECT (~field1~*field2) as alias, (~field1~*field2) as alias2 FROM … Continue reading
Tildes ( ~ ~ )
Flynet: ~ ~ state a column in output query, aggregations like: ~field1~*field2 or field1*~field2~ or field1*field2 as ~alias~
