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,

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

what is create database syntax? : Sql server database administration

0 Answers  

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

how insert selected column only ?

3 Answers   Robert Half,

---

Explain different types of collation sensitivity?

0 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

What is difference between line feed ( ) and carriage return ( )?

0 Answers  

---

What is a join in sql? What are the types of joins?

0 Answers  

---

What do you understand by sql server agent?

0 Answers  

---

How can we check the sql server version?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---