Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  

---

What is data block and how to define data block size?

0 Answers  

---

What is the sql case statement used for?

0 Answers  

---

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

What is join and name different type of joins?

0 Answers  

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

Explain database normalization?

0 Answers  

---

Difference between Function and Procedure-in general?

6 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---