Answer Posted / gopi muluka

CREATE TABLE Names (Name VARCHAR(50))
GO
INSERT Names
SELECT 'A'
UNION
SELECT 'B'
UNION
SELECT 'C'
UNION
SELECT 'D'
GO

-- FIRST METHOD
DECLARE @Name VARCHAR(50)
SELECT @Name=ISNULL(@Name,'')+ COALESCE(Name,',')+',' FROM
Names
SELECT LEFT(@Name,LEN(@Name)-1)
GO
--SECOND METHOD
DECLARE @chrString as varchar(200)
SET @chrString=''
SELECT @chrString=@chrString + ',' + Name FROM Names

SELECT SUBSTRING(@chrString,2, LEN(@chrString))

GO
DROP TABLE Names

What is the purpose of linked server configuration in sql server?

1036

---

What is trigger explain with program?

973

---

What is difference between order by and group by?

1000

---

Explain what is cte (common table expression)?

1119

---

What is "scheduled jobs" or "scheduled tasks"?

971

---

How many categories of data types used by sql server?

1010

---

What methods do you follow to protect from sql injection attack?

1014

---

what is denormalization? : Sql server database administration

920

---

Explain nested trigger in sql?

1063

---

What are the five characteristics of good data?

909

---

Explain syntax for dropping triggers?

923

---

Describe in brief databases and sql server databases architecture.

1004

---

Define magic tables in sql server?

1047

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

946

---

how you can deploy an ssrs report?

178

---