how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

What are the different editions available in sql server 2000?

0 Answers  

---

Describe the left outer join & right outer join. : sql server database administration

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---