Define the one-to-one relationship while designing tables.

0 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  

---

Is foreign key a primary key?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

what operator performs pattern matching?

2 Answers  

---

Which table keeps the locking information?

0 Answers  

---

Explain the steps needed to create a scheduled job?

0 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

What is a schema in ms sql server 2005?

0 Answers  

---

What is the difference between delete and truncate statements?

0 Answers  

---

What is log in sql server?

0 Answers  

---