SQL
Database programming tutorials for MySql and Microsoft SQL Server, with tips on performance optimisation and how to use the data in PHP, C#, ASP.Net and JavaScript.
There is a new configuration option in SQL Server 2017 called CLR strict security, it is enabled by default, and can cause problems when using CLR.
There are many reasons to create a table using a script, and a quick check if the table already exists will eliminate problematic errors, however, Microsoft SQL Server does not provide a complete user-friendly way for testing table existence.
How to import CSV file into SQL Server or how to load CSV file into SQL Server table are two commonly asked questions that have an easy answer.
When combining rows from multiple tables in one query, you may need to use the JOIN command. There are a few different types of joins, and the following should help explain the differences between them.