It’s T-SQL Tuesday again! In fact, it’s the first of the year and our intrepid host is Reitse Eskens (blog|twitter). ... Continue reading
2024-01-24 (first published: 2024-01-09)
522 reads
It’s the last Friday of the year and I’ve been struggling to think of a good way to close things ... Continue reading
2024-01-12 (first published: 2023-12-29)
307 reads
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE ... Continue reading
2024-01-05 (first published: 2023-12-26)
1,056 reads
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in ... Continue reading
2023-12-29 (first published: 2023-12-19)
272 reads
Running a bit late this month for T-SQL Tuesday (it’s not exactly Tuesday is it!) but that’s Grant Fritchey’s (blog|twitter) ... Continue reading
2023-10-04 (first published: 2023-09-14)
570 reads
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading
2023-09-27 (first published: 2023-09-05)
395 reads
Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the ... Continue reading
2023-09-01
26 reads
I’m going to start out by saying I don’t know a tremendous amount about this subject. I’ll tell you what ... Continue reading
2023-09-13 (first published: 2023-08-22)
228 reads
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading
2023-08-23 (first published: 2023-08-03)
445 reads
It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We ... Continue reading
2023-08-16 (first published: 2023-08-01)
484 reads
By Steve Jones
This month we have a great invite from Joe Fleming, a first time host...
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m...
By Brian Kelley
I didn't have these in my slides for the Techno Security & Digital Forensics...
Comments posted to this topic are about the item The Trigger Updated Column(s)
Hi, I have a situation in one of the applications I am working on...
As the title says , I've got a handful of stored procs where the...
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers