Answer Posted / amit shukla

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

How self join is different from outer join?

1099

---

How to loop through result set objects using odbc_fetch_row()?

951

---

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

1047

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1107

---

What is exporting and importing utility?

1057

---

Does sql server 2000 clustering support load balancing?

950

---

How to create a trigger for insert only?

1022

---

Why use view instead of a table?

927

---

Explain the dbcc pintable command when would you use it?

893

---

How to install sql server 2005 express edition?

1098

---

What are the different SQL Server Versions you have worked on?

989

---

Tell me what is difference between view and materialized view?

920

---

What is a collation in ms sql server?

1057

---

What is a rownum?

947

---

What is self join in sql server joins?

1030

---