You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
No Answer is Posted For this Question
Be the First to Post Answer
How exceptions can be handled in sql server programming?
What are the requirements for sql server 2016?
Do you know what are acid properties?
How to get nth highest salary from employee table.
How do I start sql server 2017?
Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC
Which language is supported by sql server?
How can you insert null values in a column while inserting the data?
What are the advantages of log shipping?
What are distributed partitioned views?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Tell me the difference between clustered and non-clustered index?