摘要：有时在操作数据类型，容易报错(原因不是很清楚)，通过语句还是可以搞定的 alter table MemberInfo alter column mimage varchar(800) not null 阅读全文

摘要：create Procedure GetUserAccount@UserName nchar(20),@UserID int outputasif(@UserName>5)select @UserID=COUNT(*) from usertypes where id>1elseset @UserID 阅读全文

摘要：SELECT index_type_desc,alloc_unit_type_desc,avg_fragmentation_in_percent,fragment_count,avg_fragment_size_in_pages,page_count,record_count,avg_page_sp 阅读全文

摘要：SELECT i.name,i.type_desc,s.page_count,s.record_count,s.index_level,compressed_page_countFROM sys.indexes i JOIN sys.dm_db_index_physical_stats(DB_ID( 阅读全文