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

sqlserver ´¥·¢Æ÷ - MS-SQL Server / »ù´¡Àà

ÓÐÁ½¸ö±íÒ»¸öÊǿͻ§¶©µ¥±í(¶©µ¥ºÅ£¬²úÆ·ºÅ£¬ÊýÁ¿£¬¼Û¸ñ£©,Ò»¸öÊÇÉÌÆ·±í(²úÆ·ºÅ£¬²úÆ·Ãû£¬²úÆ·ÊýÁ¿)
ÈçºÎÓô¥·¢Æ÷Íê³Éµ±²åÈë¿Í»§¶©µ¥±íºó£¬»á×Ô¶¯¸üÐÂÉÌÆ·±íÖеIJúÆ·ÊýÁ¿
Èô²úÆ·ÊýÁ¿²»¹»Ê±±¨´í£¨¿ÉÊä³öÎÄ×Ö±¨´íÐÅÏ¢£©
лл´ó¼Ò¡£
-- ×Ô¶¯¸üÐÂÉÌÆ·±íÖеIJúÆ·ÊýÁ¿
-- ²úÆ·ÊýÁ¿²»ÄÜΪ¸º£¬
-- ËùÒÔÔÚ×ö¶©µ¥Ê±£¬Òª¼ì²âÉÌÆ·±íÖеĵ±Ç°ÉÌÆ·¿â´æÁ¿£¬µ±¿â´æÁ¿²»×㣬´Ë¶©µ¥Ìá½»¾Í²»Äܳɹ¦£¡
-- (ÒòΪÄãû¿â´æ£¬ÔõôÄûõ¸øÈ˼ÒÄØ£¿)

-- Õâ¸öÎÊÌâÒª¿¼ÂǵĶ«Î÷ºÜ¶à£¬²»½ö½öÊÇÒ»¸ö´¥·¢Æ÷Äܽâ¾öµÄ£¡


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ