MSSQL网站制作之X$表

但我们知道，若使用statement，并没有上述需要的数据。试想binlog中记录了一句updatetsetf1=3whereid=3。怎么恢复呢？[K]ernelLayer
[2]-PhaseCommit
[G]lobal[T]ransaction[E]ntry
X$K2GTE-Current2PCtx
X$K2GTE2-Current2PCtx
[C]acheLayer
[B]ufferManagement
Buffer[H]ash
X$BH-HashTable
BufferLRUStatistics
X$KCBCBH-[C]urrent[B]uffers(buckets)-lru_statistics
X$KCBRBH-[R]ecent[B]uffers(buckets)-lru_extended
Buffer[WAIT]s
X$KCBWAIT-Waitsbyblockclass
X$KCBFWAIT-WaitsbyFile
[W]orkingSets-7.3orhigher
X$KCBWDS-Set[D]escriptors
[C]ontrolFileManagement
[C]ontrol[F]ileList-7.0.16orhigher
X$KCCCF-ControlFileNames&status
[D]atabase[I]nformation
X$KCCDI-DatabaseInformation
Data[F]iles
X$KCCFE-File[E]ntries(fromcontrolfile)
X$KCCFN-[F]ile[N]ames
[L]ogFiles
X$KCCLE-LogFile[E]ntries
X$KCCLH-Log[H]istory(archiveentries)
ThreadInformation
X$KCCRT-[R]edo[T]hreadInformation
[F]ileManagement
X$KCFIO-File[IO]Statistics
[L]ockManagerComponent(LCK)
[H]ashandBucketTables-7.0.15to7.1.1,and7.2.0orhigher
X$KCLFH-File[H]ashTable
X$KCLFI-FileBucketTable
X$LE-Lock[E]lements
X$LE_STAT-LockConversion[STAT]istics
X$KCLFX-LockElement[F]reeliststatistics-7.3orhigher
X$KCLLS-PerLCKfreeliststatistics-7.3orhigher
X$KCLQN-[N]ame(hash)tablestatistics-7.3orhigher
[R]edoComponent
[M]ediarecovery-kcra.h-7.3orhigher
X$KCRMF-[F]ilecontext
X$KCRMT-[T]hreadcontext
X$KCRMX-RecoveryConte[X]t
[F]ileread
X$KCRFX-FileReadConte[X]t-7.3orhigher
Reco[V]eryComponent
[F]ile[H]eaders
X$KCVFH-Allfileheaders
X$KCVFHMRR-Fileswith[M]edia[R]ecovery[R]equired
X$KCVFHONL-[ONL]ineFileheaders
[K]ompatibilityManagement-7.1.1orhigher
X$KCKCE-[C]ompatibilitySegment[E]ntries
X$KCKTY-Compatibility[TY]pes
X$KCKFM-Compatibility[F]or[M]ats(indexintoX$KCKCE)
[D]ataLayer
Sequence[N]umberComponent
X$KDNCE-Sequence[C]ache[E]ntries-7.2orlower
[S]equenceEnqueues-commonareaforenqueueobjects
X$KDNSSC-[C]acheEnqueueObjects-7.2orlower
X$KDNSSF-[F]lushEnqueueObjects-7.2orlower
X$KDNST-Cache[ST]atistics-7.2orlower
Inde[X]BlockComponent
X$KDXHS-Index[H]i[S]togram
X$KDXST-Index[ST]atistics
[G]enericLayer
[H]eapManager
X$KGHLU-State(summary)of[L]R[U]heap(s)-definedinksmh.h
[I]nstantiationManager
[C]ursor[C]ache
X$KGICC-Sessionstatistics-definedinkqlf.h
X$KGICS-Systemwidestatistics-definedinkqlf.h
[L]ibraryCacheManager(definedandmappedfromkqlf)
BindVariables
X$KKSBV-LibraryObject[B]ind[V]ariables
ObjectCache
X$KGLOB-All[OB]jects
X$KGLTABLE-Filterfor[TABLE]s
X$KGLBODY-Filterfor[BODY](packages)
X$KGLTRIGGER-Filterfor[TRIGGER]s
X$KGLINDEX-Filterfor[INDEX]es
X$KGLCLUSTER-Filterfor[CLUSTER]s
X$KGLCURSOR-Filterfor[CURSOR]s
CacheDependency
X$KGLDP-Object[D]e[P]endencytable
X$KGLRD-[R]eadonly[D]ependencytable-7.3orhigher
ObjectLocks
X$KGLLK-Object[L]oc[K]s
ObjectNames
X$KGLNA-Object[NA]mes(sqltext)
X$KGLNA1-Object[NA]mes(sqltext)withnewlines-7.2.0orhigher
ObjectPins
X$KGLPN-Object[P]i[N]s
CacheStatistics
X$KGLST-Librarycache[ST]atistics
TranslationTable
X$KGLTR-Address[TR]anslation
AccessTable
X$KGLXS-ObjectAccessTable
AuthorizationTable-7.1.5orhigher
X$KGLAU-ObjectAuthorizationtable
LatchCleanup-7.0.15orhigher
X$KGLLC-[L]atch[C]leanupforCache/PinLatches
[K]ompileLayer
[S]haredObjects
X$KKSAI-Cursor[A]llocation[I]nformation-7.3.2orhigher
[L]oader
[L]ibrary
X$KLLCNT-[C]o[NT]rolStatistics
X$KLLTAB-[TAB]leStatistics
[M]ulti-ThreadedLayer
[C]ircuitcomponent
X$KMCQS-Current[Q]ueue[S]tate
X$KMCVC-[V]irtual[C]ircuitstate
[M]onitorServer/dispatcher
[D]ispatcher
X$KMMDI-[D]ispatcher[I]nfo(status)
X$KMMDP-[D]ispatcherConfig([P]rotocolinfo)
[S]erver
X$KMMSI-[S]erver[I]nfo(status)
X$KMMSG-[SG]ainfo(globalstatistics)
X$KMMRD-[R]equesttiming[D]istributions
s[Q]lVersionandOptionLayer
Kernel[V]ersions
X$VERSION-Libraryversions
Kernel[O]ptions-7.1.3orhigher
X$OPTION-ServerOptions
[Q]ueryLayer
[D]ictionaryCacheManagement
X$KQDPG-[PG]arowcachecursorstatistics
[F]ixedTables/viewsManagement
X$KQFCO-Table[CO]lumndefinitions
X$KQFDT-[D]erived[T]ables
X$KQFSZ-KernelDatastructuretype[S]i[Z]es
X$KQFTA-Fixed[TA]bles
X$KQFVI-Fixed[VI]ews
X$KQFVT-[V]iew[T]extdefinition-7.2.0orhigher
[R]owCacheManagement
X$KQRST-Cache[ST]atistics
X$KQRPD-[P]arentCache[D]efinition-7.1.5orhigher
X$KQRSD-[S]ubordinateCache[D]efinition-7.1.5orhigher
[S]erviceLayer
[B]ackgroundManagement
[D]etachedProcess
X$KSBDD-DetachedProcess[D]efinition(info)
X$KSBDP-Detached[P]rocessDescriptor(name)
X$MESSAGES-BackgroundMessagetable
[I]nstance[M]anagement-7.3orhigher
X$KSIMAT-Instance[AT]tributes
X$KSIMAV-[A]ttribute[V]aluesforallinstances
X$KSIMSI-[S]erialand[I]nstancenumbers
[L]ockManagement
[E]ventWaits
X$KSLED-Event[D]escriptors
X$KSLEI-[I]nstancewidestatistiCSSincestartup
X$KSLES-Current[S]essionstatistics
[L]atches
X$KSLLD-Latch[D]escriptor(name)
X$KSLLT-Latchstatistics[+Childlatches@7.3orhigher]
X$KSLLW-Latchcontext([W]here)descriptors-7.3orhigher
X$KSLPO-Latch[PO]ststatistics-7.3orhigher
X$KSLWSC-No[W]aitand[S]leep[C]ountstatsbyContext-7.3orhigher
[M]emoryManagement
[C]ontextareas
X$KSMCX-E[X]tendedstatisticsonusage-7.3.1orlower
HeapAreas
X$KSMSP-SGAHea[P]
X$KSMPP-[P]GAHea[P]-7.3.2andabove
X$KSMUP-[U]GAHea[P]-7.3.2andabove
X$KSMHP-Any[H]ea[P]-7.3.2andabove
X$KSMSPR-[S]hared[P]ool[R]eservedList-7.1.5orhigher
[L]eastrecentlyusedsharedpoolchunks
X$KSMLRU-LR[U]flushesfromthesharedpool
[S]GAObjects
X$KSMSD-Size[D]efinitionforFixed/Variablesummary
X$KSMSS-Statistics(lengths)ofSGAobjects
SGA[MEM]ory
X$KSMMEM-mapoftheentireSGA-7.2.0orhigher
X$KSMFSV-Addressesof[F]ixed[S]GA[V]ariables-7.2.1orhigher
[P]arameterComponent
X$KSPPI-[P]arameter[I]nfo(Names)
X$KSPPCV-[C]urrentSession[V]alues-7.3.2orabove
X$KSPPSV-[S]ystem[V]alues-7.3.2orabove
En[Q]ueueManagement
X$KSQDN-Global[D]atabase[N]ame
X$KSQEQ-[E]n[Q]ueueObject
X$KSQRS-Enqueue[R]e[S]ource
X$KSQST-Enqueue[S]tatisticsby[T]ype
[U]serManagement
[C]ost
X$KSUCF-Cost[F]unction(resourcelimit)
[L]icence
X$KSULL-Licence[L]imits
[L]anguageManager
X$NLS_PARAMETERS-NLSparameters
X$KSULV-NLS[V]alidValues-7.1.2orhigher
[MY][ST]atistics
X$KSUMYSTA-[MY][ST]atisics(currentsession)
[P]rocessInfo
X$KSUPL-Process(resource)[L]imits
X$KSUPRLAT-[LAT]chHolder
X$KSUPR-Processobject
[R]esource
X$KSURU-Resource[U]sage
[S]tatistics
X$KSUSD-[D]escriptors(statisticnames)&nb两个到底是哪一个给出了MySQL这个名字至今依然是个迷，包括开发者在内也不知道。

一个是把SQL语句写到客户端,可以使用DataSet进行加工;

另一个是把SQL语句写到服务器端,就是所谓的SP(存储过程);

SP4是一个累积性的ServicePack，包含自以前的ServicePack发布以来所有的修补程序（包括MS03-031安全公告）。

对于微软系列的东西除了一遍遍尝试还真没有太好的办法

groupby子句可以将查询结果分组，并返回行的汇总信息Oracle按照groupby子句中指定的表达式的值分组查询结果。

对递归类的树遍历很有帮助。个人感觉这个真是太棒了！阅读清晰，非常有时代感。

Mirror可以算是SQLServer的Dataguard了。但是能不能被大伙用起来就不知道了。

大侠们有推荐的书籍和学习方法写下吧。

记得在最开始使用2k的时候就要用到这个功能，可惜2k没有，现在有了作解决方案的朋友会很高兴吧。