This Types of Triggers Quiz asks which trigger you can put on a view that joins two tables. The answer is INSTEAD OF INSERT. A tested script shows the error an AFTER trigger gives and how the working trigger splits one insert into two tables.
Checking Data Fits Before Narrowing a Column Data Type
Check existing values before narrowing a column, account for dependencies and data loss, and plan the locking cost of the change.
SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?
CTAS stands for Create Table As Select. In SQL Server you do it with SELECT INTO, which creates the new table and fills it with data in one step.
OUTPUT INTO: Record Old and New Values in One Write
OUTPUT INTO records old and new values during a write, while the transaction determines whether the change survives. Test NULL transitions, unchanged values, rollback and target failures before treating captured rows as committed history.
Turning a Comma-Separated Column Into a Proper Child Table
A list stuffed in one column makes every search a guess. Split it, clean it and move it into a child table, then check the result before you drop anything.
Multi-Language Text: A Table Design for Translations
Multi-language text separates product identity from translated names. This test setup checks requested, fallback, and base names, Unicode text, duplicate tags, missing rows, and a precise blank policy.
Keeping Large Blobs Out of Your Main Tables
Large blobs can widen SQL Server access paths and backups; learn to separate payloads, avoid SELECT *, and measure off-row storage behavior.