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)

Is sql server 2016 free?

0 Answers  

---

ow to bring suspect mode datbase online from scratch

0 Answers  

---

how many triggers you can have on a table? : Sql server database administration

0 Answers  

---

Explain the storage models of OLAP?

1 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---

What are the different type of replication in sql server?

0 Answers  

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---