Jun 4, 2011

How can get data from two databases in a single select statement

Many times we need data from more then one data bases in that case use that statement.

Select database_name.dbo.table_name.column_name ,database_name.dbo.table_name.column_name
From database_name.dbo.table_name,database_name.dbo.table_name

No comments:

Post a Comment