Answer / swapna

There are lots of options available, you have to choose
your option depending upon your requirements.

Some of the options you have are: BACKUP/RESTORE,
dettaching and attaching databases, replication, DTS, BCP,
logshipping, INSERT...SELECT, SELECT...INTO, creating
INSERT scripts to generate data.

What is index in an assignment?

0 Answers  

---

How to use clusters?

0 Answers   Amdocs,

---

Explain cursor as data base object?

0 Answers  

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

How can you find out which stored procedures are recompiling?

0 Answers  

---

What is tempdb in sql server?

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  

---

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

How to create an multi-statement table-valued function?

0 Answers  

---