MSSQL网页编程之Ultraedit的SQL Server语法着色模板

Mysql的存储引擎接口定义良好。有兴趣的开发者可以通过阅读文档编写自己的存储引擎。server|模板|语法
为为Ultraedit增加SQLServer语法着色,

增加办法,将有色彩标注部分的笔墨复制到Ultraedit安装文件夹的wordfile.txt文档开端,能够修正笔墨中的白色部分(20)为你想增加的言语编号

更多的语法着色文件能够从以下地点下载:

http://www.ultraedit.com/downloads/additional.html



/L20"SQLServer2000"NocaseBlockCommentOn=/*BlockCommentOff=*/LineComment=--StringChars="FileExtensions=SQLTQL/Delimiters=@%^&*()-+|/[];",./IndentStrings="begin""else"/UnindentStrings="end""else"/FunctionString="%create[a-zA-Z_]*"/C1"Commands"actionaddallalterandanyasascauthorizationavgbackupbeginbetweenbreakbrowsebulkbycascadecasecheckcheckpointcloseclusteredcoalescecollatecolumncommitcommittedcomputeconfirmconstraintcontainscontainstablecontinuecontrolrowconvertcountcreatecrosscurrentcurrent_datecurrent_timecurrent_timestampcurrent_usercursordatabasedbccdeallocatedeclaredefaultdeletedenydescdisablediskdistinctdistributeddoubledropdummydumpelseenableenderrlvlerrorexitescapeexceptexecexecuteexistsexitfetchfilefillfactorfloppyforforeignforward_onlyfreetextfreetexttablefromfullfunctiongogotograntgrouphavingholdlockidentityidentity_insertidentitycolifinindexinnerinsertintersectintoisisolationjoinkeykillleftlevellikelinenoloadmirrorexitmovenationalnonochecknonclusterednotnounloadnullnullifofoffoffsetsononceonlyopenopendatasourceopenqueryopenrowsetoptionororderouteroverpercentpermpermanentpipeplanprecisionprepareprimaryprintprivilegesprocprocedureprocessexitpublicraiserrorreadreadtextread_onlyreconfigurerecoveryreferencesrepeatablereplicationrestorerestrictreturnreturnsrevokerightrollbackrowcountrowguidcolrulesaveschemaselectserializablesession_usersetsetusershutdownsomestatistiCSStatssystem_usertabletapetemptemporarytextsizethentotoptrantransactiontriggertruncatetsequaluncommittedunionuniqueupdateupdatetextuseuservaluesvaryingviewwaitforwhenwherewhilewithworkwritetext

/C2"Datatypes"bigintbinarybitcharcharacterdatetimedecdecimalfloatimageintintegermoneyncharntextnumericnvarcharrealsmalldatetimesmallintsmallmoneysql_variantsysnametexttimestamptinyintuniqueidentifiervarbinaryvarchar

/C3"Storedprocedures"sp_abort_xactsp_add_agent_parametersp_add_agent_profilesp_add_server_sortinfosp_addaliassp_addapprolesp_addarticlesp_adddistpublishersp_adddistributiondbsp_adddistributorsp_addextendedprocsp_addgroupsp_addlinkedserversp_addlinkedsrvloginsp_addloginsp_addmergearticlesp_addmergefiltersp_addmergepublicationsp_addmergepullsubscriptionsp_addmergepullsubscription_agentsp_addmergesubscriptionsp_addmessagesp_addpublicationsp_addpublication_snapshotsp_addpublishersp_addpullsubscriptionsp_addpullsubscription_agentsp_addremoteloginsp_addrolesp_addrolemembersp_addserversp_addsrvrolemembersp_addsubscribersp_addsubscriber_schedulesp_addsubscriptionsp_addsynctriggerssp_addtypesp_addumpdevicesp_addusersp_altermessagesp_approlepasswordsp_article_validationsp_articlecolumnsp_articlefiltersp_articlesynctranprocssp_articleviewsp_attach_dbsp_attach_single_file_dbsp_autostatssp_bindefaultsp_bindrulesp_bindsessionsp_blockcntsp_catalogssp_catalogs_rowsetsp_certify_removablesp_change_subscription_propertiessp_change_users_loginsp_changearticlesp_changedbownersp_changedistpublishersp_changedistributiondbsp_changedistributor_passwordsp_changedistributor_propertysp_changegroupsp_changemergearticlesp_changemergefiltersp_changemergepublicationsp_changemergepullsubscriptionsp_changemergesubscriptionsp_changeobjectownersp_changepublicationsp_changesubscribersp_changesubscriber_schedulesp_changesubscriptionsp_changesubstatussp_check_for_sync_triggersp_check_removablesp_check_removable_sysuserssp_check_sync_triggersp_checknamessp_cleanupwebtasksp_column_privilegessp_column_privileges_exsp_column_privileges_rowsetsp_columnssp_columns_exsp_columns_rowsetsp_commit_xactsp_configuresp_create_removablesp_createorphansp_createstatssp_cursorsp_cursor_listsp_cursorclosesp_cursorexecutesp_cursorfetchsp_cursoropensp_cursoroptionsp_cursorpreparesp_cursorunpreparesp_databasessp_datatype_infosp_db_upgradesp_dbcmptlevelsp_dbfixedrolepermissionsp_dboptionsp_dbremovesp_ddopensp_defaultdbsp_defaultlanguagesp_deletemergeconflictrowsp_denyloginsp_dependssp_describe_cursorsp_describe_cursor_columnssp_describe_cursor_tablessp_detach_dbsp_diskdefaultsp_distcounterssp_drop_agent_parametersp_drop_agent_profilesp_dropaliassp_dropapprolesp_droparticlesp_dropdevicesp_dropdistpublishersp_dropdistributiondbsp_dropdistributorsp_dropextendedprocsp_dropgroupsp_droplinkedsrvloginsp_droploginsp_dropmergearticlesp_dropmergefiltersp_dropmergepublicationsp_dropmergepullsubscriptionsp_dropmergesubscriptionsp_dropmessagesp_droporphanssp_droppublicationsp_droppublishersp_droppullsubscriptionsp_dropremoteloginsp_droprolesp_droprolemembersp_dropserversp_dropsrvrolemembersp_dropsubscribersp_dropsubscriptionsp_droptypesp_dropusersp_dropwebtasksp_dsninfosp_enumcodepagessp_enumcustomresolverssp_enumdsnsp_enumfullsubscriberssp_enumoledbdatasourcessp_executesp_executesqlsp_fallback_MS_sel_fb_svrsp_fetchshowcmdsinputsp_fixindexsp_fkeyssp_foreign_keys_rowsetsp_foreignkeyssp_fulltext_catalogsp_fulltext_columnsp_fulltext_databasesp_fulltext_getdatasp_fulltext_servicesp_fulltext_tablesp_generatefilterssp_get_distributorsp_getarticlepkcolbitmapsp_getbindtokensp_GetMBCSCharLensp_getmergedeletetypesp_gettypestringsp_grant_publication_accesssp_grantdbaccesssp_grantloginsp_helpsp_help_agent_defaultsp_help_agent_parametersp_help_agent_profilesp_help_fulltext_catalogssp_help_fulltext_catalogs_cursorsp_help_fulltext_columnssp_help_fulltext_columns_cursorsp_help_fulltext_tablessp_help_fulltext_tables_cursorsp_help_publication_accesssp_helpallowmerge_publicationsp_helparticlesp_helparticlecolumnssp_helpconstraintsp_helpdbsp_helpdbfixedrolesp_helpdevicesp_helpdistpublishersp_helpdistributiondbsp_helpdistributorsp_helpdistributor_propertiessp_helpextendedprocsp_helpfilesp_helpfilegroupsp_helpgroupsp_helpindexsp_helplanguagesp_helplogsp_helploginssp_helpmergearticlesp_helpmergearticleconflictssp_helpmergeconflictrowssp_helpmergedeleteconflictrowssp_helpmergefiltersp_helpmergepublicationsp_helpmergepullsubscriptionsp_helpmergesubscriptionsp_helpntgroupsp_helppublicationsp_helppublication_snapshotsp_helppublicationsyncsp_helppullsubscriptionsp_helpremoteloginsp_helpreplicationdbsp_helpreplicationdboptionsp_helpreplicationoptionsp_helprolesp_helprolemembersp_helprotectsp_helpserversp_helpsortsp_helpsqlsp_helpsrvrolesp_helpsrvrolemembersp_helpstartupsp_helpsubscribersp_helpsubscriberinfosp_helpsubscriptionsp_helpsubscription_propertiessp_helptextsp_helptriggersp_helpusersp_indexessp_indexes_rowsetsp_indexoptionsp_isarticlecolbitsetsp_IsMBCSLeadBytesp_link_publicationsp_linkedserverssp_linkedservers_rowsetsp_locksp_lockinfosp_logdevicesp_makestartupsp_makewebtasksp_mergedummyupdatesp_mergesubscription_cleanupsp_mergesubscriptioncleanupsp_monitorsp_MS_marksystemobjectsp_MS_replication_installedsp_MS_upd_sysobj_categorysp_MSactivate_auto_subsp_MSadd_distributor_alerts_and_responsessp_MSadd_mergereplcommandsp_MSadd_repl_jobsp_MSaddanonymousreplicasp_MSaddarticletocontentssp_MSaddexecarticlesp_MSaddguidcolumnsp_MSaddguidindexsp_MSaddinitialarticlesp_MSaddinitialpublicationsp_MSaddinitialsubscriptionsp_MSaddlogin_implicit_ntloginsp_MSaddmergepub_snapshotsp_MSaddmergetriggerssp_MSaddpub_snapshotsp_MSaddpubtocontentssp_MSaddupdatetriggersp_MSadduser_implicit_ntloginsp_MSarticlecleanupsp_MSarticletextcolsp_MSbelongssp_MSchange_prioritysp_MSchangearticleresolversp_MScheck_agent_instancesp_MScheck_uid_owns_anythingsp_MScheckatpublishersp_MScheckexistsgenerationsp_MScheckmetadatamatchsp_MScleanup_subscriptionsp_MScleanuptasksp_MScontractsubsnbsp_MScreate_dist_tablessp_MScreate_distributor_tablessp_MScreate_mergesystablessp_MScreate_pub_tablessp_MScreate_replication_checkup_agentsp_MScreate_replication_status_tablesp_MScreate_sub_tablessp_MScreateglobalreplicasp_MScreateretrysp_MSdbuseraccesssp_MSdbuserprivsp_MSdeletecontentssp_MSdeletepushagentsp_MSdeleteretrysp_MSdelrowsp_MSdelsubrowssp_MSdependenciessp_MSdoesfilterhaveparentsp_MSdrop_6x_replication_agentsp_MSdrop_distributor_alerts_and_responsessp_MSdrop_mergesystablessp_MSdrop_objectsp_MSdrop_pub_tablessp_MSdrop_replcomsp_MSdrop_repltransp_MSdrop_rladminsp_MSdrop_rlcoresp_MSdrop_rlreconsp_MSdroparticleprocssp_MSdroparticletombstonessp_MSdroparticletriggerssp_MSdropconstraintssp_MSdropmergepub_snapshotsp_MSdropretrysp_MSdummyupdatesp_MSenum_replication_agentssp_MSenum_replication_jobsp_MSenum3rdpartypublicationssp_MSenumallpublicationssp_MSenumchangessp_MSenumcolumnssp_MSenumdeletesmetadatasp_MSenumgenerationssp_MSenummergepublicationssp_MSenumpartialchangessp_MSenumpartialdeletessp_MSenumpubreferencessp_MSenumreplicassp_MSenumretriessp_MSenumschemachangesp_MSenumtranpublicationssp_MSexists_filesp_MSexpandbelongssp_MSexpandnotbelongssp_MSexpandsubsnbsp_MSfilterclausesp_MSflush_access_cachesp_MSflush_commandsp_MSforeach_workersp_MSforeachdbsp_MSforeachtablesp_MSgen_sync_tran_procssp_MSgenreplnicknamesp_MSgentablenicknamesp_MSget_col_positionsp_MSget_colinfosp_MSget_oledbinfosp_MSget_publisher_rpcsp_MSget_qualifed_namesp_MSget_synctran_commandssp_MSget_typesp_MSgetalertinfosp_MSgetchangecountsp_MSgetconflictinsertprocsp_MSgetlastrecgensp_MSgetlastsentgensp_MSgetonerowsp_MSgetreplicainfosp_MSgetreplnicksp_MSgetrowmetadatasp_MSguidtostrsp_MShelp_distdbsp_MShelp_replication_statussp_MShelpcolumnssp_MShelpfulltextindexsp_MShelpindexsp_MShelpmergearticlessp_MShelpobjectpublicationssp_MShelptypesp_MSIfExistsRemoteLoginsp_MSindexcolfrombinsp_MSindexspacesp_MSinit_replication_perfmonsp_MSinsertcontentssp_MSinsertdeleteconflictsp_MSinsertgenhistorysp_MSinsertschemachangesp_MSis_col_replicatedsp_MSis_pk_colsp_MSkilldbsp_MSload_replication_statussp_MSlocktablesp_MSloginmappingssp_MSmakearticleprocssp_MSmakeconflictinsertprocsp_MSmakeexpandprocsp_MSmakegenerationsp_MSmakeinsertprocsp_MSmakejoinfiltersp_MSmakeselectprocsp_MSmakesystableviewssp_MSmaketempinsertprocsp_MSmakeupdateprocsp_MSmakeviewprocsp_MSmaptypesp_MSmark_proc_noreplsp_MSmatchkeysp_MSmergepublishdbsp_MSmergesubscribedbsp_MSobjectprivssp_MSpad_commandsp_MSproxiedmetadatasp_MSpublicationcleanupsp_MSpublicationviewsp_MSpublishdbsp_MSrefcntsp_MSregistersubscriptionsp_MSreinit_failed_subscriptionssp_MSrepl_addrolemembersp_MSrepl_dbrolesp_MSrepl_droprolemembersp_MSrepl_encryptsp_MSrepl_linkedservers_rowsetsp_MSrepl_startupsp_MSreplcheck_connectionsp_MSreplcheck_publishsp_MSreplcheck_pullsp_MSreplcheck_subscribesp_MSreplicationcompatlevelsp_MSreplrolesp_MSreplsup_table_has_pksp_MSscript_beginprocsp_MSscript_begintrig1sp_MSscript_begintrig2sp_MSscript_delete_statementsp_MSscript_drisp_MSscript_endprocsp_MSscript_endtrigsp_MSscript_insert_statementsp_MSscript_multirow_triggersp_MSscript_paramssp_MSscript_securitysp_MSscript_singlerow_triggersp_MSscript_sync_del_procsp_MSscript_sync_del_trigsp_MSscript_sync_ins_procsp_MSscript_sync_ins_trigsp_MSscript_sync_upd_procsp_MSscript_sync_upd_trigsp_MSscript_trigger_assignmentsp_MSscript_trigger_exec_rpcsp_MSscript_trigger_fetch_statementsp_MSscript_trigger_update_checkssp_MSscript_trigger_updatessp_MSscript_trigger_variablessp_MSscript_update_statementsp_MSscript_where_clausesp_MSscriptdatabasesp_MSscriptdb_workersp_MSsetaccesslistsp_MSsetalertinfosp_MSsetartprocssp_MSsetbitsp_MSsetconflictscriptsp_MSsetconflicttablesp_MSsetfilteredstatussp_MSsetfilterparentsp_MSsetlastrecgensp_MSsetlastsentgensp_MSsetreplicainfosp_MSsetreplicastatussp_MSsetrowmetadatasp_MSsettopologysp_MSsetupbelongssp_MSSQLDMO70_versionsp_MSSQLOLE_versionsp_MSSQLOLE65_versionsp_MSsubscribedbsp_MSsubscriptionssp_MSsubscriptionvalidatedsp_MSsubsetpublicationsp_MStable_has_unique_indexsp_MStable_not_modifiablesp_MStablecheckssp_MStablekeyssp_MStablenamefromnicksp_MStablenicknamesp_MStablerefssp_MStablespacesp_MStestbitsp_MStextcolstatussp_MSunc_to_drivesp_MSuniquecolnamesp_MSuniquenamesp_MSuniqueobjectnamesp_MSuniquetempnamesp_MSunmarkreplinfosp_MSunregistersubscriptionsp_MSupdate_agenttype_defaultsp_MSupdate_replication_statussp_MSupdatecontentssp_MSupdategenhistorysp_MSupdateschemachangesp_MSupdatesysmergearticlessp_msupg_createcatalogcomputedcolssp_msupg_dosystabcatalogupgradessp_msupg_dropcatalogcomputedcolssp_msupg_recreatecatalogfaketablessp_msupg_recreatesystemviewssp_msupg_removesystemcomputedcolumnssp_msupg_upgradecatalogsp_MSuplineageversionsp_MSvalidatearticlesp_OACreatesp_OADestroysp_OAGetErrorInfosp_OAGetPropertysp_OAMethodsp_OASetPropertysp_OAStopsp_objectfilegroupsp_oledbinfosp_passwordsp_pkeyssp_preparesp_primary_keys_rowsetsp_primarykeyssp_probe_xactsp_procedure_params_rowsetsp_procedures_rowsetsp_processinfosp_processmailsp_procoptionsp_provider_types_rowsetsp_publication_validationsp_publishdbsp_recompilesp_refreshsubscriptionssp_refreshviewsp_reinitmergepullsubscriptionsp_reinitmergesubscriptionsp_reinitpullsubscriptionsp_reinitsubscriptionsp_remoteoptionsp_remove_tempdb_filesp_remove_xactsp_removedbreplicationsp_removesrvreplicationsp_renamesp_renamedbsp_replcmdssp_replcounterssp_repldonesp_replflushsp_replicasp_replication_agent_checkupsp_replicationdboptionsp_replicationoptionsp_replincrementlsnsp_replpostcmdsp_replsetoriginatorsp_replshowcmdssp_replsyncsp_repltranssp_replupdateschemasp_reset_connectionsp_revoke_publication_accesssp_revokedbaccesssp_revokeloginsp_runwebtasksp_scan_xactsp_schemata_rowsetsp_script_synctran_commandssp_scriptdelprocsp_scriptinsprocsp_scriptmappedupdprocsp_scriptpkwhereclausesp_scriptupdateparamssp_scriptupdprocsp_sdidebugsp_sem_start_mailsp_server_infosp_serveroptionsp_setapprolesp_setnetnamesp_spaceusedsp_special_columnssp_sproc_columnssp_sqlexecsp_sqlregistersp_srvrolepermissionsp_start_xactsp_stat_xactsp_statisticssp_statistics_rowsetsp_stored_proceduressp_subscribesp_subscription_cleanupsp_subscriptioncleanupsp_table_privilegessp_table_privileges_exsp_table_privileges_rowsetsp_table_validationsp_tableoptionsp_tablessp_tables_exsp_tables_info_rowsetsp_tables_rowsetsp_tempdbspacesp_unbindefaultsp_unbindrulesp_unmakestartupsp_unpreparesp_unsubscribesp_updatestatssp_user_counter1sp_user_counter10sp_user_counter2sp_user_counter3sp_user_counter4sp_user_counter5sp_user_counter6sp_user_counter7sp_user_counter8sp_user_counter9sp_validateloginssp_validlangsp_validnamesp_whosp_who2spt_committabspt_datatype_infospt_datatype_info_extspt_fallback_dbspt_fallback_devspt_fallback_usgspt_monitorspt_provider_typesspt_server_infospt_valuesxp_availablemediaxp_check_query_resultsxp_cleanupwebtaskxp_cmdshellxp_deletemailxp_dirtreexp_displayparamstmtxp_dropwebtaskxp_dsninfoxp_enum_activescriptenginesxp_enum_oledb_providersxp_enumcodepagesxp_enumdsnxp_enumerrorlogsxp_enumgroupsxp_eventlogxp_execresultsetxp_fileexistxp_findnextmsgxp_fixeddrivesxp_get_mapi_default_profilexp_get_mapi_profilesxp_get_tape_devicesxp_getfiledetailsxp_getnetnamexp_grantloginxp_initcolvsxp_intersectbitmapsxp_load_dummy_handlersxp_logeventxp_loginconfigxp_logininfoxp_makewebtaskxp_mergexpusagexp_msverxp_msx_enlistxp_ntsec_enumdomainsxp_ntsec_enumgroupsxp_ntsec_enumusersxp_oledbinfoxp_param_dumpxp_perfendxp_perfmonitorxp_perfsamplexp_perfstartxp_printstatementsxp_proxiedmetadataxp_qvxp_readerrorlogxp_readmailxp_regaddmultistringxp_regdeletekeyxp_regdeletevaluexp_regenumvaluesxp_regreadxp_regremovemultistringxp_regwritexp_revokeloginxp_runwebtaskxp_sendmailxp_servicecontrolxp_showcolvxp_showlineagexp_snmp_getstatexp_snmp_raisetrapxp_sprintfxp_sqlagent_enum_jobsxp_sqlagent_is_startingxp_sqlagent_monitorxp_sqlagent_notifyxp_sqlinventoryxp_sqlmaintxp_sqlregisterxp_sqltracexp_sscanfxp_startmailxp_stopmailxp_subdirsxp_terminate_processxp_test_mapi_profilexp_trace_addnewqueuexp_trace_deletequeuedefinitionxp_trace_destroyqueuexp_trace_enumqueuedefnamexp_trace_enumqueuehandlesxp_trace_eventclassrequiredxp_trace_flushqueryhistoryxp_trace_generate_eventxp_trace_getappfilterxp_trace_getconnectionidfilterxp_trace_getcpufilterxp_trace_getdbidfilterxp_trace_getdurationfilterxp_trace_geteventfilterxp_trace_geteventnamesxp_trace_geteventsxp_trace_gethostfilterxp_trace_gethpidfilterxp_trace_getindidfilterxp_trace_getntdmfilterxp_trace_getntnmfilterxp_trace_getobjidfilterxp_trace_getqueueautostartxp_trace_getqueuecreateinfoxp_trace_getqueuedestinationxp_trace_getqueuepropertiesxp_trace_getreadfilterxp_trace_getserverfilterxp_trace_getseverityfilterxp_trace_getspidfilterxp_trace_gettextfilterxp_trace_getuserfilterxp_trace_getwritefilterxp_trace_loadqueuedefinitionxp_trace_opentracefilexp_trace_pausequeuexp_trace_restartqueuexp_trace_savequeuedefinitionxp_trace_setappfilterxp_trace_setconnectionidfilterxp_trace_setcpufilterxp_trace_setdbidfilterxp_trace_setdurationfilterxp_trace_seteventclassrequiredxp_trace_seteventfilterxp_trace_sethostfilterxp_trace_sethpidfilterxp_trace_setindidfilterxp_trace_setntdmfilterxp_trace_setntnmfilterxp_trace_setobjidfilterxp_trace_setqueryhistoryxp_trace_setqueueautostartxp_trace_setqueuecreateinfoxp_trace_setqueuedestinationxp_trace_setreadfilterxp_trace_setserverfilterxp_trace_setseverityfilterxp_trace_setspidfilterxp_trace_settextfilterxp_trace_setuserfilterxp_trace_setwritefilterxp_trace_startconsumerxp_trace_toeventlogconsumerxp_trace_tofileconsumerxp_unc_to_drivexp_unload_dummy_handlersxp_updatecolvbmxp_updatelineagexp_varbintohexstrxp_writesqlinfo

/C4"Operators"!!=%()+-///<<==>>=[]|LIKE

/C5"SystemTables"deletedinsertedsysallocationssysalternatessysaltfilessyscacheobjectssyscharsetssyscolumnssyscommentssysconfiguressysconstraintssyscurconfigssyscursorcolumnssyscursorrefssyscursorssyscursortablessysdatabasessysdependssysdevicessysfilegroupssysfilessysfiles1sysforeignkeyssysfulltextcatalogssysindexessysindexkeyssyslanguagessyslockinfosyslockssysloginssysmemberssysmessagessysobjectssysoledbuserssysperfinfosyspermissionssysprocessessysprotectssysreferencessysremote_catalogssysremote_column_privilegessysremote_columnssysremote_foreign_keyssysremote_indexessysremote_primary_keyssysremote_provider_typessysremote_schematasysremote_statisticssysremote_table_privilegessysremote_tablessysremote_viewssysremoteloginssyssegmentssysserverssystypessysuserssysxlogins

/C6"GlobalVariables"connectionscpu_busycursor_rowsdatefirstdbtserrorfetch_statusidentityidleio_busylangidlanguagelock_timeoutmax_connectionsmax_precisionnestleveloptionspacket_errorspacket_receivedpack_sentpatindexprocidremserverrowcountservernameservicenamespidtextptrtextsizetextvalidtimetickstotal_errorstotal_readtotal_writetrancountversion

/C7"Functions"absacosapp_nameasciiasinatanatn2avgbinary_checksumcasecastceilingcharindexchecksumchecksum_aggcoalescecollationpropertycol_lengthcol_namecolumns_updatedcolumnpropertyconvertcoscotcountcount_bigcurrent_timestampcurrent_usercursor_statusdatabasepropertydatabasepropertyexdatalengthdateadddatediffdatenamedatepartdaydb_iddb_namedegreesdifferenceexpfile_idfile_namefilegroup_idfilegroup_namefilegrouppropertyfilepropertyfloorfn_helpcollationsfn_listextendedpropertyfn_servershareddrivesfn_trace_geteventinfofn_trace_getfilterinfofn_trace_getinfofn_trace_gettablefn_virtualfilestatsformatmessagefulltextcatalogpropertyfulltextservicepropertygetansinullgetdategetutcdategroupinghas_dbaccesshost_idhost_nameident_currentident_incrident_seedindex_colindexkey_propertyindexpropertyis_memberis_srvrolememberisdateisnullisnumericleftlenloglog10lowerltrimmaxminmonthnewidnullifobject_idobject_nameobjectpropertyparsenamepatindexpermissionspipowerquotenameradiansrandreplacereplicatereverserightroundrowcount_bigrtrimscope_identityserverpropertysessionpropertysession_usersignsinsoundexspacesqaresql_variant_propertysqrtstats_datestdevstdevpstrstuffsubstringsumsuser_sidsuser_snamesystem_usertantypepropertyunicodeupperuser_iduser_namevarvarpyear


提供多语言支持，常见的编码如中文的GB2312、BIG5，日文的Shift_JIS等都可以用作数据表名和数据列名。

一直以来个人感觉SQLServer的优化器要比Oracle的聪明。SQL2005的更是比2k聪明了不少。（有次作试验发现有的语句在200万级时还比50万级的相同语句要快show_text的一些提示没有找到解释。一直在奇怪。）

这就引发了对varchar和char效率讨论的老问题。到底如何分配varchar的数据，是否会出现大规模的碎片？

从项目平台的选择上讲，我们关心的，应该是一款产品能不能满足任务需求，而不是网上怎么说。

个人感觉没有case直观。而且默认的第三字段（还可能更多）作为groupby字段很容易造成新手的错误。

多走走一此相关论坛，多看一些实例开发，多交流0经验，没什么的，我也是刚学没多久!加油

如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。