| ASP获取数据库字段的名称、类型以及长度 |
<script language="javascript" runAt="server">
7tB1q5 http://blog.numino.net/
/*
EDJy6T http://blog.numino.net/
字段名：Name
WgIQhT http://blog.numino.net/
类型：Type
BnYB03 http://blog.numino.net/
长度：Definedsize
ehYGB5 http://blog.numino.net/
默认值：
EdQEHa http://blog.numino.net/
主键：
N2o2U7 http://blog.numino.net/
说明：
Lhrd9B http://blog.numino.net/
*/
91viM6 http://blog.numino.net/
var AccessTypeName = {
aYyG1Q http://blog.numino.net/
"3": "自动编号/数字",
mCY2W1 http://blog.numino.net/
"6": "货币",
eXXH44 http://blog.numino.net/
"7": "日期/时间",
2VDc34 http://blog.numino.net/
"11": "是/否",
KC3CYk http://blog.numino.net/
"202": "文本",
ko30uC http://blog.numino.net/
"203": "备注/超链接",
4ftZ81 http://blog.numino.net/
"205": "OLE对象"
R4Zrtm http://blog.numino.net/
};
W7TqZs http://blog.numino.net/
var SqlTypeName = {
37u0Pp http://blog.numino.net/
"2": "smallint",
5TgQry http://blog.numino.net/
"3": "int",
KZyKHB http://blog.numino.net/
"4": "real",
cI46wO http://blog.numino.net/
"5": "float",
2r1fyr http://blog.numino.net/
"6": "money/smallmoney",
1ZzDqO http://blog.numino.net/
"11": "bit",
3c3ht9 http://blog.numino.net/
"12": "sql_variant",
GE4lDW http://blog.numino.net/
"17": "tinyint",
d3Jd3o http://blog.numino.net/
"20": "bigint",
lVUJkZ http://blog.numino.net/
"72": "uniqueidentifier",
d3X0Dv http://blog.numino.net/
"128": "binary/timestamp",
us62QN http://blog.numino.net/
"129": "char",
a0tl6d http://blog.numino.net/
"130": "nchar",
fSw0IZ http://blog.numino.net/
"131": "decimal/numeric",
wfA3hz http://blog.numino.net/
"135": "datetime/smalldatetime",
041tPr http://blog.numino.net/
"200": "varchar",
s5Fl40 http://blog.numino.net/
"201": "text",
dX388h http://blog.numino.net/
"202": "nvarchar",
i8fI2p http://blog.numino.net/
"203": "ntext",
vjSxBD http://blog.numino.net/
"204": "varbinary",
2NL603 http://blog.numino.net/
"205": "image"
7mBm1N http://blog.numino.net/
};
P93F4Z http://blog.numino.net/
</script>
Q5E7Az http://blog.numino.net/
|
|