最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
当写的一个用来查看MS sql server表结构的一个脚本(本来打算用来剽窃的)
时间:2008-01-19 编辑:简简单单 来源:一聚教程网
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "ODBC名","用户名","密码"
Sql1="select * from dbo.sysobjects where type not in('S','D','K')"
Sql1="select * from dbo.sysobjects where type ='U'"
set rscc = server.createobject("ADODB.recordset")
set rs = server.createobject("ADODB.recordset")
rscc.open sql1,conn,1,2
do while not rscc.eof
sql ="select * from "&RSCC("name")
rs.open sql,conn,1,2
response.write "
表名"&RSCC("name")&"
"
if "1"="1" then
for i=0 to rs.Fields.Count-1
response.write "字段名:"&rs.fields(i).name &"
"
response.write "类型:"
if rs.fields(i).type="3" then
response.write "int"
if rs.fields(i).Attributes="16" then response.write " 自动编号字段"
if rs.fields(i).Attributes="120" then response.write " 允许空"
if rs.fields(i).Attributes="24" then response.write " 不允许空"
elseif rs.fields(i).type="129" then
response.write "char"
response.write "大小"&rs.fields(i).DefinedSize
if rs.fields(i).Attributes="120" then response.write " 允许空"
-
上一个: 过滤Recordset
-
下一个: 组合查询之核心:拼接字符串
相关文章
- SQL中代替Like语句的另一种写法 01-12
- VBS 批量Ping的项目讲解 09-19
- 如何封装一个Ajax函数介绍 09-16
- ASP实现加法验证码方法 09-16
- ASP错误捕获的几种常规处理方法介绍 09-16
- ajax实现城市三级联动的代码介绍 09-16