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

sql server2000ÖРȨÏÞÎÊÌâ

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

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

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

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


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

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

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

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

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

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

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


Ïà¹ØÎÊ´ð£º

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ