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

Why truncate is ddl?

1092

---

Why main is user defined function?

1014

---

How to change the system date and time from SQL Plus Terminal ?

1223

---

What is the Control Flow in SSIS

1095

---

How to check table values in sql server?

959

---

What is sql service broker?

987

---

What do you understand by intent locks?

1014

---

How can I check that whether automatic statistic update is enabled or not?

1042

---

What are the restrictions while creating batches in sql server?

1062

---

What is RMS migrations?

2134

---

When I delete any data from a table, does the sql server reduce the size of that table?

1021

---

What the different topologies in which replication can be configured?

1092

---

Can you explain what is indexed view? How to create it?

908

---

Who is the owner of a schema in ms sql server?

1079

---

What does Master database contains?

1140

---