Answer / Komal Devi

Yes, SQL Server Integration Services (SSIS) allows you to add custom code in Script Tasks and Script Transforms by using Visual Basic .NET (VB.NET), C#, or JScript as the scripting language.

Explain transaction server distributed transaction?

1 Answers  

---

What are different types of replication in sql server?

1 Answers  

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---

How to loop through returning rows?

1 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

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

1 Answers  

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

---

What are indexes in ms sql server?

1 Answers  

---

What is the new security features added in sql server 2016? : sql server security

1 Answers  

---