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 …
update
SQL Server
Check last update date on a SQL Server table
How to check the last update date on a SQL Server table? Check the last access and update with a simple SQL query? Thanks to the SQL Server relational database management system tables, …
SQL Server Errors
SQL Server Violation of unique key constraint
How to insert or update data in an SQL Server table with a simple query? Here are two simple solutions to execute an update or insert and avoid errors. The SQL Server error …
