Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7649 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
Explain what are the different index configurations a table can have?
What is cursor in ms sql server?
What is an expensive query?
What is ems sql management studio? : sql server management studio
What is difference between join and natural join?
How many types of keys are there?
When does a workload on SQL Azure get throttled?
What is data modification?
How can I track the changes or identify the latest insert-update-delete from a table?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How do I start sql server?
What are the database objects? : SQL Server Architecture
Tell me what is the order in which the sql query is executed?
What is optimization and its types?
How to download and install microsoft .net framework version 2.0?
