sql server sync tables between databases

Query the SQL statement that all databases consume disk space size:SelectTable_schema, Concat (truncate(sum(data_length)/1024x768/1024x768,2),'MB') asData_size,concat (truncate(sum(index_length)/1024x768/1024x768,2),'MB') asindex_size fromInformation_schema.tablesGroup byTable_schemaOrder byData_lengthdesc;SQL statements that query the size of all table disks i

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

Recently, data is being input into the Oracle database. The number of tables in the database is large, and there are many data records in some tables. Some have fewer data records. At the beginning, a few tables are input into the database, I found that the data volume in the table was too large. I was wondering if I could use one-time data input. I found it onli

generation state)GO --6, building a data dictionary tableCREATE TABLE arch_dict(ID INT not NULL,Dtype CHAR (2) not NULL,--typeDkey CHAR (4) Not NULL,--keyDvalue CHAR (4) not NULL,--valueSorting Sn INT,--IsValid TINYINT,--is effectiveDescrip NVARCHAR (200)--Dictionary description information)GO --7, set up the archive parameter tableCREATE TABLE Arch_parameter(ID INT not NULL,Archtype CHAR (4) Not NULL,--archive typeBegindate datetime,--Archive Start dateEndDate datetime,--Archive End DateOrgID

Straint_type = ' U ' and au.table_name = table to query 4. Find the foreign key of the table (including the name, the table name of the reference table and the corresponding key name, the following is divided into multi-step query): SELECT * from user_constraints c where c.constraint_type = ' R ' and c.table_name = table to query Query the column name of the FOREIGN KEY constraint: SELECT * from User_cons_columns cl where cl.constraint_name = FOREIGN key Name Query the column name of the key re

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

One-to-Multiple SQL statement syntax for fields between SQL SERVER tables and tables, serversql Table A1 A2 A3 A4 01 02 03 04 03 04 01 02 Table B B1 B2 01 Zhang

Differences between Oracle temporary tables and SQL Server temporary tables: The process of creating a temporary table in the Oracle database and the difference between the temporary table and the SQL Server are described in this

For those that have downloaded Visual Studio 2008 to get the latest version of SQL Server compact and sync services for ADO. net, you'll notice that we don't install the documentation for these products with Visual Studio. Why? Well, our documentation process here at Microsoft can be quite complex. with all the integration and multiple versions we support, we hav

Query for SQL statements that all databases consume disk space size: Copy Code code as follows: Select Table_schema, concat (Truncate (SUM (data_length)/1024/1024,2), ' MB ') as Data_size,Concat (Truncate (SUM (index_length)/1024/1024,2), ' MB ') as Index_sizeFrom Information_schema.tablesGROUP BY Table_schemaORDER BY data_length Desc; Query for