If user is owning any SQL Objects, can we drop that user

0 Answers  

---

What is 1nf 2nf and 3nf?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

What is the process of indexing?

0 Answers  

---

How do I install only the client tools of sql server 2000?

0 Answers  

---

---

What is the difference between delete and truncate statements?

0 Answers  

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---