Store Multiple NULL values with unique data in SQL Server

Hello friends, Sometimes we get the data that needs to be unique but can also get NULL records. Existing ways to achieve uniqueness doesn’t allow NULLs (Primary Key) or allow max one NULL (Unique Constraint). Let’s take an example to understand this better. Suppose, you have an Employee table with fields like Id, FirstName, MiddleName,… Continue reading Store Multiple NULL values with unique data in SQL Server