Just get back the first row you find. SQL Server is smart enough to use EXISTS properly, and the second block of code returns superfast. The larger the table, the bigger difference this will make.

Cascading referential integrity constraints are foreign key constraints that tell SQL ... tables and a relationship between the SalesHistory and the Products tables. If a delete statement affects ...

Once you've defined a temporal table, SQL Server automatically keeps a history of all the changes that the rows in the table go through, storing old versions of the data in a "historical" table ...

SQL Server 2016 ... database-dynamic-data-masking-get-started. Row-level security (RLS) is going to make the lives of application developers much easier! RLS enables you to access which rows in a ...