Answer Posted / latha.s

select distinct * from tablename;

What is data compression?

1066

---

What is the difference between join and inner join?

1074

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1156

---

What is the report model project?

151

---

How to set database to be read_only in ms sql server?

1054

---

How to optimize stored procedures in sql server?

1242

---

What is the difference between Triggers and Stored Procedure?

1157

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1089

---

what are the different types of replication you can set up in sql server? : Sql server database administration

1063

---

What is a non-clustered index?

1046

---

Difference between LEN() and DATALENGTH() in sql server ?

1173

---

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.

1897

---

What were the latest updates to SQL Azure service?

113

---

How to view existing indexes on an given table using sys.indexes?

1153

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

2001

---