What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

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,

---

How to make remote connection in database?

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

What is difference between order by and group by?

0 Answers  

---

What is single-user mode?

0 Answers  

---

What does nvl stand for?

0 Answers  

---

What is the difference RDBMS and Graph Database?

0 Answers   EXL,

---

When you should use a low fill factor?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is page in sql server?

0 Answers  

---

Can we use where clause with group by?

0 Answers  

---