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

What is cursor in ms sql server?

1122

---

What is user defined datatypes and when you should go for them?

999

---

What are examples of triggers?

1057

---

What are the properties of the transaction?

991

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1589

---

What are the different types of normalization?

1132

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1238

---

How many replicas are maintained for each sql azure db?

124

---

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?

1035

---

What is the concept of optimization?

1021

---

Do you know what is blocking?

931

---

Give main differences between "Truncate" and "Delete".

1071

---

How is SQL Azure different than SQL server?

223

---

What is plan freezing?

950

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

892

---