Answer / Sanjeev Kumar Pandey

In SQL Server, deleting a package specification (SPEC) will not affect the corresponding package body. The package body remains intact in the database as long as it's not explicitly dropped. The two are separate objects and their relationship is maintained by their names.

Describe in brief databases and sql server databases architecture.

1 Answers  

---

What is the difference between mysql and sql server?

1 Answers  

---

Are all views updatable ?

1 Answers   MCN Solutions,

---

Is it true, that there is no difference between a rule and a check constraint?

1 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

What is 1nf 2nf and 3nf?

1 Answers  

---

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

Do you know how to send email from database?

1 Answers  

---

What do you understand by the analysis services in sql server?

1 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1 Answers  

---