Answer / Pradip Kumar Dubey

{"clauses": ["WHERE", "GROUP BY", "HAVING", "ORDER BY", "SELECT", "FROM", "JOIN"]}

can primery key be a non clustered index?

10 Answers  

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

What are different types of constraints?

0 Answers  

---

How to delete duplicate records based on single column from a table?

1 Answers   Petranics Solutions,

---

How can you insert null values in a column while inserting the data?

1 Answers  

---

What command is used to create a database in the sql server and how?

1 Answers  

---

How does a profiler work?

1 Answers  

---

What are scalar functions in sql?

1 Answers  

---

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  

---

List the different types of collation sensitivities in sql server?

1 Answers  

---

How is foreign key related to primary key?

1 Answers  

---