Category: sql

Self-tutoring about SQL Server: the tutor mentions a potential peculiarity. Let’s imagine there’s a trigger that updates a row just inserted. Performing an insert on such a table today, I got the message Query succeeded: Affected rows: 2 Yet, to …

SQL Server: triggers: rows affected Read more »

Self-tutoring about the SQL Server query editor: the tutor mentions a hint. I defined a function, but then couldn’t find it. I wondered – was it even defined, or had I accidentally deleted it somehow? The command exec sp_helptext function_name …

SQL Server: reveal a function Read more »