data moving between two databases

[aajaydee]

I have a table name tbluser in database A
has fields userid and siteid
then
I have tablename tblhelper in database B with "userid" and "Entityid" fields

I want write store procedure to move record from database a to database b

I check data type are matching
I'm using following

INSERT tbluser (userid, siteid)
SELECT userid, Entityid
FROM tblhelper


but I don't know how to get the Address of table tbleuser from database b from database A

thanks

 

[manjarikosaraju]

INSERT databaseA.tableUser.tblUser(userid,siteid)
SELECT userid, EntityId
FROM databaseB.tableUser.tblhelper

 

[aajaydee]

Thanks for your prompt response