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 the first normal form(1nf)?

967

---

What is indexing in sql server with example?

925

---

What is trigger and different types of Triggers?

1069

---

What is the difference between NOROW and LOCKROW?

2777

---

Explain query editor regions

1003

---

How will you monitor replication latency in transactional replication? : sql server replication

1087

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

938

---

What is a transaction and why is it important?

999

---

Does index slows down insert statements?

936

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1014

---

How to execute a sql statement using odbc_exec()?

1057

---

What are the export options of ssrs?

165

---

What is abstracting periodical?

896

---

How to enable tcp/ip protocol on a sql server?

1091

---

what are the disadvantages of cursors? : Sql server database administration

970

---