Answer Posted / soorai ganesh

Hi Friend,

If u use SQLSERVER 2005 u can try like this............

CREATE TABLE EMP ( ENAME VARCHAR(25))

INSERT INTO EMP VALUES('Ganesh')
INSERT INTO EMP VALUES('Narendra')
INSERT INTO EMP VALUES('Rinku')
INSERT INTO EMP VALUES('Selvam')
INSERT INTO EMP VALUES('Kirti')

SELECT REPLACE(REPLACE(
( SELECT ENAME AS EmpName FROM EMP FOR XML PATH ('') ) ,'<EmpName>',''),'</EmpName>',',')

What is tabulation?

946

---

What do you understand by a view? What does the with check option clause for a view do?

994

---

What are the different types of lock modes in sql server 2000?

938

---

Distinguish between nested subquery and correlated subquery?

1038

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1381

---

What is bcnf normalization form?

1105

---

How to convert numeric expression data types by assignment operations?

1067

---

What is a rownum?

968

---

what are user defined datatypes? : Sql server database administration

962

---

How to backup encryption key ?

182

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4375

---

Explain the first normal form(1nf)?

1021

---

When you should use a low fill factor?

990

---

Can you explain various data region available in ssrs with their use?

969

---

Characterize join and name diverse sorts of joins?

965

---