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

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{}µÄ¡£²»·½±ã°¡¡£

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{xxxxxx}µÄ¡£²»·½±ã°¡¡£

µØÖ·´«ÖµµÄʱºòÕâÑùºÃ²»ºÃµÄ£¿

ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...

ÉÏÃæËµÁË È¡³öÀ´¸ñʽ»¯Ò»ÏÂ

ѧϰÁË.

ÒýÓÃ
ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...


µ«ÊÇÓÃC#È¡³öÀ´£¬Ò²ÓС°£û£ý¡±Õâ¸ö´óÀ¨ºÅ£¿

ÊÇûÓУ¬¸ã´í¡£ÔÚÊý¾Ý¿âÖп´µÃµ½¡£ºÇºÇ¡£¶àлÁË£¡£¡£¡

ÔÚ²éѯµÄʱºò¼Ó²»¼Ó{}¶¼ÄܲéµÄµ½
select * from tb where GUID='{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}'
select * from tb where GUID='xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'
²é³öÀ´µÄ½á¹ûÓ¦¸ÃÒ»ÑùµÄ



Ïà¹ØÎÊ´ð£º

MSSQL ²Ù×÷½á¹û¼¯

SQL code:
For Ls_desc IN (Select Di_ename ,Di_Pcs,Di_Unitprice
from T_BO_DeclareInvoice Di
WHERE bs_code = as_bs_code)
LOOP
IF Ls_desc.Di_ename IS ......

¡¾Ï뿼¸öMSSQLÈÏÖ¤-×Éѯ¡¿

RT
ºÃÏñ¿¼MSSQLÖ¤·ÖºÃ¼¸ÖÖŶ?
×ÉѯÏ ÓÐʲôÏà¹Ø×ÊÁÏô£¿

Õâ¸öÕæ²»Çå³þ£¬°ï¶¥°É

µ±È»ÊÇMICROSOFTµÄMCSEÁË

..

°ï¶¥

°ï¶¥Ï°ɡ£¡£

MS SQL ÈÏÖ¤
2000:mcdba
2005:·ÖÈý¸öϵÁР ¹ ......

ÀàËÆ mssql select top ...µÄʵÏÖ

ÔÚms sqlserverÖУ¬È¡Âú×ãÌõ¼þµÄǰ¼¸ÐпÉÒÔʹÓÃselect topÓï¾ä£¬µ«ÔÚoracleÖв¢Ã»ÓÐÕâÑùµÄÓï¾ä£¬
ÎÒ´ÓÍøÉÏ¿´µ½ÁËÒ»ÖÖʵÏÖ

select * (select * from talbename) where rownum <=100 order by rownum as ......

MSSQL$SQLEXPRESS ·þÎñÆô¶¯ÎÊÌâ

 


MSSQL$SQLEXPRESS  ÎÞ·¨Æô¶¯..  ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ  лл
¿´¿´´íÎóÈÕÖ¾

Ìáʾʲô´íÎó?

http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......

¹ØÓÚMSSQLÊý¾Ý¿â½ÇÉ«ÊôÐÔȨÏÞÑ¡ÔñÎÊÌâ



ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£

Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ