Edwardliuy的博客

SQL SERVER 比较两个数据库中表和字段的差异

using MongoDB.Bson;using MongoDB.Driver;using MongoDB.Driver.Builders;using System;using System.Collections.Generic;using System.Configuration;using System.Linq;using System.Text.RegularExpressions;using System.Threading.Tasks;using System.Web;

新建存自增ID的表CREATE TABLE [dbo].[IdentityID]([TableName] [varchar](500) NOT NULL,[NextID] [bigint] NOT NULL,CONSTRAINT [PK_IdentityID] PRIMARY KEY CLUSTERED ([TableName] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,

SELECT a.* from dbo.book a , (SELECT max(id) as id from dbo.book group by title,isbn,author_id ,page_count )b where a.id = b.id

exec sp_spaceused ‘表名’ --（SQL统计数据，大量事务操作后可能不准）exec sp_spaceused ‘表名’, true --(准确的表空间大小，但可能会花些统计时间）exec sp_spaceused – (数据库大小查询）exec sp_MSforeachtable “exec sp_spaceused ‘?’” --(所有用户表空间表小，SQL统计数据，，大量事务操作后可能不准）exec s.