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

MSSQL´æ´¢Êý¾ÝÎÊÌâ

ÎÒÓõÄÊÇrealÊý¾ÝÀàÐÍ£¬µ«ÊǴ洢СÓÚ1µÄÊýʱǰÃæµÄ0ûÓÐÁË£¬¸ÃÔõô½â¾ö£¬±ÈÈ磺ÎÒÏë´æ´¢0.1£¬ÔÚÊý¾Ý¿âÀïÖ»ÓС°.1¡±,0ûÓÐÁË£¬ÒªÔõôÉèÖ㬻òÕßÊý¾ÝÀàÐÍÊDz»ÊÇÒª»»Ò»ÖÖ ??
decimal(9,1)



Õâ¸öòËÆÓëÀàÐÍÎÞ¹Ø
Óë²Ù×÷ϵͳÓйØ
µ«ÊÇһֱûÓÐÕÒµ½
ÔõôÉèÖÃ

SQL code:
2000±¾À´¾ÍÕâÑù

²»¹ý½¨Ò黹ÊÇ´æΪdecimal Ð͵Ä


´«ËµÖÐÔÚ
¿ØÖÆÃæ°å--µØÇø¼°ÓïÑÔÑ¡Ïî--×Ô¶¨Òå--Êý×Ö
ÉèÖÃ
µ«ÊÇÎÒÊÔÑéÁËûÓÃ


ÒýÓÃ
´«ËµÖÐÔÚ
¿ØÖÆÃæ°å--µØÇø¼°ÓïÑÔÑ¡Ïî--×Ô¶¨Òå--Êý×Ö
ÉèÖÃ
µ«ÊÇÎÒÊÔÑéÁËûÓÃ

ÎÒÔÚ2005ÏÂÉèÖÃûÓÃ
Â¥Ö÷ÔÚÈç¹ûÊÇ2000¿ÉÒÔÊÔÏÂ
È»ºóÖØϵçÄÔ¿´¿´

ÄÇÖ»ÊÇÏÔʾµÃÊ°É

5Â¥µÄ·½·¨ÊÔ¹ýÁË ¸Ð¾õ»¹ÊÇûʲôÓð¡

SQL code:

¿ØÖÆÃæ°æ->ÈÕÆÚ¡¢Ê±¼ä¡¢ÓïÑÔºÍÇøÓòÉèÖÃ->ÁãÆðʼ¿ªÊ¼->¸Ä³É0.7ÕâÖÖ¸ñʽ;



ÒýÓÃ
5Â¥µÄ·½·¨ÊÔ¹ýÁË ¸Ð¾õ»¹ÊÇûʲôÓð¡

ºÇºÇ
´«ËµÖÐÕâÑùÉèÖÃ
ÎÒҲû³É¹¦
Ö»ÊÇÈÃÄãÊÔÏÂ


ÏÖÔÚÊý¾Ý¿âÀï¿ÉÒÔÁ˵«ÊǶÁ³öÀ´Ê±»¹ÊÇÉÙÁ˸ö0

ÒýÓÃ
ÏÖÔÚÊý¾Ý¿âÀï¿ÉÒÔÁ˵«ÊǶÁ³öÀ´Ê±»¹ÊÇÉÙÁ˸ö0

ÆäʵÕâ¸öÖ»ÊÇÏÔʾµÄÎÊÌâ¶øÒÑ
ÓÐÓ°ÏìÂð

Ó°Ï쵽ûʲô ¾ÍÊÇÏÔʾµÄÎÊÌ⣬ÎÒ¶Á³öÊý¾ÝÀ´Ê±Ç°ÃæÔõô


Ïà¹ØÎÊ´ð£º

MSSqlÊý¾Ý¿â±»¹ÒÂí

ÏÖÓÐÒ»¸öASP+mssqlµÄÍøÕ¾£¬±»¹ÒÂíÁË£¬½«ÀïÃæÒ»¸ö±íÖеÄntext×ֶιÒÂí¹ÒÂí£¬¡°<script src=http://ľÂíµØÖ·></script>¡±,µÄ·½Ê½ÊÇ£¬²»¶ÏµØÐ޸ĸÃ×ֶεÄÖµ£¬Ö±½Ó¼ÓÔÚ×îºóµÄ£¬Ê±¼ä³¤ÁË£¬¿ÉÒÔ¿´µ½¸Ã×Ö¶ÎÖÐÓÐ ......

MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý

ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É


ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..

ÄÇÓÐûÓÐϵͳ´ ......

FCKeditor ¸üÐÂÊý¾Ý¿â£¨mssql£©µÄÎÊÌâ

ÓÃÁËFCKeditorµÄ±à¼­Æ÷£¬´æÈëÆÕͨÎÄÕº󣬿ÉÒÔ¸üС£µ±´æÈëwordµÄÄÇÖÖ±í¸ñ¸ñʽµÄÎÄÕÂʱºò£¬¾Í³öÏÖÎÞ·¨¸üеÄÎÊÌâ¡£ <httpRuntime maxRequestLength="2097151" executionTimeout="43200"/&g ......

mssqlÈçºÎcreate×Ö¶ÎÄØ£¿

create db ÊÇн¨Êý¾Ý¿â
create table ÊÇн¨±í
ÄÇн¨×Ö¶ÎÄØ£¿ лл¡£

×Ô¼ºµ½sqlserverÎĵµÖвéÕÒcreateµÄÓ﷨ʾÀý°É

SQL code:
ÏÂÀýÏÔʾ pubs Êý¾Ý¿âÖÐËù´´½¨µÄÈý¸ö±í£¨jobs¡¢employee ºÍ publisher ......

mssql ¹ØÓÚwhereÓï¾äµÄλÖÃ

ÀýÈ磺select a.* from (select id,code from b left join c on b.id=c.id)a where id=1
ÕâÀïµÄwhere ÔÚÖ´ÐеÄʱºò£¬ where »áÓÅ»¯ÊÇ·ñ½øÈ뵽СÀ¨ºÅÀïÃæÖ´ÐÐ?????
SQL code:
select id,code from b left join ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ