<?xml version="1.0" encoding="UTF-16"?>
<GLFUNCTIONS>
<LABEL> 公用对象 <!-- _locID_text="Common Objects" -->
</LABEL>
<FUNC_GRP>
<LABEL> 配置函数 <!-- _locID_text="Configuration Functions" -->
</LABEL>
<FUNCTION>
<NAME>@@CONNECTIONS</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>int</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>已打开或试图打开的连接数目<!-- _locID_text="Number of opened or attempted connections" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@DATEFIRST</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>tinyint</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>SET DATEFIRST 参数的当前值<!-- _locID_text="Current value of the SET DATEFIRST parameter" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@DBTS</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>varbinary</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>timestamp 数据类型的当前值<!-- _locID_text="Current value of the timestamp data type" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@LANGUAGE</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>nvarchar</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>当前使用的语言的名称<!-- _locID_text="Name of the language currently in use" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@LANGID</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>smallint</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>当前使用的语言的 ID<!-- _locID_text="ID of the language currently in use" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@LOCK_TIMEOUT</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>int</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>用于当前会话的锁定超时设置<!-- _locID_text="Lock time-out setting for the current session" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@MAX_CONNECTIONS</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>int</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>同时用户连接的最大数目<!-- _locID_text="Max number of simultaneous user connections" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@MAX_PRECISION</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>tinyint</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>decimal 和 numeric 数据类型所采用的精度级别<!-- _locID_text="Precision level used by decimal and numeric data types" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@NESTLEVEL</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>int</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>当前存储过程执行的嵌套级<!-- _locID_text="Nesting level of the current store procedure execution" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@OPTIONS</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>int</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>有关当前 SET 选项的信息<!-- _locID_text="Information about the current SET options" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@REMSERVER</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>nvarchar(128)</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>远程 SQL Server 数据库服务器的名称<!-- _locID_text="Name of the remote SQL Server database server" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@SPID</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>smallint</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>当前用户进程的 ID<!-- _locID_text="ID of the current user process" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@SERVERNAME</NAME>
<PARAM>
<NAME>RETURN_VALUE</NAME>
<TYPE>nvarchar</TYPE>
<DIRECTION>RETURN_VALUE</DIRECTION>
</PARAM>
<TOOLTIP>运行 SQL Server 的本地服务器的名称<!-- _locID_text="Name of the local server running SQL Server" --></TOOLTIP>
</FUNCTION>
<FUNCTION>
<NAME>@@SERVICENAME</NAME>
<PARAM>
<NAME>RETURN_V�
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
isqlw 简易版查询分析器.rar (92个子文件)
isqlw
isqlw
odbcbcp.dll 24KB
sqlgui.dll 444KB
SQLDMO.dll 4.16MB
Resources
2052
pfclnt80.rll 28KB
sqlsvc.RLL 24KB
sqlqry.rll 180KB
objmgr.RLL 56KB
sqlgui.rll 56KB
SQLDMO.RLL 572KB
profiler.rll 164KB
pfutil80.rll 144KB
semsfc.rll 24KB
isqlw.rll 240KB
Templates
SQL Query Analyzer
Manage Linked Server
Configure Linked Server.tql 313B
Add non-Sql Server as Linked Server.tql 792B
Drop Linked Server.tql 389B
Add Linked Server Login.tql 423B
Drop Linked Server Login.tql 269B
Add Sql Server as Linked Server.tql 367B
Create Table
Create Table with ROWGUIDCOL Column.tql 570B
Create Table Basic Template.tql 498B
Create Table with Computed Column.tql 497B
Create Temp Table.tql 314B
Create Table Specifying File Groups.tql 607B
Create Table with IDENTITY Column.tql 546B
Create Table Specifying Constrains.tql 644B
Attach and Detach Database
Detach_Database_Template.tql 279B
Attach_Database_Template.tql 454B
Attach_Single_File_Database_Template.tql 491B
Create Index
Create Index Full Syntax.tql 530B
Create Index Basic.tql 354B
Create Database
Create Database Specifying Collation.tql 668B
Create Database for ATTACH.tql 481B
Create Database on Multiple Data and Transaction Log Files.tql 1KB
Create Database Basic Template.tql 361B
Create Database on Mulitple File Groups.tql 2KB
Using Cursor
Declare and Use READ_ONLY Cursor.tql 798B
Declare and Use SCROLL Cursor with Various FETCH Options.tql 1KB
Declare and Use UPDATE Cursor.tql 1KB
Declare and Use KEYSET Cursor.tql 864B
Create Function
Create Scalar Function.tql 940B
Create Inline Function.tql 849B
Create Table Function.tql 1KB
Create Statistics
Create Statistics Template.tql 299B
Create Trigger
Create INSTEAD OF Trigger Basic Template.tql 511B
Create Trigger Contained IF COLUMNS_UPDATED.tql 668B
Create Trigger Contained IF UPDATE.tql 648B
Create Trigger Basic Template.tql 513B
Create View
Create View with CHECK OPTION.tql 439B
Create View with SCHEMABINDING.tql 600B
Create View Basic Template.tql 416B
Manage Login Role User
Revoke Database Access From Windows User or Sql Server Login.tql 274B
Drop Login from Server Role.tql 286B
Grant Sql Server Access to Windows User or Group.tql 236B
Drop User from Database Role.tql 260B
Grant Database Access to Windows User or Sql Server Login.tql 307B
Add Sql Server Login.tql 467B
Add Login to Server Role.tql 282B
Add User to Database Role.tql 256B
Drop Sql Server Login.tql 201B
Deny Sql Server Access to Windows User or Group.tql 234B
Revoke Sql Server Access from Windows User or Group.tql 238B
Manage Extended Property
Add Extended Property.tql 433B
List Extented Property.tql 397B
Update Extended Property.tql 447B
Drop Extended Property.tql 403B
Create Procedure
Create Procedure Basic Template.tql 873B
Create Procedure with CURSOR OUTPUT Parameter.tql 1KB
Create Procedure with OUTPUT Parameter.tql 1KB
SQL Profiler
SQLProfilerTuning.tdf 269B
SQLProfilerTSQL_Duration.tdf 269B
SQLProfilerStandard.tdf 299B
SQLProfilerTSQL_SPs.tdf 329B
SQLProfilerTSQL_Replay.tdf 379B
SQLProfilerTSQL_Grouped.tdf 299B
SQLProfilerTSQL.tdf 299B
SQLProfilerSP_Counts.tdf 259B
objmgr80.xml 183KB
sqlsvc.dll 92KB
sqlqry.dll 392KB
pfclnt80.dll 404KB
sqlunirl.dll 177KB
objmgr.dll 308KB
sqllex.dll 148KB
Reg.Bat 585B
sqlresld.dll 28KB
w95scm.dll 48KB
isqlw.exe 348KB
profiler.exe 356KB
pfutil80.dll 268KB
Bak.reg 1002B
semsfc.dll 224KB
共 92 条
- 1
资源评论
- my988002018-08-03不错,蛮实用的
- MNU木木先生2015-01-13SQL2000的 没啥用~
- cgwangjun2016-09-08用得可以 如果有对照的DB安装就好了
SevenCC_20
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功