Wow! Today I hit F5 on this interesting transaction:

    INSERT INTO World.Babies (Name, Surname, DateOfBirth, Gender)
    VALUES (‘Arianna’, ‘Ferrari’, ‘20110720’, ‘Female’);

    UPDATE World.Parents SET STATUS = ‘Happy’
    WHERE NAME = ‘Alberto’ AND Surname = ‘Ferrari’;

Thanks Caterina, I’m now the proud father of two babies, thanks to you!

And… yes, I am going to lose some sleep, this time without thinkink at Denali. Sorriso


When a column name is given, returns a single-column table of unique values. When a table name is given, returns a table with the same columns and all the rows of the table (including duplicates) with the additional blank row caused by an invalid relationship if present.

VALUES ( <TableNameOrColumnName> )


Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.

AND ( <Logical1>, <Logical2> )