Interested to Buy Any Domain ? << Click Here >> for more details...
How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 18174 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh murali
select * into db1.db1_table from (select * from
db2.db2_table)
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How do I use mysql?
I want to start and stop mysql on windows? How do I do that?
What does mysql flush tables do?
What are mysql queries?
can you tell the order of sql select statement? : Mysql dba
What is regex in mysql?
What is data type for image in mysql?
How do I start mysql in mysql workbench?
How to delete a trigger in mysql?
What is the use of concat() in mysql?
write a query to mysql in safe mode and to change the root password
What is mysql gpl?
How do you shutdown a mysql database?
How show all tables in mysql query?
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
