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£ºÊ ......
1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......
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 ......
Sql Serverͬ±íÄڵļ¶ÁªÅÅÐò£¨¼´Í¬¸¸¼¶±ðµÄ×Ó½Úµã×ÔÐа´1~NÅÅÐò£©,2005°æ±¾ÒѾ×Ô´øÁËROW_NUMBER() OVER×Ӿ䣬¿ÉÒԺܷ½±ãµØʵÏÖЧ¹û¡£µ«ÊÇ2000°æ±¾²»Ö§³ÖÕâÖÖ×ö·¨£¬²»¹ýÒ²¿ÉÒÔ²ÉÈ¡ÌØÊâ×ö·¨
--slq2005
select rd.id,r.id ruleId,ROW_NUMBER() OVER(
PARTITION BY r.id
ORDER BY ......