Answer Posted / amit shukla

select upper(left(h01_first_name,1))
+lower(substring(rtrim(h01_first_name),2,50)) as name from
<table name>

Differentiate between a local and a global temporary table?

913

---

How to execute function in stored procedure sql server?

1081

---

Do you know what are the steps to process a single select statement?

930

---

Where the sql logs gets stored? : sql server database administration

926

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1033

---

Tell me in brief how sql server enhances scalability of the database system?

954

---

What are the elements of dbms?

937

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

996

---

What is a group function explain with an example?

953

---

Tell me what do we need queues in sql service broker?

944

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

Explain what is the function of sql server agent windows service?

959

---

What happens when the SQL Azure database reaches Max Size?

109

---

What is query processing?

899

---

What is the difference between rank and dense_rank?

1024

---