×Ô¼º×ܽáµÄ²»¶¨Ìõ¼þSQL²éѯÓï¾äµÄд·¨
ÎÒ˵µÄ²»¶¨Ìõ¼þÊÇÖ¸²éѯÌõ¼þµÄ¸öÊý²»¶¨¡£ÓÐʱһ¸ö£¬ÓÐʱÁ½¸ö£¬ÓÐʱºÃ¼¸¸ö¡£
Ê×ÏÈÎÒ·¢ÏÖ
select * from A where a='kkk' Óë
select * from A where a like 'kkk'
ÆäʵЧ¹ûÊÇÒ»Ñù£¬Ö»Òª like ºóÃæµÄ×Ö·û´®²»°üº¬Í¨Åä·û¡£ÕâÑùÒ»À´¾ÍºÜ·½±ãÁË¡£Æ©ÈçÓÐ
select * from A where a='KKK' and b='LLL'
ÓÐÁ½¸ö²éѯÌõ¼þ£¬µ«ÓÐʱºòÓÖÖ»ÐèÒªµÚÒ»¸ö»òÕßµÚ¶þ¸öÌõ¼þ£¬ÓÖ²»ÏëдºÃ¼¸ÌõSQLÓï¾ä¡£Õâʱ¾Í¿ÉÒÔÏȰÑSQL²ÎÊý»¯
select * from A where
a like @a
and
b like @b
°ÑµÈÓÚºÅÌæ»»³É like
È»ºó¸ø²ÎÊýa¸³Öµ£¬ÓÐÁ½ÖÖÑ¡Ôñ£¬ ҪôÊÇ%£¬ÒªÃ´ÊDz»°üº¬Í¨Åä·ûµÄÈκÎ×Ö·û´®¡£²ÎÊýbµÄ¸³ÖµÍ¬Àí¡£
¼ÙÈç¸ø²ÎÊýa¸³ÖµÎª%£¬²ÎÊýb¸³ÖµÎª×Ö·û´®'LLL'£¬ÄÇôʵ¼ÊSQLÓï¾äΪ
select * from A where a like '%' and b like 'LLL' Ï൱ÓÚ
select * from A where b='LLL'£¬Ö»Ê¹ÓÃÁËÒ»¸öÌõ¼þ¡£
Õâ¸öÖ»ÊÊÓÃÓÚ°üº¬×Ö·û´®µÄ²ÎÊýµÄÇé¿ö¡£ÖÁÓÚ·Ç×Ö·û´®µÄÇé¿ö£¬ÎÒ»¹Ã»Óп¼Âǵ½¡£ÔÚVB2008ÖпÉÒÔÕâôÓᣱðµÄûÊÔ¹ý¡£
Ò²ÐíÓÐÈËÔçÒÑÖªµÀ£¬»òÐíÎÒ˵µÄ²»¶Ô£¬»¶ÓÖ¸½Ì¡£
Ïà¹ØÎĵµ£º
һֱûÓÐÕÒµ½Ò»Öֺõķ½·¨À´ÒýÓÃÓзµ»ØÖµµÄ´æ´¢¹ý³ÌµÄ·½·¨£¬Ê¹ÎÒÔÚÌí¼ÓÊý¾ÝÖÐ×ßÁ˲»ÉÙµÄÍä·£¬×î½ü£¬ÔÚ²éÔÄÁË´óÁ¿µÄ×ÊÁÏÖ®ºó£¬ÖÕÓÚÔÚ΢ÈíµÄÒ»¸öʵÀýÖÐÕÒµ½ÁËÒ»ÖÖÁ¼ºÃµÄ·½·¨¡£
Ê×ÏȱàдºÃÒ»Óзµ»ØÖµµÄ´æ´¢¹ý³Ì
create procedure proc_name
@para1 nchar(20), --ÊäÈë²ÎÊý
@ ......
private void Create_Pz(string Sourcename)
{
string OutMsg;
SqlParameter[] sortPara = { new SqlParameter("@ps_IsType", Pz ......
SqlserverÕâ¶«Î÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......
´Ó²©¿ÍÔ°Öп´µ½Ò»ÆªÎÄÕ£¬½éÉÜ´óÈí¼þ¹«Ë¾ÃæÊÔʱ³£³£»á³öµÄÁ½µÀSQLÌ⣨¼û¸½Â¼£©¡£
ÎÒ¾õµÃÊÜÒæºÜ¶à£¬ÔÚ´Ë֮ǰ£¬ÎÒÒ»Ö±¾õµÃ£¬SQL2008ËÆºõÌṩÁËÕâ·½ÃæµÄÖ§³Ö£¬µ«¸üµÍµÄ°æ±¾£¬°üÀ¨2005£¬·ÇÓαê×ö²»³öÀ´£¨Ë®Æ½¹»²Ë£©¡£×ܽáÐĵÃÈçÏ£º
1¡¢ Ç¿´óµÄgroup by
1 select stdname,
2 isnull(sum( ......