±¾ÈË×éȺѧϰ£®£Î£Å£Ô»¶Ó£Á£Ó£Ð£®£Î£Å£ÔÐÂÊÖ¼ÓÈ룬£Ñ£ÑȺ100480827
ÓÑÇé°ïÄ㶥Ìù£¬½ñÌ컹û·¢ÌùÄØ£¬ºÇºÇ
°ï¶¥¡£¡£¡£¡£
¶¥ÁË£¡£¡£¡
°ï¶¥¡£
ÓÑÇé°ï¶¥
ÓÑÇé°ï¶¥¡£¡£¡£¡£
¸ù±¾Ã»ÓÐ100480827
ºÎÒâͼ£¿
ÒýÓÃ
±¾ÈË×éȺѧϰ£®£Î£Å£Ô»¶Ó£Á£Ó£Ð£®£Î£Å£ÔÐÂÊÖ¼ÓÈ룬£Ñ£ÑȺ100480827
Â¥Ö÷˵ʵ»°£¬¿ªÈº£¬ÀíÏë¸ ......
ÎÒÒªÔÚ×Ô¼ºÍøÕ¾Éϼ¯³É˳·á¿ìµÝµ¥ºÅ²éѯ ÓÃasp.net ÒªÔõô×ö£¿
˳·á¿ìµÝ¹«Ë¾ÄÇÊDz»ÊÇÓÐ½Ó¿Ú ÏñÍøÒøµÄÄÇÖÖ£¿
¾ßÌ幦ÄÜÒªÔõô×ö£¬ »òÕßÒªÔõôÕÒÕâ·½ÃæµÄ×ÊÁÏ£¿£¨ÎÒÓõÄÊÇasp.net)
°Ù¶È Google ºÃÏñ¶¼ÕÒ²»µ½×ÊÁÏ¡£¡£¡£
......
ÇóÖúÒ»ÌõSQL likeÓï¾ä!
table
ID name bran_id
1 ss 1,2
2 aa 10,13
3 cc 1,13,15
µ±bran_id like 1 µÄʱºò£¬½á¹ûÏÔʾµÄÊÇID=1ºÍµÈÓÚ3µÄ£¬¶ø2²»ÏÔʾÒòΪID=2µÄbran_id,ÊÇ10ºÍ13
ÇëÎÊÎÒÕâÌõSQLÓï¾ä¸ÃÔõôд£¿
×Ô¼º¶¥Ò»ÏÂ
bran_id like '%1,%' or '%,1,%' or '%,1%'
string strlike='1 ......
SQL code:
declare @pagecount int
declare @sql varchar(500)
set @pagecount=10
set @sql='select top '+cast(@pagecount as varchar(10))+' * from book order by [ID] desc'
exec (@sql)
Ö´Ðлᱨ´í¡°ÔÚ½« varchar Öµ 'select top 10 * from book order by [ID] desc' ת»»³ÉÊý¾ÝÀàÐÍ int ʱʧ°Ü¡£¡±
ÇëÎÊÕâ ......
ÎÒµÄÊý¾Ý¿âÖÐÓÐÒ»ÁеÄÖµÊÇ¡°²âÊÔÊÙÃü¡±£¬µ«ÊÇÔÚËü´æ´¢µÄ·½Ê½ºÃÏñÊǵ¥×Ö½Ú¸ñʽ...ÔÚÍâ±ßµÄ²éѯÓï¾äÊÇlike '%²âÊÔÊÙÃü%' Á½¸öû°ì·¨¶Ô±È£¬ÄÇλ´óϺ¸ø³ö¸öת»»µÄ´úÂë...СµÜл¹ýÁË
µ¥×Ö½ÚÓÃlike ? ???
Ö±½ÓÓÃ=ºÅ²»ÐÐÂ𣿣¿£¿
²»ÊǵȺŲ»µÈºÅµÄÎÊÌâ....Êý¾Ý¿âÖÐÊÇÕâÖÖ×Ö·ûÊÙÃü²âÊ ......
¸÷λ´óÏÀ£¬°ï°ïæ¡£±¾È˶ÔjqueryÊÇÒ»Çϲ»Í¨¡£µ«ÊÇÓиö¹¦ÄܱØÐëÒªÓõ½¡£ÏÖÔÚѧΪʱÒÑÍí¡£Ö»ºÃ»Æ°ÁË¡£»µ½ÕâÀﻲ»ÏÂÈ¥ÁË¡£´ó¼Ò°ï°ï棻
´ó¸ÅÊÇÕâÑùµÄ¡£ÎÒÓÐÒ»¸öºÍÅжÏÓû§´æÔÚÒ»ÃþÒ»ÑùµÄ¹¦ÄÜ¡£Ö»ÊÇÎÒÓÐÒ»¸ö²ã¡£Èç¹ûÓû§´æÔڲ㲻ÏÔʾ¡£Óû§²»´æÔÚ²ãÏÔʾ£¬ÆäËûÒѾ×öºÃÁË¡£ÏÖÔھͲîÎÒÔõÑùÓÃifÅжϲãµÄÏÔʾºÍÒþ²ØÁË¡£ ´ÓÎÒÔõÑ ......
×ܼǼÊý:2366; ×ÜÒ³Êý:395; ÿҳ6 Ìõ;
Ê×Ò³ ÉÏÒ»Ò³ [1] [2] 3
[4] [5] [6] [7] [8] [9] [10] ÏÂÒ»Ò³ βҳ