Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

asp/asp.netÁ¬½Ósql anywhereÊý¾Ý¿â


<%
set conn= server.createobject("ADODB.connection")
conn.open "driver={sybase driver 10};"
"srvr=SYBASE;"
"UID=sa;"
"pwd=sybase;"
sql="select no from tab_stud"
set rs=conn.Execute("sql")
response.write rs
%>
string connStr = "Provider=SAOLEDB.10;uid=dba;pwd=sql;Links=TcpIp(host=192.168.1.2;serverport=2638);eng=mysadb";
                OleDbConnection oleConn = new OleDbConnection(connStr);
                OleDbCommand oleComm = new OleDbCommand("select count(*) from t_test");
                oleComm.Connection = oleConn;
                oleConn.Open();
                Response.Write(oleComm.ExecuteScalar());
                oleConn.Close();
ÆäÖÐÒªµã£¨¾­¶à·½³¢ÊԵóö£©£º°ÑSql anywhereĿ¼win32ÏÂdboledb10.dll£¨°æ±¾Îª10.0.1£©¡¢dboledba10.dll£¨°æ±¾Îª10.0.1£©×¢²áregsvr32 ....
Èç¹ûc:\windows\system32ÏÂûÓÐÕâÁ½¸öÎļþÔò½«Æä¸´ÖƹýÈ¥¡£²âÊÔ10.0.0°æasp.net²»¿ÉÓÃ×ÜÌáʾSAOLEDBδע²á,winform¿ÉÒÔ£¬±ØÐëΪ10.0.1


Ïà¹ØÎĵµ£º

ASP.NETÍøÕ¾¿ª·¢Ð¡½á

1.<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
Vs2005ºìÉ«ÁË£¬ÌáʾÕÒ²»µ½¸ÃÎļþ
ÓÚÊǸÄΪ.<script src="/Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
½á¹ûºìɫûÓÐÁË£¬µ«ÊDZàÒëʱ±¨´í£¬ÕÒ²»µ½¸ÃÎļþ
½áÂÛ£º<script src="Script ......

SQL server 2008 ÆóÒµ°æ

ºú»Ô£º13028803715       0755-82945017
9¡¢ÉîÛÚmicrosoft Windows 2003 Server±¨¼Û ÖÐÎıê×¼°æ5Óû§    4100
10¡¢ÉîÛÚmicrosoft Windws 2003 Server±¨¼Û ÖÐÎÄÆóÒµ°æ25Óû§   20500
11¡¢ÉîÛÚmicrosoft Windows 2008 Server±¨¼Û ÖÐÎıê×¼°æ5Óû§   580 ......

SQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......

SQLÓÅ»¯ Ë÷Òý

(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï×ÖµäµÄÕýÎı ......

jspÓëSQL Server 2000 µÄÁ¬½Ó

ÖÕÓڸ㶨JSPÁ¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌâÁË
2008Äê01ÔÂ29ÈÕ ÐÇÆÚ¶þ 15:54
    ǰ¼¸Ì죬ƽƽͬѧһֱÔÚ¸ãJSP Á¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌ⣬һֱÁ¬²»ÉÏ£¬È»ºó½ÐÎÒÈ¥°ïËû¿´¿´£¬Æ¾×ÅÒÔǰµÄ¾­Ñ飬¸ãÁËÒ»¸öÏÂÎ磬ºÙºÙ£¡ÖÕÓÚ°ïËûÁ¬½ÓÉÏÁË£¬Ö÷Òª²½ÖèÈçÏ£º
    1¡¢ÐèÒªµÄ¶«Î÷´ó¼Ò¿ÉÒÔµ½Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ