Display SQL Server Version Information Description Display SQL Server Version Information. Supported Platforms SQL Server 2000 Yes Script Code strDBServerName = "." Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName WScript.Echo "SQL Major Version: " & objSQLServer.VersionMajor WScript.Echo "SQL Minor Version: " & objSQLServer....
Display SQL Server Login Mode. Supported Platforms SQL Server 2000 Yes Script Code SQLDMOSecurity_Integrated = 1 SQLDMOSecurity_Mixed = 2 SQLDMOSecurity_Normal = 0 SQLDMOSecurity_Unknown = 9 strDBServerName = "." Set objSQLServer = CreateObject("SQLDMO.SQLServer") Select Case objSQLServer.ServerLoginMode(strDBServerName) Case SQLDMOSecurity_Integrated WScript.Echo "Lo...
Sample script that displays all of the users in a given SQL Server DB. Supported Platforms SQL Server 2000 Yes Script Code 代码如下:strDBServerName = "." strDBName = "ScriptingGuysTestDB" Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName Set objDB = objSQLServer.Databases(strDBName) Set colUsers = objDB.Users For Each ...
strDBServerName = "." Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName objSQLServer.Shutdown
Sample script that deletes a SQL Server database. Supported Platforms SQL Server 2000 Yes Script Code 代码如下:strDBServerName = "." strDBToDelete = "ScriptingGuysTestDB" Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName objSQLServer.KillDatabase strDBToDelete
dim rs,sql,filename,fso,myfile,x Set fso = server.CreateObject("scripting.filesystemobject") filename = Server.MapPath("download.txt") if fso.FileExists(filename) then fso.DeleteFile(filename) end if '--创建txt文件 set myfile = fso.CreateTextFile(filename,true) Set rs = Server.CreateObject("ADODB.Recordset") sql = "select * from userfile" rs.Open sql,conn,1,1 if rs.EOF and rs.BOF then ...
呵呵,只是证明下漏洞存在 exp如下,保存为vbs,自己下个程序测试自己吧 'From 剑心 '============================================================================ '使用说明: ' 在命令提示符下: ' cscript.exe lbsblog.vbs 要攻击的网站的博客路径 有效的文章id 要破解的博客用户密码 '如: ' cscript.exe lbsblog.vbs www.xxxx.com/blog/ 1 1 ' by loveshell '=============================================================...
其实还可以这样操作: 代码如下: var Room = [ { ID: bot, name: test, sex: true }, { ID: 2, name: test8, sex: true }, { ID: 3, name: test5, sex: false }, { ID: 4, name: test2, sex: true }]; "update Room set name = man where sex=true".executeSQL(); 支持的SQL语句有 SELECT \ INSERT \ UPDATE \ DELETE \ CREATE TABLE \ DROP TABLE 3.上回说道我发现DOM其实也可以用SQL操作 比方说,你可以直接插入100个图片eleme...
比如对javascript数组的排序 还有对数组数据的删选以及分组 所以,后来兴致以上来。 一发不可收拾。 写了一个能在javascript中应用的 SQL 库 后来又想,怎么不能用javascript直接连接数据库呢? 又做了一个javascript直连Sql数据的类库 后来,又想到其实还可以用SQL语句来操作HTML DOM模型 再再再后来,又看到了HTML5中对web DB的实现 所以对webDB,就是chrome和safari中的sqlite的封装 于是乎就有了: 1.从服务器上获取数据、执行...
代码如下: Switch Logo Images 切换 LOGOS title1 = "google"; title2 = "baidu"; logo1 = "images/google.gif"; logo2 = "images/baidu.gif"; function switchlogos() { //alert('switch'); var tmplogo = logo1; var tmptitle = title1; logo1 = logo2; title1 = title2; logo2 = tmplogo; title2 = tmptitle; ("update logolist set src='" + logo1 + "', title='" + title1 + "'").ForDOM().execute(); }; 'create...
代码如下: Marks Count #marks input { width: 100px; } Marks Count Add one line Save Changes By Chinese Math English Desc Asc Order var marks = [ { name: 'Lisi', sex: 'Female', chinese: '88', math: '90', english: '92' }, { name: 'Wangwu', sex: 'Female', chinese: '92', math: '80', english: '82' }, { name: 'Lilei', sex: 'Female', chinese: '93', math: '88', english: '87' }, { ...
代码如下: date_default_timezone_set("PRC"); $host = stripslashes($_POST['host']); if($host == null) { $host = 'localhost'; }; $user = stripslashes($_POST['user']); if($user == null) { $user = 'root'; }; $password = stripslashes($_POST['password']); if($password == null) { $password = ''; }; $database = stripslashes($_POST['database']); if($database == null) { die('DataBase Name Needed!'); }; $SQL ...
接上文说道的JSQL 4.当然随着HTML5的普及,web DB 已经是大势所趋了 所以,JSQL封装到: 代码如下: _CLIENTDATABASE_ = HotelManage; _CLIENTDBVERSION_ = 0.1; _CLIENTDBDESC_ = "First Client DataBase"; _CLIENTDBSIZE_ = 10240; JSQL("create table sqllite(id int)").OnClient().execute(); for (var i = 0; i < 1000; i++) { JSQL("insert into sqllite (id) values ("+i+")").OnClient().execute(); }; var result = ("sel...
从mysql读取某一文本数据,付给js变量比如 代码如下:var strs="苏润葡萄种植园依托沪宁高速和扬溧高速两大交通走廊,紧邻镇荣公路上党镇薛村段,离镇江市仅20公里,交通便利苏润葡萄种植园引进新品种、 新工艺、新技术和现代经营管理体制,采用大棚种植。目前主要品种有五个:夏黑、美人指、贵公子、黄蜜、金手指。苏润葡萄种植园还 ..."; document.write(strs); 却发现火狐下始终报 unterminated string literal错误。把那段文本...
网上搜到的一些关于mysql与mysqli的区别: mysql 是非持继连接函数而 mysqli 是永远连接函数。也就是说 mysql 每次链接都会打开一个连接的进程而 mysqli 多次运行 mysqli 将使用同一连接进程,从而减少了服务器的开销 因为近段时间,网站也因为访问量的增加,而一直被进程占满的问题所困扰。所以,为了减少进程的开销,就为 mayfish 框架添加了一套 mysqli 的驱动。接下来看看如何在mayfish下使用mysqli的驱动进行工作吧。 在 c...