
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 …
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 …
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 …
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 …
2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.