ããæè¿°ï¼sql server æ°æ®åºä¸ä½¿ç¨æ¡ä»¶æ¥è¯¢å°±å¯ä»¥å®ç°ç¬¦åæ¥è¯¢æ¡ä»¶çæ°æ®è®°å½æ¾ç¤ºåºæ¥ãæ¥è¯¢è¯æ³ä¸ºï¼select * from 表å where å段å=æ¡ä»¶ï¼è¯æ³è¯´æï¼selectåé¢ç*å·ä»£è¡¨çæ¯ææå段æ¾ç¤ºåºæ¥ãæ¡ä»¶åºçæ¡ä»¶å¦æ为å符åæ¡ä»¶éè¦ä½¿ç¨åå¼å·å¼èµ·æ¥ï¼å¦ææ¯intç±»åä¸ç¨å¼å·ï¼ï¼ä»¥ä¸ä»¥ææ°æ®ä¸çä¸å¼ æ°æ®è¡¨user_user为ä¾åï¼åå«ä½¿ç¨ä¸¤ç§æ¥è¯¢æ¹å¼ï¼
ãã1ãå®æ´æ¡ä»¶æ¥è¯¢è¯æ³ä¸ºï¼select * from 表å where å段å=æ¡ä»¶
ããæ¥è¯¢è¯å¥ï¼select * from user_user where Dname='管çå'
ãã2ã模ç³æ¥è¯¢æ¡ä»¶æ¥è¯¢è¯æ³ä¸ºï¼select * from 表å where å段å like '%æ¡ä»¶%' ãè¿éçæ¡ä»¶åªéè¦å ¶ä¸ä¸ä¸ªå符è½å¤ä¸å段ä¸ç符åé½è½å¤æ¾ç¤ºåºæ¥ã
ããæ¥è¯¢è¯å¥ï¼select * from user_user where Dadd like '%è´µ%'
老铁,你好
select * from 表名 where 条件。。。