sql code
--½áºÏsys.indexesºÍsys.index_columns,sys.objects,sys.columns²éѯË÷ÒýËùÊôµÄ±í»òÊÓͼµÄÐÅÏ¢
select
o.name as ±íÃû,
i.name as Ë÷ÒýÃû,
c.name as ÁÐÃû,
i.type_desc as ÀàÐÍÃèÊö,
is_primary_key as Ö÷¼üÔ¼Êø,
is_unique_constraint as Î¨Ò»Ô¼Êø,
is_disabled as ½ûÓÃ
from
sys.objects o
inner join
sys.indexes i
on
i.object_id=o.object_id
inner join
sys.index_columns ic
on
ic.index_id=i.index_id and ic.object_id=i.object_id
inner join
sys.columns c
on
ic.column_id=c.column_id and ic.object_id=c.object_id
go
--²éѯË÷ÒýµÄ¼üºÍÁÐÐÅÏ¢
select
o.name as ±íÃû,
i.name as Ë÷ÒýÃû,
c.name as ×ֶαàºÅ,
from
sysindexes i inner join sysobjects o
on
i.id=o.id
inner join
sysindexkeys k
on
o.id=k.id and i.indid=k.indid
inner join
syscolumns c
on
c.id=i.id and k.colid=c.colid
where
o.name='±íÃû'
--²éѯÊý¾Ý¿âdbÖбítbµÄËùÓÐË÷ÒýµÄËæÆ¬Çé¿ö
use db
go
select
a.index_id,---Ë÷Òý±àºÅ
b.name,---Ë÷ÒýÃû³Æ
avg_fragmentation_in_percent---Ë÷ÒýµÄÂß¼Ë鯬
from
sys.dm_db_indx_physical_stats(db_id(),object_id(N'create.consume'),null,null,null) as a
join
sys.indexes as b
on
a.object_id=b.object_id
and
a.index_id=b.index_id
go
---½âÊÍÏÂsys.dm_db_indx_physical_statsµÄ²ÎÊý
datebase_id: Êý¾Ý¿â±àºÅ£¬¿ÉÒÔʹÓÃdb_id()º¯Êý»ñȡָ¶¨Êý¾Ý¿âÃû¶ÔÓ¦µÄ±àºÅ¡£
object_id: ¸ÃË÷ÒýËùÊô±í»òÊÔͼµÄ±àºÅ
index_id: ¸ÃË÷ÒýµÄ±àºÅ
partition_number:¶ÔÏóÖзÖÇøµÄ±àºÅ
mode:ģʽÃû³Æ,ÓÃÓÚÖ¸¶¨»ñȡͳ¼ÆÐÅÏ¢µÄɨÃè¼¶±ð¡£
ÓйØsys.dm_db_indx_physical_statsµÄ½á¹û¼¯ÖеÄ×Ö¶ÎÃûÈ¥²éÏÂÁª»ú´ÔÊé¡£
---Ë÷ÒýÊÓͼ
Ë÷ÒýÊÓͼÊǾßÌ廯µÄÊÓͼ
--´´½¨Ë÷ÒýÊÓͼ
create view ÊÓͼÃû with schemabinding
as
select Óï¾ä
go
---´´½¨Ë÷ÒýÊÓͼÐèҪעÒâµÄ¼¸µã
1. ´´½¨Ë÷ÒýÊÓͼµÄʱºòÐèÒªÖ¸¶¨±íËùÊôµÄ¼Ü¹¹
--´íÎóд·¨
create view v_f with schemabinding
as
select
a.a,a.b,b.a,b.b
from
&nbs
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
¼ÓÉϱíÃûºÍ±íÃèÊöºóÖ´ÐÐÒÔÏ´洢¹ý³Ì£¬¼´¿ÉΪ±íÌí¼ÓÃèÊö
EXEC
sys.sp_addextendedproperty @name=
N'MS_Description'
,
@value=
N'±íÃèÊö
'
,
@level0type=
N'SCHEMA'
,
@level0name=
N'dbo'
,
@level1type=
N'TABLE'
,
@level1name=
N'±íÃû'
......
create proc dbo.PROC_SQL_COMP @sql1 varchar(8000),@sql2 varchar(8000),@t int
as
/*
µ÷Óãºexec dbo.PROC_SQL_COMP @sql1='',@sql2='',@t=5 & ......
Á¬½Óµ½Êý¾Ý¿â·þÎñÆ÷ͨ³£Óɼ¸¸öÐèÒªºÜ³¤Ê±¼äµÄ²½Öè×é³É¡£ ±ØÐ뽨Á¢ÎïÀíͨµÀ£¨ÀýÈçÌ×½Ó×Ö»òÃüÃû¹ÜµÀ£©£¬±ØÐëÓë·þÎñÆ÷½øÐгõ´ÎÎÕÊÖ£¬±ØÐë·ÖÎöÁ¬½Ó×Ö·û´®ÐÅÏ¢£¬±ØÐëÓÉ·þÎñÆ÷¶ÔÁ¬½Ó½øÐÐÉí·ÝÑéÖ¤£¬±ØÐëÔËÐмì²éÒÔ±ãÔÚµ±Ç°ÊÂÎñÖеǼǣ¬µÈµÈ¡£
ʵ¼ÊÉÏ£¬´ó¶àÊýÓ¦ÓóÌÐò½öʹÓÃÒ»¸ö»ò¼¸¸ö²»Í¬µÄÁ¬½ÓÅäÖᣠÕâÒâζ×ÅÔÚÖ´ÐÐÓ¦ÓóÌÐòÆ ......
Êý¾Ý¿âsqlµÄÌØÊâ×Ö·û£º
1£©µ¥ÒýºÅ’£ºÀýÈçstring a = “this is marry’s book.”;
ʹÓÃinsertʱ¾Í»á³ö´í¡£
½â¾ö£ºa= a.Replace("'","' ......