¾¡Á¿²»ÒªÆ´´ÕSqlÓï¾ä,ÓòÎÊýÀ´·À×¢Èë
Èç¹ûÊÇÀàËÆ"select * from user where uid="+uid +" and pwd="+pwd ºÜÈÝÒ׳öÎÊÌâ
ʹÓà SQLParamenter
°ÑÄãµÄSQLÓï¾äд³É ÀàËÆ´æ´¢¹ý³Ì
select * from user where uid=@uid and pwd=@pwd
ʹÓÃÕâ¸öSQLÓï¾ä¶¨ÒåΪ SQLCommand ¶ÔÏó È»ºóʹÓà Paramenter ¶ÔÏó°Ñ @*** Ìæ»»Îª Öµ
¾Í¿ÉÒԸ㶨עÈëʽ©¶´ÁË
Ïà¹ØÎĵµ£º
SQL½ØÈ¡×Ö·û´®
SUBSTRING
·µ»Ø×Ö·û¡¢binary¡¢text »ò image ±í´ïʽµÄÒ»²¿·Ö¡£ÓйؿÉÓë¸Ãº¯ÊýÒ»ÆðʹÓõÄÓÐЧMicrosoft SQL Server Êý¾ÝÀàÐ͵ĸü¶àÐÅÏ¢£¬Çë²Î¼ûÊý¾ÝÀàÐÍ¡£
Óï·¨
SUBSTRING ( expression & ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
±êÇ©£ºÊý¾Ý·ÃÎÊ ADO.NET
Ö±½ÓÖ´ÐÐSQLÃüÁî Ö´ÐÐÃæÏò¼¯ºÏµÄ²Ù×÷£¨ ......
ÓÃSQLÓï¾äÌí¼Óɾ³ýÐÞ¸Ä×Ö¶Î
1.Ôö¼Ó×Ö¶Î
alter table docdsp add dspcode char(200)
alter table tbl add meet_group int2
2.ɾ³ý×Ö¶Î
ALTER TABLE table_NAME DROP COLUMN column_NAME
3.ÐÞ¸Ä×Ö¶ÎÀàÐÍ
&nbs ......