Can sql servers linked to other servers like oracle?

0 Answers  

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

What are the purposes of floor and sign functions?

0 Answers  

---

What is the usage of sign function?

0 Answers  

---

What are the properties of the transactions?

0 Answers  

---

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

List out different types of normalizations in sql server and explain each of them?

0 Answers  

---

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

What is a heap?

0 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---