ÇóÒ»»îÔ¾µÄsqlserverµÄqqȺ
ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..
ÕâÀï¾ÍÊÇ
ÕâÀï±ÈQQȺÀïÈÈÄÖ
ÎÒÒ²ÏëÕÒÕâô¸öȺ
.
SQL code:
¡£¡£¡£¡£¡£
¡£
ºÇºÇ
ͬÒâ
發錯°æ塊ÁË¡£
Å£ÈËÃǶ¼ÊÇ...°¡
»¹ÓÐÀ´...µÄô£¿
Êý¾Ý¿âϵͳ¹¤³Ìʦ£º11666432
Õâ¸öËã½Ï»ý¼«µÄ£¬°ü¿¼Ö¤¡¢¼¼Êõ
²»¹ý¸ß¼¼Êõ»¹ÊÇÀ´CSDN
ЧÂÊ¡¢ÈËÆø¡¢¼¼Êõ¶¼²»²î
ÒÔǰÎÒÔںöàÕâÖÖȺ£¬¿ÉÊÇ»îÔ¾¶ÈʵÔÚÌ«µÍÁË£¬¾ÍÉÏÁËCSDN£¡
Èç¹ûÕæµÄÐèÒª£¡ÔÚQQ¼ÓȺʱ¿´Ò»Ï¼Ç¼£¡
.
ÕâÀï¾ÍͦÈÈÄÖµÄ.
CSDN ¾ÍºÜ²»Àµ £¬ÈÈÄÖ ÌØ±ðÊÇSQL°æ
»¹ÊÇÕâÀïºÃ, QQȺ»ù±¾Ã»ÓÃ...
dfgsdfgsdfgsdfgsfdgfg
sql°æµÄ¾ºÕùÁ¦ºÜÇ¿,·Ö²»ºÃÕõ
..
¶à×öÊÂÇé°ÉÐÖµÜÃÇ
1
Here It Is.
here
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¼ÓÉÏͬһ¸öÖµ£¿
ÊÇÉí·ÝÖ¤µ¼³öexcel±ä¿ÆÑ§¼ÆÊý·¨£¬Ï뽫ÕâÒ»×ֶεÄÖµÖ±½Ó¼ÓÉÏÒ»¸ö ¡¯
ÇëÎÊÈçºÎд£¿
SQL code:
update ry set Éí·ÝÖ¤ºÅ=Éí·ÝÖ¤ºÅ+'*'
UPdateÒ»Ï ......
SQL code:
begin tran
update EB with(rowlock) set Name='abc123' where Code=12 waitfor delay '00:00:13'
commit tran
ÎÒÓÃrowlockÏëËø¶¨Ò»ÐУ¬¿ÉÊÇËü°ÑÕû¸ö±í¶¼Ëø¶¨ÁË¡£²»¹ÜÎÒ¸üÐÂÄÄÒ»ÌõÊý¾Ý¶¼ ......
±ÈÈç Óû§Ãû£¬ÎÒ³ÌÐòµÄÒªÇóÊÇ10λ×Ö·ûÒÔÄÚ£¬ËùÒÔ£º
Èç¹ûÎÒsqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°£¬
1.»á²»»á¼õÉÙÊý¾Ý¿Õ¼ä£¿
2.»á²»»áÌá¸ßÎÒ³ÌÐòµÄЧÂÊ£¿
3.ÓÐûÓбØÒª£¿
СµÜÏÈл ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......