µ¼ÈëÊý¾ÝµÄSQLÓï¾ä
ÏÖÓÐÔ¶³ÌÊý¾Ý¿â IP 111.111.111.111
Êý¾Ý¿âÃû mm Óбí tb1 dt£¨datetime£© col1,col2,col3
±¾µ×Êý¾Ý¿â IP 222.222.222.222
Êý¾Ý¿âÃû nn Óбí tb ndt£¨datetime£© ncol1,ncol2,ncol3,ncol4
ÏÖÒª½«tb ÖеÄÊý¾Ý µ¼Èëµ½tb1 ÖÐ ndt¶ÔÓ¦ dt£¬ncol1 ¶ÔÓ¦col1 ncol2 ¶ÔÓ¦col2 ncol3 ¶ÔÓ¦col3
ÇóÕâÑùµÄSQLÓï¾ä ×îºÃ¿ÉÒÔ¶¯Ì¬Ìí¼Ó£¬ÒòΪ±¾µØÊý¾Ý¿âÔÚ¸üУ¬Ô¶³ÌµÄÊý¾ÝÒª´Ó±¾µØÊý¾Ý¿âÀ´ÒªÊý¾Ý
×øµÈ¸ßÊÖ ÀÏ¿´µ½ÕâÑùµÄ µ«×Ô¼º»¹ÊDz»»á
¹ØÓÚÄã˵µÄ¸üÐÂÎÊÌ⣬¿ÉÒÔÓô¥·¢Æ÷¡£
лл£¬Ã÷ÌìÈ¥¹«Ë¾ÊÔÊÔ£¬ÐÐÁ˺ó½áÌù£¬¹ØÓÚ½¨Á¢´¥·¢Æ÷µÄ ½â¾ö·½°¸ ÒÔºóÔÙÌáÎÊ£¬ÒòΪÎÊÌ⻹±ÈÕ⸴ÔӺܶ࣬±í½á¹¹²»Ò»Ñù£¬¶øÇÒ¿â²»Ò»Ñù¡£µ½Ê±ºòÔÙÎÊ
ÎÒҲȥ³¢ÊÔÒ»ÏÂ
BCP
ÎÒҲȥÊÔÒ»ÏÂ
²»Ðа¡£¬Ô¶³ÌµÄ openrowset ·þÎñû¿ª£¬»¹ÓоÍÊÇÔõô²Å Ô¶³ÌÊý¾Ý±íÒѾÓÐÁË£¬ÓÃSelect into½á¹¹²»ÐÐ
ÓÐûÓÐÆäËûµÄ²åÈ뷽ʽ
ѧϰ
ÄǾÍinsert into table
select * from table¡£¡£¡£¡£¡£2¸ö±íµÄÁбØÐëÏàͬ°¥
ѧϰ
ѧϰ
{{---
Ïà¹ØÎÊ´ð£º
Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º
An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48: ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´
ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)
SQL ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......