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%'

How to query multiple tables jointly?

707

---

Why union all is faster than union?

678

---

What protocol does sql server use?

697

---

What is trace flag in sql server?

718

---

What command must you use to include the not null constraint after a table has already been created?

754

---

---

Explain the properties of the relational tables?

720

---

What is a filestream?

735

---

What do you understand by the analysis services in sql server?

702

---

How to loop through result set objects using mssql_fetch_array()?

748

---

What is a synonym for manipulation?

724

---

How to download and install microsoft sql server management studio express?

745

---

Create and insert into temp table in sql server?

778

---

How can a database be repaired?

728

---

Explain partitioned view?

807

---

Is truncate autocommit?

715

---