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

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1106

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1021

---

What is a constant or literal in ms sql server?

1024

---

How to send a ssrs report from ssis?

174

---

Does partitioning help performance?

918

---

What is the sql server 2000 version number?

1053

---

What is field with example?

903

---

What are four major operators that can be used to combine conditions on a where clause?

1024

---

Explain transaction server auto commit?

1023

---

How to list all triggers in the database with sys.triggers in ms sql server?

1055

---

What is the difference between having clause and where clause in sql server?

1076

---

List the ways in which dynamic sql can be executed?

1002

---

What are the differences between having and where clause.

955

---

What are the system database in sql server 2008?

1014

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1064

---