sql server compare 2 tables for differences

/// /// Obtain the names of all database servers in the LAN. /// /// Server Name Array Public List String > Getsqlservernames () {datatable datasources =Sqlclientfactory. instance. createdatasourceenumerator (). getdatasources (); datacolumn Column = Datasources. Columns [ " InstanceName " ]; Datacolumn column2 = Datasources. Columns [ " Servername " ]; Datarowcollection rows = Datasources. Rows; L

Label:1. Create a new database TestDB 2. Create a new table for the TestDB database userinfo Create a table named UserInfo, including the above fields, where the ID is the primary key and set the identity specification, Nation set the default value "China". Add some data to the table: --using the TestDB database use TestDB go--view data in a userinfo tableSelect* fromUserInfo--add data records for UserInfo insert into UserInfo values ('1001','Zhang

/*--Synchronizing readersINSERT into [172.21.200.8].gdlisxp.dbo. Reader Library (library card number, reader barcode, name, gender, ID number,reader level, level Code, Unit Code, Unit, debit, issuing date, expiration date, ethnicity, reservation information)Select Xs.sfzh,xs.sfzh,xs. XM,(case XS. XBM when ' 1 ' then ' Male ' when ' 2 ' then ' women ' else ' end ' as Xb,xs.sfzh, ' student ', ' B ',DW. Unit code, ' +zy.zymc,20 ', ' 2014-09-16 18:00:00 '

. Extended_properties. VALUE fromsyscolumnsINNER JOINSYS. Extended_properties onSyscolumns.id=SYS. Extended_properties. major_id andsyscolumns. COLID=SYS. Extended_properties. minor_idINNER JOINSYSOBJECTS onSyscolumns.id=sysobjects.idWHERESysobjects.name=So.name andSyscolumns.name=Sc.name) Description--So . Name Table name, SC. Name Column name fromSYS. COLUMNS Sc,sys. TYPES St,sys. SYSOBJECTS so--Column name information and table structure informationWHEREsc.user_type_id=st.user_type_id andSc.o

Tags: style blog http color os io ar for dataHow many tables are in SQL Server query database SELECT * from sysobjects WHERE (xtype = ' U ')C = CHECK constraintD = defaults or Default constraintsF = FOREIGN KEY constraintL = LogFN = Scalar functionIF = inline table functionP = stored procedurePK = PRIMARY KEY constraint (type is K)RF = copy Filter stored procedu

Data dictionary is a good thing, for development, maintenance is very important.However, it is not convenient to write descriptive narration in SQL Server, how to simplify and add changes to the extended attributes in batches?It would be nice to add 2 tables and 5 stored procedures,

: increments of several numbers at a time wildcard characters:_: There is only one character% any of any charactersLike ' (used to modify)Having said so much, we should pay attention to some common problems;01. Foreign Key control is not good02. In SQL Server, string and date type data are enclosed in single quotes, and numeric types are not03. Each table must have a primary key, the table without the prima

Label:Data from the database in the work to export, but found that the exported Excel column names are field names (in English), to collect data on how to change the field name to Chinese names, and found that Oracle and SQL Server (SQLSERVER2008R2) is different, as follows: SQL Server database: system table: ---Get in

choice. With seek access, SQL Server uses the index to direct to the data row that satisfies the predicate condition. In this example, we refer to this predicate as "seek predicate". In most cases, SQL Server does not have to re-evaluate "seek predicate" as "residual predicate". The index guarantees that "seek" return

informationCreate Table table (A1 varchar), A2 char (2))--Add descriptive information to the tableEXECUTE sp_addextendedproperty n ' ms_description ', ' personnel information table ', n ' user ', n ' dbo ', n ' table ', N ' table ', NULL, NULL--Add descriptive information for field A1EXECUTE sp_addextendedproperty n ' ms_description ', ' name ', n ' user ', n ' dbo ', n ' table ', n ' table ', n ' column ',

Tags: changing SQL from structure performing LSE highlight insert UPDFirst, two tables were created, Test1 and test2, with the expectation that the relevant records of Test2 could be changed at the same time when the test1 was changed. Assume that Test1 is the same as the table structure of Test2, as shown in the following table Name Age The trigger impl

sent, which can sometimes cause the same record to be fetched simultaneously by multiple processes and sent.Today, we looked at the MSDN of SQL Server and found that it was possible to ensure that each record was read only once by updating it at the same time through the deleted table (as if it were used in a trigger).Declare @Rowid table (Rowid int);BEGINSET ROWCOUNT 100; --Number of rows read at one time

In sqlserver, a simple combination of sp_spaceused and sp_msforeachtable stored procedures can easily calculate the size of the user data table, including the total number of records and space usage, which is very practical, both sqlserver2k and sqlserver2005 passed the test. /**/ /*1. Exec sp_spaceused 'table name' (SQL statistics, which may be inaccurate after a large number of transaction operations)2