Outer full and inner SQL joins: you are wellcome
For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins All the Join you want
Tag: sql
Removing duplicate rows in PostgreSQL and Oracle
Oracle trick: [sql] DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2,…
Oracle SQL Developer Keep Alive plugin
On some environment, on some customers, Oracle connections are drop after some idle time (i.e. 2 minutes). I…
ORA-01461: can bind a LONG value only for insert into a LONG column
Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous…
Oracle Invalid number ORA-01722
I stumbled upon a very brain-f**k error on Oracle 10g on these days. Context: the following query [sql]SELECT…
Come evitare iniezioni SQL lato DB in SQLServer, Oracle, MySQL
Come evitare iniezione SQL: lato SQL Server (SP_EXECUTESQL) In generale va evitato nel modo più assoluto la scrittura…
dapper-dot-net – Simple SQL object mapper for SQL Server – Google Project Hosting
Dapper is a single file you can drop in to your project that will extend your IDbConnection…
NoSQL Rocks? We try to understand
At Gioorgi.com we was never a SQL fan. In 2000 we thinked SQL was boring, mostly because sql algebra…
SQL Server e Python
L’integrazione tra .NET e SQL Server è data per scontata: in questo articolo esploreremo invece come accedere a…
SQL Server: meta programmazione e meta descrittori
In questo articolo della serie SQL Server, vedremo come creare in modo dinamico delle istruzione per impostare delle…
SQLite alter table
SQLite is a small, powerful embedded database. A friend of mine started using it about six years ago. Some…