Vikas
Can we pass null value in Unique Id
By Vikas in SQL Server on Mar 23 2021
  • Rijwan Ansari
    Apr, 2021 17

    Yes, we can keep null in unique column if it is nullable. Null is also a unique reconrd in the column. However, you can have only one null record as one null is only unique for that column.

    • 2
  • Kirtesh Shah
    Apr, 2021 7

    Yes, we can.

    The Unique constrain mainly use to restrict duplicate values insertion and ensure that column has a unique value. It will not allow you to enter the duplicate NULL value in the column but allow you to insert a unique(Single) NULL value in the column.

    • 1
  • Shashidhar R
    Oct, 2024 26

    only one null we can insert

    • 0
  • Shashidhar R
    Oct, 2024 26

    no

    • 0
  • Nagaraju Kodavalla
    Aug, 2021 29

    One null value possible, more than that is not possible

    • 0
  • krunal pande
    May, 2021 8

    Yes

    • 0
  • Rahul Pal
    Mar, 2021 27

    Yes You can .But only one Null value

    • 0
  • Kiran Mohanty
    Mar, 2021 24

    Yes, But only once . Provided column value is nullable

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS