I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

write a query to display diference between two dates in sql server

2 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 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  

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

What is a ddl command?

0 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

What is the purpose of primary key?

0 Answers  

---

Can we commit in trigger?

0 Answers  

---

how would you get the current date in mysql? : Sql dba

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

Does oracle roll back the transaction on an error?

0 Answers  

---