Answer / Alok Singh

In SQL Server, 1NF (First Normal Form) is the first stage of database normalization where each table cell contains atomic values, i.e., non-repeating groups or arrays are avoided. 2NF (Second Normal Form) is the second stage where every non-key attribute is fully dependent on the primary key.

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---

What stored by the master? : sql server database administration

1 Answers  

---

Explain primary key?

1 Answers  

---

How do you trace the traffic hitting a sql server?

1 Answers  

---

List the different types of joins?

1 Answers  

---

Mention the different types of triggers?

1 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1 Answers  

---

How to resolve the orphan use problem? : sql server security

1 Answers  

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

How is a full-text index updated?

1 Answers  

---