listenwrong的专栏

表test(id,name,grade) 方式一： select name 姓名,grade 分数,(select count(distinct grade) from test where grade>a.grade)+1 as 名次 from test a order by grade desc   方式二： select name 姓名,grade 分数,(select c

sp_fulltext_database 'enable'--启动全文索引 sp_fulltext_catalog  'member_info', 'create'--建立全文索引目录 create unique index pk_memberid on member(memberid) --需要建立唯一索引 sp_fulltext_table  'member','create','mem

SET NOCOUNT ON; DECLARE @objectid int; DECLARE @indexid int; DECLARE @partitioncount bigint; DECLARE @schemaname sysname; DECLARE @objectname sysname; DECLARE @indexname sysname; DECLARE

create index idx_saleformula_saleno on saleformula(saleno) --查看表所有索引 EXEC sp_helpindex 'saleformula' --重建表的所有索引 DBCC DBREINDEX ('saleformula','') --重建表索引碎片 DBCC INDEXDEFRAG ('shop_zhujiang','s

use master DUMP TRANSACTION 数据库名 WITH NO_LOG BACKUP LOG 数据库名 WITH NO_LOG DBCC SHRINKDATABASE(数据库名,初始大小)