sql query to compare two tables in different databases

Next let's take a look at our commonly used drop function. This is used in mysql mssql access to delete SQL drop statements, Delete tables, delete databases, and delete indexes. Let's take an example here. Drop index Delete index Access:Drop index index_name ON table_name Mssql:Drop index table_name.index_name Mysql index deletion:Alter table table_name drop

the table and delete the table are as follows:Use Studbif exists (select * from sysobjects where name= ' Stumarks ')drop table StumarksCREATE TABLE Stumarks( Examno int identity (primary) key, Stuno char (6) NOT NULL, Writtenexam int not null, Labexam int not null)Go--Where the column attribute "identity (start value, increment)" means "Examno" is automatically numbered, also known as the identity columnALTER TABLE table nameAdd constraint constraint name

1. query all tables in SQL:Select TABLE_NAME FROM database name. INFORMATION_SCHEMA.TABLES Where TABLE_TYPE = 'base table' after execution, you can see the names of all tables created by yourself in the database.2. query all tables and columns in SQL:Select dbo. sysobjects.

This article introduces two stored procedures that are very useful in the master database but not mentioned in SQL Server online textbooks. These System The process is very convenient for processing the following tasks, such as determining the storage space used, the number of rows, and the user table index. In the first process, sp_msforeachdb executes three commands for each database on the server of interest. @ Command1: The first command to be

The SQL statement used to query multiple fields, query multiple tables, and delete duplicate records. SQL repeat record Query 1. Search for redundant duplicate records in the Table. duplicate records are determined based on a sing

By using the DROP statement, you can easily delete indexes, tables, and databases.SQL DROP INDEX StatementWe can use the DROP Index command to delete the index in the table.Syntax for Microsoft Sqljet (and Microsoft Access):DROP INDEX index_name on table_nameSyntax for MS SQL Server:DROP INDEX Table_name.index_nameFor IBM DB2 and Oracle syntax:DROP INDEX index_nameSyntax for MySQL:ALTER TABLE table_name DRO

To create the SQL statement for the database:1 UsePractice2 Go 3 if exists(Select * fromsysobjectswhereName='Practice')4 Drop Tablestore_information5 Create Tablestore_information6 (7StoreIDint Identity(1,1)Primary Key,--Column Properties "Identity (start value, increment amount)"8Store_namevarchar not NULL,9Store_moneydecimal NULL,TenStore_date Date not NULL, One)To delete a database, SQL Server stores

Enable AD Hoc distributed Queries: ' Show advanced Options ', 1 Reconfigure ' Ad Hoc distributed Queries ', 1 Reconfigure When you are finished using, close ad Hoc distributed Queries:' Ad Hoc distributed Queries ', 0 Reconfigure ' Show advanced Options ', 0 Reconfigure Operation: ' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Password ' ' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Passw

This article describes two very useful stored procedures in the master database that are not mentioned in the SQL Server online textbook. These system procedures are handy for handling the following tasks, such as determining the amount of storage space used, the number of rows, and the user table index Wait a minute. The first procedure sp_msforeachdb the execution of three commands for each database on an interested server. @command1: First comma

This article original website: http://blog.csdn.net/htl258/article/details/5695391------------------------------------------------------------------------------------author:htl258 (Tony)--Date: 2010-06-25 22:23:18--version:microsoft SQL Server (RTM)-10.0.1600.22 (Intel X86)--Jul 9 2008 14:43:34- -Copyright (c) 1988-2008 Microsoft corporation--Developer Edition on Windows NT 5.1 　　Data manipulation between differe