Answer Posted / murtaza

select empname,salary from A
where empname IN ('A','B');

What is the sql server 2000 version number?

1150

---

Can you pass expressions to function parameters?

1153

---

Explain what is the use of custom fields in report?

958

---

What is raid? : SQL Server Architecture

1230

---

What are the differences between stored procedure and the dynamic sql?

1139

---

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

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2990

---

Explain how many types of relationship?

1086

---

Define self join?

1078

---

What are views in ms sql server?

1119

---

Tell me about the approaches which you used to counter the DI problems.

1427

---

What are commonly used mssql functions in php?

1144

---

Tell me what is the order in which the sql query is executed?

1016

---

What is cdc in sql server?

1046

---

What happens if you add a new index to large table?

982

---