Useful SQL
SQL Server insert or update query example
How to write an insert or update SQL Server query? Here are two different, quick and easy solutions to write an “UPDATE OR INSERT” query. In other words, avoid the SQL Server error …
Example
SQL Server Strings
Split text after character with SQL Server Substring
How to split a text after a particular character with SQL Server… like for example a file name: “file.txt” to separate the file name from its extension. Indeed, it is obvious that splitting …
SQL Server Partition
Create a SQL Server partition
How to create a table partition in SQL Server? Let’s consider a large table with Sales data. So, this table have a column that stores the year of the sale and the table …
