Answer Posted / sajida

--For ex in dept table to select 5th record. Instead of
this you can use &n so that it can ask row number

select rnum, d.* from dept d, (select rownum rnum ,
deptno from dept ) e
where d.deptno = e.deptno and rnum = 5

Tell me the phases a transaction has to undergo?

917

---

What is default constraint in ms sql server?

968

---

What are the character string functions supported by sql server 2005?

936

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1758

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

933

---

Does order by actually change the order of the data in the tables or does it just change the output?

1083

---

Can we join two tables without primary key?

982

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1967

---

What do you mean by an execution plan? Why is it used? How would you view it?

880

---

What is sql server management studio? : sql server management studio

1016

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

962

---

How to enter unicode character string literals in ms sql server?

1019

---

How to use values from other tables in update statements in ms sql server?

1040

---

What are the properties of primary key?

915

---

What is transaction server distributed transaction?

978

---