Answer / meenaprasanna

insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1 %2 ='0'

Answer / mythili

insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1 %2 ='0'

Answer / rajesh.a

insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1%2 = 0

Answer / priyanka malondkar

First make a function like this
create function functionname(@sno int)
returns number;
declare check;
begin
check=@sno%2
if check=0
return 0;
else
return 1;


Then the query will be
declare no;
insert into Table2(a,b,c) values select (a,b,c) from Table1
where no=functionname(sno) and no=0;

Kindly check.
In case of any syntax error please excuse as i have not
checked it of sql sever.

Is sql server difficult to learn?

0 Answers  

---

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

---

What is indexed views? plz explain with example?

2 Answers  

---

Why do we need different type of parameter?

0 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

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 the difference between a view and a stored procedure?

0 Answers  

---

What are transactions and its controls?

0 Answers  

---

What is the difference between OLEDB and ODBC

4 Answers   CFCI,

---

Do you know clustered and non-clustered index?

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---