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
- 7993 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / rajesh.a
insert into table2(Column1,Column2) select Column1,Column2
from Table1 where Column1%2 = 0
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is sqlcmd?
Why variables called the most powerful component of ssis?
What is database replication?
Can you name a few encryption mechanisms in sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is index, cluster index and nonclustered index?
Explain cdc and sql injection?
What is a cursor, index in sql?
How to define the name and server for a new dsn?
How to create prepared statements using odbc_prepare()?
What is the difference between a function and a stored procedure?
Do you know how to implement service broker?
What are the various editions of sql server 2017 that are available in the market?
Can you tell me some of the common replication dmv's and their use? : sql server replication
