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 the difference between constraints and triggers?
what is the Enterprise manager(2000) and management studio (2005)?
What is spid in sql server profiler?
What is function of ROLLUP ?
Write the SQL query to drop, truncate and delete table.
0 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
Do you know what is rank function?
what are cursors? : Sql server database administration
What is self contained multi valued query?
What are clustered and non-clustered index?
How do I run a trace in sql server?
What should we do to copy the tables, schema and views from one SQL Server to another?
How would you Update the rows which are divisible by 10, given a set of numbers in column?
Oracle (3259)
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)