Answer / Arti

The different types of normalization in SQL Server include: 1) First Normal Form (1NF), which eliminates repeating groups and non-atomic values, ensuring that each column contains only atomic values. 2) Second Normal Form (2NF), which eliminates partial dependencies by ensuring that each non-key attribute depends on the primary key. 3) Third Normal Form (3NF), which eliminates transitive dependencies by ensuring that no non-key attribute is dependent on another non-key attribute.

Why it is recommended to avoid referencing a floating point column in the where clause?

1 Answers  

---

Can we use where clause in union?

1 Answers  

---

How can we get count of the number of records in a table?

1 Answers  

---

How do I start sql server?

1 Answers  

---

List out the differences between global and local temp tables in sql server?

1 Answers  

---

Explain the difference between functions and stored procedures in sql server?

1 Answers  

---

How you can change the database name in SQL SERVER?

1 Answers  

---

Can you name some of the dml commands in sql?

1 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

How to get all stored procedures in sql server?

1 Answers  

---

When would you use it?

1 Answers  

---

Write a SQL query in order to merge two different columns into single column?

1 Answers   QuestPond,

---