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

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

Define model database?

0 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

What options are available to audit login activity? : sql server security

0 Answers  

---

How do you open a cluster administrator?

0 Answers  

---

How to view existing indexes on an given table using sp_help?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---