Answer Posted / sagi.rahul

New Advanced Features In SQL Server 2008: -
a. New Data Types (Date, Time, Spatial, FILESTREAM &
HIERARCHYID)
b. Resource Governor
c. Backup Compression
d. Data Compression
e. Policy-based Management
f. Filestreamdata

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.

1839

---

Write a code to select distinct records without using the DISTINCT keyword.

1105

---

Explain the steps needed to create a scheduled job?

913

---

How to verify a login name with sqlcmd tool?

1199

---

Define views.

994

---

Where views are stored in sql server?

965

---

What is database isolation in sql server? : sql server database administration

1087

---

What is index in an assignment?

939

---

What does executeupdate return?

960

---

How to delete database objects with "drop" statements in ms sql server?

1070

---

What is the synonym of join?

942

---

what is normalization? : Sql server database administration

1074

---

How to delete a database in ms sql server?

1206

---

Can you index views?

889

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1010

---