Answer Posted / achuthan

set @s= ''
select @s=@s+column +','
if Len(@s)>0
select @s = substring(@s,1,len(@s)-1)

What is the primary use of the model database?

1156

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1303

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1209

---

What is temporary table in sql server? Why we use temp table?

1027

---

Disadvantages of the indexes?

1232

---

What are the different subsets of sql?

1662

---

What is the difference between upgrade and migration in sql server?

1193

---

What kind of problems occurs if we do not implement proper locking strategy?

1508

---

What is acid mean in sql server?

1257

---

Why we use the openxml clause?

1088

---

what is the difference between openrowset and openquery?

1208

---

How do I create a trace in sql server?

1128

---

How do I start sql server 2017?

1024

---

What is in place upgrade in sql server?

1137

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1139

---