SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
2022-01-19
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
2022-01-19
In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.
2021-10-25
Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.
2021-03-16
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
2021-01-29
Of course it seems a great idea to have your application on all the main mobile platforms as well as on the desktop. However, as Arkadiusz Pachucy knows all too well, this can ultimately leave you with a full-scale maintenance nightmare. In this article he looks at whether technologies like PhoneGap/Cordova or Adobe Air could be the perfect compromise - and if so, what frameworks to use.
2015-08-24
3,088 reads
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item The Cloud Security Problem, which...
Hi, I have a simple table with 5 columns as follows with about 80,000...
hi everyone I have a SP that is run in SSIS. That particular SP...