Answer Posted / achuthan

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

What are temporal tables in sql server 2016?

560

---

Define candidate key, alternate key, and composite key.

610

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

576

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

649

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

660

---

---

What is the difference between count () and rowcount ()?

606

---

Why should one not prefix user stored procedures with ‘sp_’?

696

---

Explain datetime2 data type in sal server 2008?

613

---

What is use of except clause?

728

---

What according to you is the difference between mysql and sql server performance?

653

---

How to find the source of a table in sql server?

626

---

What is policy based management (pbm)? : sql server database administration

659

---

Are null values the same as that of zero or a blank space?

677

---

Do you know the different ddl commands in sql?

670

---

Do you know what are the ways available in sql server to execute sql statements?

627

---