ASP³ÌÐòÓëSQL´æ´¢¹ý³ÌÏê½â
´æ´¢½ø³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢½ø³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL SERVER)¡£Èç¹ûÎÒÃÇͨ¹ý´´½¨´æ´¢½ø³ÌÒÔ¼°ÔÚASPÖе÷Óô洢½ø³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓÔÚÒ»Æð¡£ÕâÑù×öµÄºÃ´¦ÖÁÉÙÓÐÈý¸ö£º
µÚÒ»¡¢´ó´óÌá¸ßЧÂÊ¡£´æ´¢½ø³Ì±¾ÉíµÄÖ´ÐÐËٶȷdz£¿ì£¬¶øÇÒ£¬µ÷Óô洢½ø³Ì¿ÉÒÔ´ó´ó¼õÉÙͬÊý¾Ý¿âµÄ½»»¥´ÎÊý¡£
µÚ¶þ¡¢Ìá¸ß°²È«ÐÔ¡£¼ÙÈ罫SQLÓï¾ä»ìºÏÔÚASP´úÂëÖУ¬Ò»µ©´úÂëʧÃÜ£¬Í¬Ê±Ò²¾ÍÒâζ×Å¿â½á¹¹Ê§ÃÜ¡£
µÚÈý¡¢ÓÐÀûÓÚSQLÓï¾äµÄÖØÓá£
ÔÚASPÖУ¬Ò»°ãͨ¹ýCOMMAND¶ÔÏóµ÷Óô洢½ø³Ì£¬¸ù¾Ý²»Í¬Çé¿ö£¬±¾ÎÄÒ²½éÉÜÆäËüµ÷Ó÷½·¨¡£ÎªÁË·½±ã˵Ã÷£¬¸ù¾Ý´æ´¢½ø³ÌµÄÊäÈëÊä³ö£¬×÷ÒÔϼòµ¥·ÖÀࣺ
1. Ö»·µ»Øµ¥Ò»¼Ç¼¼¯µÄ´æ´¢½ø³Ì
¼ÙÉèÓÐÒÔÏ´洢½ø³Ì(±¾ÎĵÄÄ¿µÄ²»ÔÚÓÚ½²ÊöT-SQLÓï·¨£¬ËùÒÔ´æ´¢½ø³ÌÖ»¸ø³ö´úÂ룬²»×÷˵Ã÷)£º
/*SP1*/
CREATE PROCEDURE DBO.GETUSERLIST
AS
SET NOCOUNT ON
BEGIN
SELECT * from DBO.[USERINFO]
END
GO
ÒÔÉÏ´æ´¢½ø³ÌÈ¡µÃUSERINFO±íÖеÄËùÓмǼ£¬·µ»ØÒ»¸ö¼Ç¼¼¯¡£Í¨¹ýCOMMAND¶ÔÏóµ÷Óøô洢½ø³ÌµÄASP´úÂëÈçÏÂ:
'**ͨ¹ýCOMMAND¶ÔÏóµ÷Óô洢½ø³Ì**
DIM MYCOMM,MYRST
SET MYCOMM = SERVER.CREATEOBJECT("ADODB.COMMAND")
MYCOMM.ACTIVECONNECTION = MYCONSTR 'MYCONSTRÊÇÊý¾Ý¿âÁ¬½Ó×Ö´®
MYCOMM.COMMANDTEXT = "GETUSERLIST" 'Ö¸¶¨´æ´¢½ø³ÌÃû
MYCOMM.COMMANDTYPE = 4 &nb
Ïà¹ØÎĵµ£º
ÔÎÄ´«ËÍÃÅ£ºhttp://topic.csdn.net/u/20091119/17/388cd1dd-4018-403f-a97f-0bc135895264.html?85256
Êý¾Ý¿âÀýÈç:
id ÐÕ Ãû ½± ½ð
1 ÕÅÈý 20Íò
2 ÀîËÄ 10Íò
3   ......
MySQLÌṩ±ê×¼µÄSQLģʽƥÅ䣬ÒÔ¼°Ò»ÖÖ»ùÓÚÏóUnixʵÓóÌÐòÈçvi¡¢grepºÍsedµÄÀ©Õ¹ÕýÔò±í´ïʽģʽƥÅäµÄ¸ñʽ¡£ ±ê×¼µÄSQLģʽƥÅä
SQLµÄģʽƥÅäÔÊÐíÄãʹÓÓ_”Æ¥ÅäÈκε¥¸ö×Ö·û£¬¶ø“%”Æ¥ÅäÈÎÒâÊýÄ¿×Ö·û(°üÀ¨Áã¸ö×Ö·û)¡£ÔÚ MySQLÖУ¬SQLµÄģʽȱʡÊǺöÂÔ´óСдµÄ¡£ÏÂÃæÏÔʾһЩÀý×Ó¡£×¢ÒâÔÚÄãÊ ......
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER TABLE --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹
CREATE VIEW --´´½¨Ò»¸öÊÓÍ ......
ÔÚSQL Server Management StudioÖÐÁ¬½Óµ½SQL ServerʵÀýºó£¬»áÏÔʾ“SQL Server ´úÀ픽ڵ㡣Èç¹ûµ±Ç°¸ÃʵÀýµÄAgent·þÎñûÓÐÆô¶¯£¬“SQL Server ´úÀ픺ó±ß¾Í»áÏÔʾ“(ÒѽûÓôúÀí¡¡XP)”¡£“ÒѽûÓôúÀí”´Ó×ÖÃæÉϲ»ÄÑÀí½â£¬ºó±ßµÄ“XP”ÓеãÈÃÈ˷ѽâÁË£¬Õâ¸ö·þÎñ¸úWindo ......