The table I'm updating has a trigger and it said I have to use a OUTPUT INTO. Problem is, I don't really have a clue what is being updated so not sure how to create a table to dump the OUTPUT into since I don't know the data types.
Just compare the inserted and deleted tables.
Article: Understanding SQL Server inserted and deleted tables for DML triggers
Kalman Toth Database & OLAP Architect SQL Server 2014 Design & Programming
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
No comments:
Post a Comment