SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
11,784 reads
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
11,784 reads
A while back, I was building the database schema for a web application which had some reporting functionality and among other things, I had do implement logic in the...
2017-04-19
5 reads
When it comes to a choice between data types for a field in a SQL Server database's table, an issue...
2017-02-06
2,078 reads
When it comes to a choice between data types for a field in a SQL Server database's table, an issue that is frequently discussed in popular forums is a...
2017-02-06
9 reads
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard...
2017-01-18
208 reads
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard Atom or RSS feeds containing any data that you...
2017-01-18
3 reads
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...
2017-01-11
174 reads
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and the messages on the output window show something like [16:08:11]...
2017-01-11
1 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find a section for database documentation that describes its importance,...
2017-01-11
7 reads
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
811 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