create database MyTempDB_A
go
create database MyTempDB_B
go

use MyTempDB_A

CREATE TABLE [MyTable_DB_A] (
	[myInt] [int] NULL ,
	[myChar] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[myNVarchar] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

insert into MyTable_DB_A values (1,'1','Hello 1 (DB_A)')
GO

-- NOTE: The default DB is still MyTempDB_A, however, the next code will create a table
--       in a different DB called 'MyTempDB_B'

CREATE TABLE [MyTempDB_B].[dbo].[MyTable_DB_B] (
	[myInt] [int] NULL ,
	[myChar] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[myNVarchar] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

-- NOTE: Same concept as above.  Insert into a different DB because it was fully qualified.
insert into [MyTempDB_B].[dbo].MyTable_DB_B values (1,'1','Hello 1 (DB_B)')
GO

select * from MyTable_DB_A
-- NOTE: Same concept as above.  Select a table from a different DB because it was fully qualified.
select * from [MyTempDB_B].[dbo].MyTable_DB_B

/*
--Note: Run this to drop the databases.
use master
drop database MyTempDB_A
drop database MyTempDB_B
*/