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 do I edit a stored procedure in sql server?

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

What is intellisense?

0 Answers  

---

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

Explain boyce and codd normal form(bcnf)?

0 Answers  

---

Explain cross join or cartesian product in sql?

0 Answers  

---

How to check table values in sql server?

0 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers  

---

What is single-user mode?

0 Answers  

---