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 are the different sql server versions?

680

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

794

---

Are resultset updatable?

701

---

What is blocking?

716

---

How to create a dml trigger using create trigger statements?

731

---

---

What are the components of dbms?

714

---

Is mysql better than sql server?

731

---

What is normalization 1nf 2nf 3nf?

800

---

How to select some specific rows from a table in ms sql server?

759

---

What are sql server functions?

678

---

How to check parameter value in stored procedure sql server?

656

---

What is the server name for sql management studio?

655

---

How can you find out how many rows returned in a cursor?

754

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

756

---

What are the differences between triggers and stored procedures?

724

---