Answer / Akanksha

Yes, SQL Server 2005 allows you to alter the data type and thus change the size of a column using the ALTER TABLE command. Here's an example:nnALTER TABLE EmployeesnALTER COLUMN Salary money(4,2);

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

Explain the difference between function and stored procedure?

1 Answers  

---

What is the default server name for sql server?

1 Answers  

---

How check triggers in sql server?

1 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

Explain cdc and sql injection?

1 Answers  

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1 Answers  

---

What is instead of trigger sql server?

1 Answers  

---

where can you add custom error messages to sql server? : Sql server administration

1 Answers  

---

What are the types of joins in sql?

1 Answers  

---

What are the kinds of subquery?

0 Answers  

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1 Answers  

---