创建自定义模板BuildingCustomTemplates

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

December23,2002
UsingandBuildingQueryAnalyzerTemplates
ByGregoryA.Larsen



BuildingCustomTemplates
Bynowyoushouldbesomewhatfamiliarwithusingpre-existingtemplatestobuildyourSQLcode.Itisnowtimetolookathowyoucanleveragetemplatestostreamlineyouradministration.Notonlycanyouuseexistingtemplates,butyoucanalsomodifytheexistingtemplatesandbuildyourownhomegrowntemplates.

comeswithasetoftemplateswhenyouinstallSQLServer.TheMicrosoftsuppliedtemplatesarestored(ifyouusedthedefaultinstallation)inadirectorycalled"C:/ProgramFiles/MicrosoftSQLServer/80/Tools/TemplatesQLQueryAnalyzer/."Inthisdirectorythereareanumberofsubdirectories,oneforeachfolderyouseeontheQATemplatepane.Ifyoudidn'ttakethedefaultwheninstallingSQLServer,youcanfindthetemplatedirectorybysearchingforfilesthathavea"tql"extension.

ForexamplepurposesIamgoingtocreateanewtemplatetosupportcreatingadatabasebackup.Toensurethatmyhomegrowntemplatesarestoredseparatelyfromthestandardones,Iwillbuildanewtemplatefoldertoplacemycustomtemplates.Alltemplatesyoucreatemusthavea"tql"extentioninordertoberecognizedasatemplate.

BeforeIbuildmydatabasebackuptemplate,lcreateanewdirectoryforallmyhomegrowntemplatescalled"MyTemplates."ThisnewdirectoryiscreatedunderthelocationwhereallthestandardMicrosofttemplatesarestored.Inmycase,IwillcreateanewtemplatedirectorycalledC:/ProgramFiles/MicrosoftSQLServer/80/Tools/TemplatesQLQueryAnalyzer/MyTemplates."NowIamreadytobuildatemplate.

ThetemplateIamgoingtocreateiscalled"DatabaseBackupToDiskFile.tql."WhateverInamethetemplateiswhatwillbedisplayedinthe"Template"paneinQA,minusthe"tql"extention.IwilluseNOTEPADtocreatethisnewtemplatethatwillbuildasimple"BACKUPDATABASE"command.Thetemplatebuiltwilllooklikethis:

--=========================================================--Backupdatabasetodiskfile--=========================================================backupdatabasetodisk='<disk_name,varchar(300),C:/mssql/backup/><db_name,varchar(128),dba>_<version,varvhar(100),ADHOC>.bak'



Thistemplatecontainsthreedifferentparameters.Thefirstparameterisdb_nameandisusedtoidentifythedatabasethatwillbebackedup.Asyoucansee,thisparameterisdefinedasavarchar(128),anddefaultsto"DBA."Thesecondparameterisdisk_name,whichdefaultstothestandardplacefordatabasebackupsonmymachine.Thethirdparameterprovidesawaytospecifytheversionnameforthebackup.

NowIwillputthefinaltouchesonthescriptIambuilding.SofarIhaveusedtwostandardtemplatestocreatemyscript,whichcontainsacreatedatabaseandacreatetablestatement.NowIamgoingtousemycustombuilt"DatabaseBackupToDiskFile"templatetoadda"DATABASEBACKUP"commandtotheendofmyscript. 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>