Answer / manoj

insert into <table_name> (<col1>,<col3>)
values(<val1, val3)

Answer / rajkumar

Format
------
Inser into <tablename> (column name) select (column name)
from <tablename> where <Condition>

Example
--------
INSERT INTO emp (empname) SELECT empname from employe WHERE
empid=5

Answer / srinivas

insert into <table_name> ( <col1> ,<col3>) values ( val1,val2)

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,

---

What are the elements of dbms?

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

How can we remove orphan records from a table?

0 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

What is resource governor in sql server?

0 Answers  

---

What is difference between cte and view?

0 Answers  

---

What is default constraint?

0 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---