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

Tell me the phases a transaction has to undergo?

917

---

What are the advantages of sql azure?

139

---

What is the significance of master, tempdb and model databases?

1026

---

What does top operator do?

965

---

How many types of objects are there?

938

---

What is normalization of database?

1022

---

How adventureworkslt tables are related?

882

---

How many types of subqueries are there in sql server?

937

---

Explain data warehousing in sql server?

991

---

What method is used by the Command classes to execute SQL statements that return single values?

1008

---

What is the difference between delete and truncate statements?

1020

---

What is query and its types?

875

---

how to determine the service pack currently installed on sql server? : Sql server database administration

910

---

Do you know what is xpath?

1004

---

How to move database physical files in ms sql server?

961

---