wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

How many triggers can be applied on a table?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

What is raid? How does it help storage of databases?

0 Answers  

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

How do you optimize a query?

0 Answers  

---

Explain what is a database?

0 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

Explain about various levels of constraint.

0 Answers  

---