07 2012 档案

JS连接数据库“实例”

摘要：示例1：（必须建立ODBC数据源）<HTML><script language=javascript>function connectDb(){var ConnDB = new ActiveXObject("ADODB.Connection"); ConnDB.ConnectionString="dsn=test3d;uid=;pwd=;"; ConnDB.Open();var Rs = new ActiveXObject("ADODB.Recordset");var tempstr=""; 阅读全文

posted @ 2012-07-23 10:51 jude_liu 阅读(801) 评论(0) 推荐(0)

sql数据字典

摘要：1. SqlServer2000数据库字典--表结构.sqlSELECT TOP 100 PERCENT --a.id, s CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS 表名, CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END AS 表说明, a.colorder AS 字段序号, a.name AS 字段名, CASE WHEN COLUMNPROPERTY(a.id, a.name, 'IsIdenti 阅读全文

posted @ 2012-07-17 14:58 jude_liu 阅读(3367) 评论(0) 推荐(0)

导航

07 2012 档案