SQL interview questions prevent insert numeric values in an NVARCHAR column

#sqlinterviewquestionsandanswers
SQL interview questions prevent insert numeric values in an NVARCHAR column
To prevent inserting digits numeric values in an NVARCHAR column, utilize constraints or checks during table creation or alteration. For instance, employ a CHECK constraint with a condition like `CHECK (NOT Name LIKE '%[0-9]%')` to ensure that only non-numeric values are accepted. This approach maintains data integrity by rejecting entries violating the condition. Properly enforced constraints enhance database reliability, adhering to desired data types and constraints in the NVARCHAR column while preventing unintended numeric entries.

[@khealer]

Numeric value means entire column cannot be a number. I think you are just preventing the insertion digits. And such constraints should always reside on the business logic layer, not in the database.

[@HarithaComputersTechnology]

yes you are right, i thought to change to my thumbnail.. by that time got a comment. any ways thanks and these tutorials will get an idea and knowledge on writing sql queries for beginners and job seekers.