SQL°æÍí¼äÐÂÎÅ
±¾½ÚÄ¿ÓÉ£º
±í½ã ×ÔÐŵÄÅ®ÈË×îÃÀÀö
Ê÷¸ç Ê®ÄêÊ÷ľ£¬°ÙÄêÊ÷ÈË
Ë®¸ç ˮˮ¸ü½¡¿µ
ÁªºÏÔÞÖú²¥³ö
----------------------------------------------------------------------------------------------------
¹ÛÖÚÅóÓÑÍíÉϺ㬽ñÌìÊÇ2009Äê9ÔÂ14ºÅ£¬Å©ÀúÆßÔ¶þÊ®Áù¡£»¶ÓÊÕ¿´Íí¼äÐÂÎÅ£¬ÎÒÊÇ¿¾Ñ¼
±¾Ê±¶ÎµÄÖ÷ÒªÄÚÈÝÓУº
¡¾°æÄÚÒªÎÅ¡¿
ÎÒ°æÃñ¾¯¿ªÕ¹ÐÂÒ»ÂÖɨ»Æ´ò·ÇÐж¯£¬ÈºÖÚ½»Ê׳ÆÔÞ
µçÊǪ́³¤Å³âÐÐÒµ¸¡¿äÐé¼ÙÖ®·ç£ºÄãÃǵÄרҵ¾«ÉñÔÚÄÄ£¿
±¾Ì¨¼ÇÕßÒªÇóÕþ¸®¹«²¼ÀúÊ·×ÊÁÏ£¬Õþ¸®·¢ÑÔÈËÓèÒÔ»ØÓ¦
¡¾ÓéÀÖ°ËØÔ¡¿
ʧÁµ²»Ê§²Å£¬ÉËÐÄÃÀÄÐ×Ó»¯±¯Í´Îª×÷Æ·
СѧÌâÄ¿Äѵ¹Î¢ÈíMVP £¬¡°°®ÇéʹÈ˱äɵ¡±µÃµ½ÁÙ´²ÑéÖ¤
Ò»¿ÅÌǹûÒý·¢Éç»á´óÌÖÂÛ£ºÎÒÃǸÃÈú¢×Óѧ»áʲô
Å®×ÓÕ÷»é£º³ÏÕ÷·¿×ÓÒ»Ãû
¶Ô¶Ô×Ó½âѹÁ¦·¨ÎÊÊÀ£¬×¨¼Ò³ÆÓÐÍûÌæ´úÄó·½±ãÃæ¡£ÌåÑéÕߣº¶ÔÍêÒÔºó¸üÀÛÁË
----------------------------------------------------------------------------------------------------
¹ã¸æÍ¬Ñù¾«²Ê
С°®£ºÕæÐÄʵÒâÕÒʦ¸µ
ZS£ºÕ÷»é¡£ÒªÇó£ºÅ®µÄ£¬»îµÄ¡£
±í½ã£º³ÁÓãÂäÑã±ÕÔÂÐß»¨ÎÂÈá¶ËׯÊÊÁäÅ®Ñý³ÏÕ÷ÌÆÉ®Ò»Ãû
С³æ:³ÏÕ÷ÊÊÁä´ÆÐÔС³æÒ»Ãû¹²¶ÈÓàÉú£¬ÒªÇó£ºÉ«ÔóÏÊÁÁ£¬ÅÀÐÐËÙ¶ÈÖеȣ¬ÉíÌ彡¿µÎÞÒìζ
----------------------------------------------------------------------------------------------------
»¶Ó»ØÀ´
ÏÂÃæ¹Ø×¢Ò»ÏÂÃ÷ÌìµÄÌìÆø£º
ÇïÌìµ½ÁËÌìÆø¿ªÊ¼±äÀ䣬Çë´ó¼Ò×¢Òâ·Àº®¹ã¶«Ò»´øµÄÅóÓÑÇëÎÞÊÓ
ÒÔÉϾÍÊDZ¾´ÎÐÂÎŵÄÈ«²¿ÄÚÈÝ£¬¸Ðл´ó¼ÒÊÕ¿´
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......