Answer Posted / k.vanitha

CREATE TABLE Employee (NAME VARCHAR(20), SALARY int);

INSERT INTO employee VALUES (
'RAMESH',
9000);
INSERT INTO employee VALUES (
'RAJESH',
10000);

SELECT Left(upper(NAME),1) +
lower(substring(NAME,2,len(NAME))) FROM employee

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1014

---

what are the different ways to return the rowcount of a table?

1003

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1067

---

What happens if you delete a table that is used by a view?

990

---

What is t-sql script to take database offline – take database online.

1088

---

What is the most common type of join?

995

---

How can you ensure that the database and sql server based application perform well?

1085

---

What are the types of ssrs?

145

---

What is set nocount on?

940

---

What is efficiency data?

953

---

What is a data collection table?

1011

---

Name few endpoints exposed by ssrs 2012?

355

---

Write down the syntax and an example for create, rename and delete index?

987

---

How do I find the sql server instance name?

970

---

role of sql sever 2005 in database rather than any other database

1944

---