Italiano English

Search Results

You are looking for:Keywords LIKE '*SQL*'
Try advanced search

Standard deviation numerically stable calculation for SQL

Keywords: Probability, Algorithms, SQL, FireBird
Sezioni: None
Argomenti: Database

Despite of Standard Deviation is one of most relevant parameter of descriptive statistics, it isn't available as common aggregation function for some SQL server. Here is described how to calculate and use standard deviation in a single select query. Finally a better and numerically stable sql procedure is shown.

Firebird: Tree data mangement

Keywords: SQL, FireBird
Sezioni: None
Argomenti: Database

This document shown two different way for server side managment of Data Tree with Firebird. First method uses Recursive Common Table Expression. Second method uses Recursive Stored Procedure

Firebird: Tree data mangement with recursive CTE

Keywords: SQL, FireBird
Sezioni: None
Argomenti: Firebird: Tree data mangement

This document shown how to use Firebird Recursive Common Table Expression to managing trees

Firebird: Tree data mangement with recursive Stored Procedure

Keywords: SQL, FireBird
Sezioni: None
Argomenti: Firebird: Tree data mangement

This document shown how to use Firebird Recursive Stored Procedure to walking trees

Firebird: A safe trigger for autoinc fields

Keywords: SQL, FireBird
Sezioni: None
Argomenti: Database

As you know, Firebird doesn’t have Autoinc fields but you can use triggers and sequences (generators) in order to obtain Autoinc features. On the web you can find many example about this.

Unfortunately I can’t find examples where triggered field (autoinc field) could receive a NOT NULL value, as is in data import from script. Following common examples,  when the triggered field receives a value, the generator isn’t incremented so you may have “key violation” on future inserts.

In this document is shown a safe trigger example that can be used also when the triggered filed could receive a value.

PkBdeToSql

Free Portable convertor from BDE / Paradox database to sql text file.

It dumps BDE full database or selected tables to sql file using LocalSQL dialects. Is very usefull to put paradox tables under version control but it cab be used with to migrate BDE database to new sql DB also