table1
TRUNCATETABLEtable1
24、说明：选择从10到15的记录selecttop5fromselecttop15fromtableorderbyidasctable_别名orderbyiddesc
三、技巧
1、11，12的使用，在SQL语句组合时用的较多
“where11”是表示选择全部
“where12”全部不选，
如：
ifstrWhere
begi

setstrSQLselectcou
tasTotalfromtblNamewherestrW
here
e
d
else
begi

setstrSQLselectcou
tasTotalfromtblName
e
d
我们可以直接写成
错误！未找到目录项。setstrSQLselectcou
tasTotalfromtblNamewhere11安定
fstrWhere2、收缩数据库重建索引DBCCREINDEXDBCCINDEXDEFRAG收缩数据和日志DBCCSHRINKDBDBCCSHRINKFILE3、压缩数据库dbccshri
kdatabasedb
ame4、转移数据库给新用户以已存在用户权限execsp_cha
ge_users_logi
update_o
e
ew
ameold
amego5、检查备份集RESTOREVERIFYONLYfromdiskEdvbbsbak6、修复数据库ALTERDATABASEdvbbsSETSINGLE_USERGODBCCCHECKDBdvbbsrepair_allow_data_lossWITHTABLOCKGOALTERDATABASEdvbbsSETMULTI_USERGO7、日志清除SETNOCOUNTONDECLARELogicalFileNamesys
ame
fMaxMi
utesINTNewSizeINT
USEtable
ame要操作的数据库名SELECTLogicalFileNametable
ame_log日志文件名MaxMi
utes10Limito
timeallowedtowraplog
NewSize1你想设定的日志文件的大小MSetupi
itializeDECLAREOrigi
alSizei
tSELECTOrigi
alSizesize
FROMsysfilesWHERE
ameLogicalFileNameSELECTOrigi
alSizeofdb_
ameLOGisCONVERTVARCHAR30Origi
alSize8KpagesorCONVERTVARCHAR30Origi
alSize81024MBFROMsysfilesWHERE
ameLogicalFileNameCREATETABLEDummyTra
sDummyColum
char8000
ot
ull
DECLARECou
ter
INT
StartTimeDATETIME
Tru
cLogVARCHAR255
fSELECTStartTimeGETDATETru
cLogBACKUPLOGdb_
ameWITHTRUNCATE_ONLY
DBCCSHRINKFILELogicalFileNameNewSizeEXECTru
cLogWrapthelogif
ecessaryWHILEMaxMi
utesDATEDIFFmiStartTimeGETDATEtimehas
otexpired
ANDOrigi
alSizeSELECTsizeFROMsysfilesWHERE
ameLogicalFileName
ANDOrigi
alSize81024NewSizeBEGINOuterloopSELECTCou
ter0WHILECou
terOrigi
alSize16ANDCou
ter50000BEGINupdateINSERTDummyTra
sVALUESFillLogDELETEDummyTra
sSELECTCou
terCou
ter1ENDEXECTru
cLogENDSELECTFi
alSizeofdb_
ameLOGisCONVERTVARCHAR30size8KpagesorCONVERTVARCHAR30size81024MBFROMsysfilesWHERE
ameLogicalFileName
fDROPTABLEDummyTra
sSETNOCOUNTOFF
8、说明：更改某个表execsp_cha
geobjectow
ertable
amedbo
9、存储更改全部表
CREATEPROCEDUREdboUser_Cha
geObjectOw
erBatchOldOw
erasNVARCHAR128NewOw
erasNVr