sql server2005Êý¾Ý¿â¼ÓÃÜ - MS-SQL Server / »ù´¡Àà
×öÁËÒ»¸ö¹ÜÀí³ÌÐò
ÏëÈÃÊý¾Ý¿âÓиöÃÜÂë
Ö»ÓÐÊäÈëÃÜÂë²ÅÄܽøÈëÊý¾Ý¿âÖÐ
½øÐÐÐ޸ģ¬
µÚÒ»´Î×öÊý¾Ý¿â£¬ÇëÎÊ´ó¼ÒÈçºÎ¸øÊý¾Ý¿â»òÕß
ÆäÖеıíÉèÖÃÃÜÂ룬ÒÔ·À±ðÈ˵ǽ
1Â¥µÄÄÜÏêϸЩÂð£¿
ûÓп´¶®
º¹ ²»ÊÇÓÀÉú¸çµÄÒâ˼°É
Â¥Ö÷²»±Ø×ö³ÌÐòµÄ£¬sql×Ô´ø·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«£¬Äã¿ÉÒÔÌí¼Ó¸öÓû§£¬ÔÚ·þÎñÆ÷½ÇÉ«ÀïÄÜ¿ØÖÆËûÃǶԱí²Ù×÷µÄȨÏÞ
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡
¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡
Ö±½ÓÖ´ÐоÍÐÐÁË
exec ......
±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......