Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number.
- 4 Answers
- 6367 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / 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 This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are indexes in sql?
How connect excel to sql server?
What is amo? : sql server analysis services, ssas
How do you trace the traffic hitting a sql server?
How to enter unicode character string literals in ms sql server?
How can you fetch alternate records from a table?
What is sql server schema compare? How we can compare two database schemas?
Write a SQL query to delete a table?
Tell me what is difference between view and materialized view?
Explain why variables called the most powerful component of ssis?
What does the update command do?
Can a table have 2 primary keys?
What do you mean by tablesample?
What is the default fill factor value?
What are the five characteristics of good data?
