Answer Posted / deepak rohilla

select (substring(name,1,3)+' '+substring(name,13,3)
+' '+substring(name,5,3)+' '+substring(name,17,3)
+' '+substring(name,9,3)+' '+substring(name,21,3))name
from employee where name like '%raj%'

Explain table valued parameters in sql server? Why tvp used?

1067

---

Does sql server use java?

1127

---

Do you know what is sql service broker?

1161

---

What are the advantages of having an index on the sql server?

973

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1249

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1107

---

What is 1nf 2nf and 3nf?

957

---

What does asynchronous call backs means?

1224

---

How to set the current database in ms sql server?

1139

---

Explain few examples of RDBMS?

1100

---

What is data modeling and Reterminal integrity?

2011

---

what are the three command line utilities and what are their primary functions?

153

---

When would you use the stored procedures or functions?

1052

---

Why use “pivot” in sql server?

1176

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

1040

---