sql server compare 2 tables for differences

Label:This article from: http://www.cnblogs.com/yjss/articles/2065664.html 1. Delete a table Use database name declare mycur cursor local for SELECT [name] from dbo.sysobjects where xtype= ' U ' declare @name varchar (10 0) OPEN mycur FETCH NEXT from Mycur to @name while @ @FETCH_STATUS = 0 BEGIN exec (' drop table ' + @na Me) FETCH NEXT from mycur to @name END CLOSE mycur 2. Delete a view Use database name declare mycur cursor local for S

Many software companies understand the importance of developing applications that do not depend on specific database types (such as Oracle, SQL Server, and DB2), allowing customers to choose their preferred platforms. Generally, software developers can identify their customers responsible for database maintenance and must use existing platforms and personalized customers. There have been many articles descr

SQL Server database synchronization question sharing [unfinished, To be continued] (1) SQL Server database synchronization problem sharing (2) --- operation steps [unfinished, To be continued] (1)ModifyFTPConnection During data synchronization, the publisher needs to

, such as the table TB Name field value: John, Dick, Harry, Zhao Liu And we want to query the name= John, this must be judged when the table's name field contains the query criteria, that is, "John", that is, the query Workaround: 1, the first thought of course is like query (not the ultimate solution, the ultimate way to continue to look down) such as sql= "select * Form TB where tb.name like '%" John "%" To explain this statement, you can que

If you carefully track the login process of the SQL Server database server, you will find that password computing is actually very fragile. The weak password of the SQL Server database reflects two aspects: 1. Password Encryption during network login Algorithm

incompatible in the equal to operator. Query two: SELECT [text], [Varcharmax]from [TestDB]. [dbo]. [Asdf]where [Varcharmax] = ' 1111111 ' can run successfully in Ms SQL2005 and above, add a large value data type (varchar (max), nvarchar (max), varbinary ( Max)). A large value data type can store up to 2^30-1 bytes of data. These data types behave in the same way as the smaller data types varchar, nvarchar, and varbinary. MicrosoftThis data type is u

SQL Server tables: SELECT COUNT (1) from sysobjects where xtype= ' U ' views: select COUNT (1) from sysobjects where xtype= ' V ' number stored procedures Selec T count (1) from sysobjects where xtype= ' P 'SELECT * from sysobjects WHERE (xtype = ' U ')C = CHECK ConstraintD = defaults or DEFAULT constraintsF = FOREIGN KEY constraintL = LogFN = Scalar functionIF =

SQL Server table and Excel data bulk copy method (resolved) SQL Server table data Copy to Excel (method) 1, the new query, using SQL statements to read the table data 2, then, select data, right button, copy (also can be clicke

' master '"If you use Windows authentication, use the following command line to change the default database to a database that is not missing:isql/e/d "Master"/q "exec sp_defaultdb n ' BUILTIN\Administrators ', n ' master '" (2) SQL Server cannot start because the system password has been changed The solution is: Click Run, type services.msc, open the service

Differences between oracle and SQL (common functions) (2) ORACLE functions BitsCN.com Value from dual; 1 8. use 10 as the base logarithm. S: select log10 (10) value 1 O: select log (10, 10) value from dual; 1 9. Square S: select SQUARE (4) value 16 O: select power (4, 2) value from dual 16 10. take the square root S: s

After creating a table on SQL Server, you often need to change the design of the table. If you have any questions, the system will prompt "you are not allowed to save the changes. You must delete the changes and recreate the following tables. The reason is that, to prevent data tables from being changed at will, the st

--Create a test library first test_tmp --Create two tables based on an existing table SELECT TOP to test_tab1 from Mistest_09428.dbo.squarer; SELECT TOP to test_tab2 from Mistest_09428.dbo.squarer; --Create a role EXEC sp_addrole ' Test_role1 '; 11. 12.--Assign the permissions of select to the role test_role1GRANT SELECT on TEST_TAB1 to Test_role1;GRANT SELECT on test_tab2 to Test_role1;

Sorting hundreds of billions of tables or a join between billions of tables can cause the system to lose its response. 1. I did make a large query that involved a data table with 200 million records, and a group by operation, resulting in large CPU, memory, and disk overhead. Later, with Microsoft's people to experiment again, my query does cause the system to slow down the response. We also experimented w

In the past, SQL Server only performed operations on the graphic interface. Now I find that my SQL language skills are getting worse and worse. For example, how to add associations for two tables, cascade update and delete. I checked it at night and found that two methods can be used. Trigger method:Create trigger trg

SQL Server compact does not support top and row_number. the frequently used SQL pages cannot be used in SQL Server compact. How does SQL Server compact implement paging? The answer is o

Just spit it out, because the company is going to deploy a whole new system for new customers, but the company doesn't have an empty library, so it can only back up the databases that are running on the wire, and then empty the data.Here's a look at what I wrote when I emptied the database. A method of bulk emptying a data tableIdea: Query out all the tables under the library filter out the tables that need

Gam, SGAM, Pam, Iam, DCM, and BCM are some special allocation ing tables used in SQL Server to manage space allocation. Understanding their differences and roles plays an important role in understanding the architecture of the SQL Server