摘要：序号数据类型长度说明1int4自增标识2tinyint1整形（0到255）3smallint2整形（-2^15到2^15）4int4整形（-2^32到2^32）5bigint864位整形（-2^63 到 2^63-1）6float8浮点型（-1.79E + 308 至 -2.23E - 308、0 ... 阅读全文

摘要：RESTORE DATABASE DBNameFROM DISK = 'F:\WorkSpace\database\backup.bak'with replace,MOVE 'DBName' TO 'F:\WorkSpace\database\DBName.mdf',MOVE 'DBName_log... 阅读全文

摘要：select request_session_id as spid,OBJECT_NAME(resource_associated_entity_id) as tableNamefrom sys.dm_tran_lockswhere resource_type='OBJECT'declare @spid int Set @spid =81 --锁表进程declare @sql varchar(1000)set @sql='kill '+cast(@spid as varchar)exec(@sql); 阅读全文

摘要：  脚本 9 --COMPUTE SUM(i.rowcnt),count(o.name);--汇总行数，表数  阅读全文

摘要：SQL Server无法生成FRunCM线程|FRunCM 线程|FRunCM   在开始－Sql server 2005-配置工具－SQL Server Configuration Manager － sql协议－禁止VIA 阅读全文