转至繁体中文版     | 网站首页 | 文章中心 | 下载中心 | 图片中心 | 笑话频道 | 教程频道 | 会员中心 | 雁过留声 | 
最新公告:     "MinTao学以致用网"欢迎您的光临,你的支持便是我们的动力,欢迎广大网友和各界人士亲临指导,你们的一个小小的建议便是我们发展的开路石!  [MinTao  2007年9月5日]        
您现在的位置: MinTao学以致用网 >> 文章中心 >> 电子课堂 >> 数据库 >> Sql Server >> 文章正文
专题栏目
更多内容
最新推荐 更多内容
相关文章
SQL Server的存储过程调
SQL Server安全性简介
SQL 语法参考手册
MS SQL Sever 7.0 存储引
SQL SERVER和SYBASE
SQL Server 7.0数据库的
VB应用程序访问SQL Serv
将DBF数据库转换成SQL S
拷贝的SQL Server 7数据
浅谈优化SQL Server数据
更多内容
Ultraedit的SQL Server语法着色模板         
Ultraedit的SQL Server语法着色模板
作者:zjcxc 文章来源:不详 点击数: 更新时间:2007-11-14 13:06:30
mittab spt_datatype_info spt_datatype_info_ext spt_fallback_db spt_fallback_dev spt_fallback_usg spt_monitor spt_provider_types spt_server_info spt_values
xp_availablemedia xp_check_query_results xp_cleanupwebtask xp_cmdshell xp_deletemail xp_dirtree xp_displayparamstmt xp_dropwebtask xp_dsninfo xp_enum_activescriptengines
xp_enum_oledb_providers xp_enumcodepages xp_enumdsn xp_enumerrorlogs xp_enumgroups xp_eventlog xp_execresultset xp_fileexist xp_findnextmsg xp_fixeddrives
xp_get_mapi_default_profile xp_get_mapi_profiles xp_get_tape_devices xp_getfiledetails xp_getnetname xp_grantlogin xp_initcolvs xp_intersectbitmaps xp_load_dummy_handlers
xp_logevent xp_loginconfig xp_logininfo xp_makewebtask xp_mergexpusage xp_msver xp_msx_enlist xp_ntsec_enumdomains xp_ntsec_enumgroups xp_ntsec_enumusers xp_oledbinfo
xp_param_dump xp_perfend xp_perfmonitor xp_perfsample xp_perfstart xp_printstatements xp_proxiedmetadata xp_qv xp_readerrorlog xp_readmail xp_regaddmultistring xp_regdeletekey
xp_regdeletevalue xp_regenumvalues xp_regread xp_regremovemultistring xp_regwrite xp_revokelogin xp_runwebtask xp_sendmail xp_servicecontrol xp_showcolv xp_showlineage
xp_snmp_getstate xp_snmp_raisetrap xp_sprintf xp_sqlagent_enum_jobs xp_sqlagent_is_starting xp_sqlagent_monitor xp_sqlagent_notify xp_sqlinventory xp_sqlmaint xp_sqlregister
xp_sqltrace xp_sscanf xp_startmail xp_stopmail xp_subdirs xp_terminate_process xp_test_mapi_profile xp_trace_addnewqueue xp_trace_deletequeuedefinition xp_trace_destroyqueue
xp_trace_enumqueuedefname xp_trace_enumqueuehandles xp_trace_eventclassrequired xp_trace_flushqueryhistory xp_trace_generate_event xp_trace_getappfilter
xp_trace_getconnectionidfilter xp_trace_getcpufilter xp_trace_getdbidfilter xp_trace_getdurationfilter xp_trace_geteventfilter xp_trace_geteventnames xp_trace_getevents
xp_trace_gethostfilter xp_trace_gethpidfilter xp_trace_getindidfilter xp_trace_getntdmfilter xp_trace_getntnmfilter xp_trace_getobjidfilter xp_trace_getqueueautostart
xp_trace_getqueuecreateinfo xp_trace_getqueuedestination xp_trace_getqueueproperties xp_trace_getreadfilter xp_trace_getserverfilter xp_trace_getseverityfilter
xp_trace_getspidfilter xp_trace_gettextfilter xp_trace_getuserfilter xp_trace_getwritefilter xp_trace_loadqueuedefinition xp_trace_opentracefile xp_trace_pausequeue
xp_trace_restartqueue xp_trace_savequeuedefinition xp_trace_setappfilter xp_trace_setconnectionidfilter xp_trace_setcpufilter xp_trace_setdbidfilter xp_trace_setdurationfilter
xp_trace_seteventclassrequired xp_trace_seteventfilter xp_trace_sethostfilter xp_trace_sethpidfilter xp_trace_setindidfilter xp_trace_setntdmfilter xp_trace_setntnmfilter
xp_trace_setobjidfilter xp_trace_setqueryhistory xp_trace_setqueueautostart xp_trace_setqueuecreateinfo xp_trace_setqueuedestination xp_trace_setreadfilter
xp_trace_setserverfilter xp_trace_setseverityfilter xp_trace_setspidfilter xp_trace_settextfilter xp_trace_setuserfilter xp_trace_setwritefilter xp_trace_startconsumer
xp_trace_toeventlogconsumer xp_trace_tofileconsumer xp_unc_to_drive xp_unload_dummy_handlers xp_updatecolvbm xp_updatelineage xp_varbintohexstr xp_writesqlinfo

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

/C5"System Tables"
deleted
inserted
sysallocations sysalternates sysaltfiles syscacheobjects syscharsets syscolumns syscomments sysconfigures sysconstraints syscurconfigs syscursorcolumns syscursorrefs
syscursors syscursortables sysdatabases sysdepends sysdevices sysfilegroups sysfiles sysfiles1 sysforeignkeys sysfulltextcatalogs sysindexes sysindexkeys syslanguages
syslockinfo syslocks syslogins sysmembers sysmessages sysobjects sysoledbusers sysperfinfo syspermissions sysprocesses sysprotects sysreferences
sysremote_catalogs sysremote_column_privileges sysremote_columns
sysremote_foreign_keys
sysremote_indexes
sysremote_primary_keys sysremote_provider_types
sysremote_schemata sysremote_statistics
sysremote_table_privileges sysremote_tables sysremote_views
sysremotelogins
syssegments
sysservers
systypes
sysusers
sysxlogins

/C6"Global Variables"
connections cpu_busy cursor_rows
datefirst dbts
error
fetch_status
identity idle io_busy
langid language lock_timeout
max_connections max_precision
nestlevel
options
packet_errors packet_received pack_sent patindex procid
remserver rowcount
servername servicename spid
textptr textsize textvalid timeticks total_errors total_read total_write trancount
version

/C7"Functions"
abs acos app_name ascii asin atan atn2 avg
binary_checksum
case cast ceiling charindex checksum checksum_agg
coalesce collationproperty col_length col_name columns_updated columnproperty convert cos cot count count_big current_timestamp current_user cursor_status
databaseproperty databasepropertyex datalength dateadd datediff datename datepart day db_id db_name degrees difference
exp
file_id file_name filegroup_id filegroup_name filegroupproperty fileproperty floor
fn_helpcollations fn_listextendedproperty fn_servershareddrives fn_trace_geteventinfo fn_trace_getfilterinfo fn_trace_getinfo fn_trace_gettable fn_virtualfilestats
formatmessage fulltextcatalogproperty fulltextserviceproperty
getansinull getdate getutcdate grouping
has_dbaccess host_id host_name
ident_current ident_incr ident_seed index_col indexkey_property indexproperty is_member is_srvrolemember isdate isnull isnumeric
left len log log10 lower ltrim
max min month
newid nullif
object_id object_name objectproperty
parsename patindex permissions pi power
quotename
radians rand replace replicate reverse right round rowcount_big rtrim
scope_identity serverproperty sessionproperty session_user sign sin soundex space sqare sql_variant_property
sqrt stats_date stdev stdevp str stuff substring sum suser_sid suser_sname system_user
tan typeproperty
unicode upper user_id user_name
var varp
year

上一页  [1] [2] [3] 

文章录入:mintao    责任编辑:mintao 
  • 上一篇文章:

  • 下一篇文章:
  • 【字体: 】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口
      注:本站部分文章源于互联网,版权归原作者所有!如有侵权,请原作者与本站联系,本站将立即删除! 本站文章除特别注明外均可转载,但需注明出处! [MinTao学以致用网]
      网友评论:(只显示最新10条。评论内容只代表网友观点,与本站立场无关!)

    | 设为首页 |加入收藏 | 联系站长 | 友情链接 | 版权申明 | 广告服务
    MinTao学以致用网

    Copyright @ 2007 MinTao学以致用网(www.mintao.net) Inc All Rights Reserved.
    QQ:543098146有事请Q我! QQ:261561092有事请Q我 QQ:179647303有事请Q我 MSN:min906@126.com
    站长:MinTao 信息产业部ICP备案号:鄂ICP备07500065号

    学以致用是我们学习者的至高境界和不懈追求,[MinTao学以致用网]与大家共同学习,共同进步……
    信息产业部备案
    *鄂ICP备07500065号