You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
No Answer is Posted For this Question
Be the First to Post Answer
What is sql sandbox in sql server?
When do you think a developer should use sql server-based cursors?
Does union all remove duplicates?
Explain Trigger with an example?
How to create a view with data from multiple tables?
What is primary key and example?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the use of tempdb? What values does it hold?
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
How do I open port 1433?
What is full outer join in sql server joins?
What should we do to copy the tables, schema and views from one SQL Server to another?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)