UPDATE(CreditLimit) returned 1 when I set CreditLimit to its own value. For a sql server trigger to check if value has changed, join inserted to deleted on the key and keep rows where the new value IS DISTINCT FROM the old one. Quick answer: put the comparison in the trigger’s WHERE clause, not in an … Read more >>
The UPDATE worked, but the audit row your trigger should write never appeared. To debug trigger in SQL Server code, make it talk: RAISERROR WITH NOWAIT, a log table, and sys.triggers. Quick answer: put RAISERROR(‘…’, 0, 1) WITH NOWAIT at the top of the trigger and run the statement that should fire it. No message, … Read more >>
Indexed views in SQL Server cut my sales-by-state query from 1,059 logical reads to 2. But only after I named the view and added a hint. Without it, SQL Server 2025 Standard Developer ignored the index. Quick answer (indexed views in SQL Server): create the view WITH SCHEMABINDING, use two-part table names, add COUNT_BIG(*) next … Read more >>
My 16 MB test database was offline for about 2 seconds. The SQL Server move database files routine Microsoft recommends: ALTER DATABASE … MODIFY FILE, SET OFFLINE, copy the MDF and LDF, SET ONLINE. Here’s the end state: Before You Start: Test Setup and Sample Database Test setup: SQL Server 2025 (17.0.1000.7) Standard Developer, default … Read more >>
Say you’re logging web orders for a Denver shop and want order numbers that start at 1001 and count up on their own. That’s the job of an identity column in SQL Server. Declare OrderID int IDENTITY(1001, 1), leave it out of every INSERT, and SQL Server fills it in: Output: Tested on SQL Server … Read more >>
You add ORDER BY to a view and SQL Server refuses it. Or worse, it accepts it and the rows come back unsorted anyway. Quick answer (SQL Server view ORDER BY): keep ORDER BY out of the view and sort in the query that reads it. That’s the only place SQL Server promises an order: … Read more >>
To get trigger definition in SQL Server, pass the trigger name to OBJECT_ID and wrap it in OBJECT_DEFINITION. You get the full CREATE TRIGGER text back as one value: sqlcmd printed: Two cases return NULL instead: DDL triggers and encrypted triggers. Sample Triggers for Every Example Tested on SQL Server 2025 (17.0.1000.7) Developer, sqlcmd in … Read more >>
If you’ve chained one more table onto a report and watched the totals double, the joins did exactly what you wrote. PostgreSQL multiple joins are JOIN … ON clauses stacked in one FROM, each joining the next table to the rows built so far: On PostgreSQL 18.6 (x86_64-windows, run from psql), that returns all five … Read more >>
In this SQL Server tutorial, we will learn and understand how to use the SQL Server LEFT OUTER JOIN with the WHERE clause on tables by the query. Recently, I got a requirement to join multiple tables and even filter records based on the condition for the resultset in the SQL Server. So, I came … Read more >>
In this MariaDB tutorial, we will learn about the “MariaDB change column” and cover the following topics. How to change column data type in MariaDB MariaDB change column name How to change column order in MariaDB MariaDB change column size How to change column to not null in MariaDB How to change column to primary … Read more >>