aspµ÷ÓÃsql server´æ´¢¹ý³Ì
ASPµ÷Óô洢¹ý³ÌµÄ·½·¨£º
---- ¡¡¡¡µ÷Óô洢¹ý³ÌµÄ·½·¨ÐèҪʹÓÃADOµÄCommand¶ÔÏó¡£Command¶ÔÏóÊǶÔÒ»¸öÊý¾ÝÔ´ÔËÐÐÌض¨ÃüÁîµÄ¶¨Ò壨ÀýÈ磬һ¸öSQL²éѯ»òÒ»¸öSQL´æ´¢¹ý³Ì£©¡£ÏÂÃæÒÔMS SQL SERVER6.5Ϊºǫ́Êý¾Ý¿â£¬½éÉÜASPµ÷Óô洢¹ý³ÌµÄ·½·¨¡£
---- ¡¡¡¡ÀýÈ磬ÔÚ±íUserÖб£´æÁËÓû§ÃûºÍÃÜÂë¡£ÏÖÔÚ½¨Á¢Ò»¸ö¼ì²éÃÜÂëµÄ´æ´¢¹ý³Ìsp_CheckPassÀ´¼ì²éÓû§ÊÇ·ñÊäÈëÁ˺Ϸ¨µÄÃÜÂë¡£½¨Á¢´æ´¢¹ý³Ì£¬¿ÉÒÔ´ÓMicrosoft SQL Sever³ÌÐò×éÖÐÆô¶¯ISQL/w¡£È»ºó£¬ÔÚ²éѯ´°¿ÚÖÐÊäÈë´æ´¢¹ý³Ì£º
/*´æ´¢¹ý³ÌÀý³Ì*/
CREATE PROCEDURE sp_CheckPass
@CHKName VARCHAR(30),@CHKPass VARCHAR(30),
@ISValid CHAR(8) OUTPUT¡¡¡¡
AS
IF EXISTS(SELECT UserName from Users
WHERE UserName=@CHKName AND UserPwd=@CHKPass)
SELECT @ISVaid="pass"
ELSE
SELECT @ISValid="Invalid"
---- ¡¡¡¡´æ´¢¹ý³Ì½ÓÊÕÁ½¸öÊäÈë²ÎÊý¡£ÊäÈë²ÎÊý@CHKNameÏò´æ´¢¹ý³Ì´«µÝÒ»¸öÓû§Ãû¡£@CHKPassÏò´æ´¢¹ý³Ì´«µÝÒ»¸öÃÜÂë¡£Èç¹ûÓÐÓû§ÓµÓÐÖ¸¶¨µÄÃÜÂ룬Êä³ö²ÎÊý½«·µ»Ø“pass"£¬·ñÔò£¬·µ»Ø“Invalid"¡£
---- ¡¡¡¡ÏÖÔÚÎÒÃÇ¿ÉÒÔÔÚCheckPass.aspÖе÷Óô洢¹ý³Ìsp_CheckPass ÁË¡£
CheckPass.asp
< !--#INCLUDE VIRTUAL="ADOVBS.inc"-- > ’
°üº¬VBSCRIPTµÄ³£Á¿¶¨ÒåÎļþ
< %
Set DataConn=Sever.CreateObject("ADODB.Connection")
'½¨Á¢Á¬½Ó¶ÔÏó
Dataconn.Open"DSN=user;SERVER=APP_SERVER;
UID=sa;PWD=;APP=Microsoft(R) Developer Studio;
WSID=APP_SERVER;Regional=Yes"
Set cmdTemp=Sever.CreateObject("ADODB.Command")
'½¨Á¢ÃüÁî¶ÔÏó
Set cmdTemp.ActiveConnection=DataConn
cmdTemp.CommandType=adC
Ïà¹ØÎĵµ£º
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º
--Excel---->SQL2005 µ¼È룺
select * into useinfo from O ......
1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
--²éѯÊý¾Ý
SELECT *
from main_table;
--Ìí¼ÓÊôÐÔ
ALTER TABLE main_table
ADD AcctStop_Time SMALLDATETIME NULL;
--²åÈëÐÂÊý¾Ý
INSERT INTO main_table(Digital_ID, Letter_ID, User_Password, On_Line, IP, AcctStop_Time, FriendTable_UpdaeTime)
VALUES(10000000 + IDENT_CURRENT('main_table') + IDEN ......