Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql server2000ÖРȨÏÞÎÊÌâ

ÔÚsql server2000ÖÐ Ôõô°ÑÒ»ÕűíÉèÖóÉËùÓÐÓû§¶¼ÎÞ·¨Ð޸썰üÀ¨¹ÜÀíÔ±£©
ÄÜÕâÑùÂð£¿

ºÃÏñ²»¿ÉÄÜ£¬sa¿Ï¶¨ÊÇÄܹ»¸ÄµÄ¡£

sa²»ÄÜÖ¸¶¨£¬ÆäËûµÄ¿ÉÒÔ

ÏÖÔÚÎÒÓиöÎÊÌâ¾ÍÊÇ
¿Í»§¾ÍÊÇÓÃsaµÇ½  µ«ÊÇÎÒÏë°ÑÒ»¸ö±íµÄÊý¾Ý¹Ì¶¨ ²»ÈÃËû×öÈκÎÐÞ¸Ä
²»ÖªµÀÔõô¸Ä


ÄǸøËûÁíÍâÒ»¸öÓû§²»¾ÍÍêÁË..ÒªÊÇÁ¬sa¶¼²»¿ÉÒÔÐ޸ϹµÃÁË...

sql server¾ÍÊÇÕ⣬¹ÜÀíԱȨÏ޺ܸߵ쬲»¿Éº³¶¯°¡

Ó¦¸Ã²»¿ÉÄܵĠ sa¿ÉÒԸĵÄ

ÒýÓÃ
ÓÃtrigger£¬ËùÓпͻ§ÊäÈëµÄÐÂÖµ¶¼ÓÃÔ­À´µÄÖµ´úÌæ£¿²»ÖªµÀÐв»ÐС£¡£¡£

ÎÒÊÔÊÔ¿´¿© лл

ÒýÓÃ
ÄǸøËûÁíÍâÒ»¸öÓû§²»¾ÍÍêÁË..ÒªÊÇÁ¬sa¶¼²»¿ÉÒÔÐ޸ϹµÃÁË...

¾ÍÊDz»ÏëÕâôÂé·³ 


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

SqlÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......

sql ´æ´¢¹ý³Ì

ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡

Óû§ÃûÊÇΨһµÄ
±íA  ×Ö¶Î
Óû§Ãû£ºName  ,ÓÊÏ䣺Ema ......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ