sql query to compare two tables in different databases

Create Table # TABLE (Num int, name1 nvarchar (10), name2 nvarchar (10) Create Table # Table1 (Num int, name1 nvarchar (10 )) insert into # Table1 select 1, 'A' Union all select 2, 'B' CREATE TABLE # Table2 (num1 int, name2 nvarchar (10) insert into # Table2 select 1, 'A' Union all select 2, 'bb' declare @ sqlstr nvarchar (1000) -- set @ sqlstr = 'select. *, B. name2 from # Table1 as a inner join # Table2 as B on. num = B. num1 'insert into # Table exec (@ sqlstr) Select * from # tabledrop table

following statement:EXEC sp_tablesIt is the table information that filters out all records that table_type equals table in the result set.Other useful system functions--Read all table names in the librarySelect name from sysobjects where xtype= ' u '--Reads all column names of the specified tableSelect name from syscolumns where id= (select Max (id) from sysobjects where xtype= ' u ' and name= ' table name ')Get database table names and fieldsThe role of each system table in

SQL statement used to query fields of all INFORMIX data tables: Select a. tabname, B. colname, B. coltype,Case B. coltypeWhen '0' then 'Char'When '1' then 'smallint'When '2' then' integer'When '3' then 'float'When '4' then 'smallfloat'When '5' then 'decimal'When '6' then 'serial'When '7' then 'date'When '8' then 'money'When '9' then 'null'When '10' then 'datetime

Label:Two kinds:1.select * FROM table 1, table 2, table 3 where table 1. field = Table 2. field and table 1. field = Table 3. FieldThis efficiency is smaller than the lower structure of simple data can be used2.select * FROM table 1 join table 2 on table 1. field = Table 2. field and join Table 3 on table 1. field = Table 3. FieldThis is good. Questioner evaluation 2nd and join is wrong, should be join, no andHttp://zhidao.baidu.com/link?url=jI4ahWhPIbnq6gXcOZHWAeUPwSmO211KY

This problem was encountered by a friend who made an SSIS program to import data to txt. Then, use Oracle tools to import data to Oracle. However, when executing the variable step in SSIS, it is found that the output column name is completely different from the queried column name. For example, Schema_id is in the third column of the query, but 6th columns are output. 650) this. width = 650; "style =" he

I. List of databases1. List all librariesUse Master;goselect name,dbid from master.dbo.sysdatabases2. List only user librariesUse Master;goselect name,dbid from master.dbo.sysdatabases where dbid>4;Ii. list tables in a library1. List only the system tables in the library;Use Db_name;goselect name,xtype from sysobjects where xtype = ' s '2. List only the user data tables