As a database designer, I often create on database tables the primary key as identity autoincrement and sometimes I needed to find missing or deleted IDs thet interrupt the sequence…
As a database designer, I often create on database tables the primary key as identity autoincrement and sometimes I needed to find missing or deleted IDs thet interrupt the sequence…
For different needs, often I had needs to send a list of values to a Stored Procedure. To achieve this goal it is possible to use a workaround with…
When you modify database schema on Sql Server with Microsoft SQL Server Management Studio you can simply create script with Generate Change Script function. This is not allowed when you…
Spesso mi è capitato di dover effettuare uno split di una stringa in sql. Dato che non esiste una funzione di sistema per effettuare lo split bisogna creare una User…