Answer / debasish

select max(alias.colomnname) from table alias
join table alis on
<condition>

Answer / vaibhavi_dixit

select max(alias1.columnname) from table1 alias1
join table2 alias2
on condition

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

why would you use sql agent? : Sql server database administration

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

How to count duplicated values in a column in ms sql server?

0 Answers  

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---

List the different index configurations possible for a table?

0 Answers  

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

What is use of except clause?

0 Answers  

---

Explain about builtinadministrator?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---