Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 / »ù´¡Àà

×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......

C# SQL µÄUPDATETEXT ÎÊÌâ - .NET¼¼Êõ / C#

A±í ÓÐÁ½¸ö×ֶΠ
  id ΨһÊý×ÖÓò
  InfoTxt text ÀàÐÍ
 ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×Ö¶Î Îı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa' 
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ