SQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(1)
ºÜ¶àÈ˶ÔXpath¿ÉÄܱȽÏÊìϤ£¬µ«²»ÖªµÀÓÐûÓÐÖ±½Ó²Ù×÷¹ýÊý¾Ý¿â£¬ÎÒÃǶ¼ÖªµÀ ÔÚSql2005À﹫֧³ÖµÄ¼¸ÖÖ²éѯÓÐRaw£¬Auto£¬PathģʽµÈ£¬Èç¹ûÔÚ2000ÀïʹÓùý PathģʽµÄÅóÓÑÓ¦¸ÃÖªµÀ£¬ÊDz»ÈÝÒ×´¦Àí²éѯ½á¹ûµÄ£¬ÄÇôÔÚ2005Àï¶ÔÕâÒ»¿é×öÁ˺ܺõÄÌáÉý
ÎÒÏÈÀ´½éÉÜÒ»ÏÂʲôÊÇSql¡¡For¡¡Xml°É£¬ÎÒÃÇ´ó¶àʱºò¶¼»áÓÐÕâÖÖÇé¿ö£¬Ïë°Ñ±íÀïµÄÊý¾Ýת»¯³ÉXml¸ñʽµÄ£¬Í¨³£ÎÒÃÇ»áʹÓÃc#»òÊÇVb³ÌÐòÀ´×ª¹«£¬Ê¹ÓÃXpath»òÊÇXmlDocumentµÈ¶ÔÏóÀ´Íê³É£¬µ±È»ÕâÑùÊÇ¿ÉÒԵģ¬²»¹ýÕâÑù´¦ÀíÆðÀ´¾Í»á³öÏֺܶàÎÊÌ⣬±ÈÈç˵Êý¾Ý¿â±ä»¯£¬Èç¹ûÖ»ÓÐÊý¾Ý±ä»¯ÄÇ·½±ã£¬Ð´Ò»¸öͨÓõÄÀ࣬ÿ´Î²éѯǰ¸üÐÂXmlÎļþ¾Í¿ÉÒÔÁË£¬µ«Èç¹û³öÏÖÊý¾Ý¿â½á¹¹µÄ±ä»¯¾Í»áºÜ³ÔÁ¦ÁË£¬ÄÇôÓÐûÓÐÒ»ÖÖ·½·¨£¬°ÑÊý¾ÝÔÚµ÷³öÊý¾Ý¿â֮ǰ¾Íת»¯ÎªXmlµÄÄØ£¬Õâ¸öÊǵ±È»µÄ£¬¾ÍÊÇÎÒÃǵÄFor¡¡Xml£¬´ó¼ÒÔÚ²éѯ·ÖÎöÆ÷Àï×ö±í½á¹û²éѯµÄʱºòÒ»°ãÊÇÕâÑùдµÄ
ÎÒÃǸø´ó¼ÒչʾһÏÂÎÒËùÓõ½µÄÁ½¸ö±í°É
µÚÒ»¸ö±í°à¼¶ÐÅÏ¢±íClassInfo£¨°à¼¶ÐÅÏ¢±íÒ»¹²Èý¸ö×Ö¶ÎCID ±¾±íID,Cnumber °à¼¶ÈËÊý,CName °à¼¶Ãû³Æ£©
µÚ¶þ¸ö±í ÉúÐÅÏ¢±í Students £¨CID °à¼¶±íÍâ¼ü£¬SIDѧÉúÐÅÏ¢±íIDѧÉúµÄѧºÅ¾ÍÊÇ£¬SName£©
SELECT CID,Cnumber,CName from ClassInfo WHERE CName='²©¿ÍÔ°Ò»°à'
½á¹ûΪ£º
ͨ³£ÊÇÕâÖÖ·½·¨£¬»òÊÇÔÙ¼ÓÉϸöOrder BY ʲôµÄ£¬»òÊÇÏñinner join µÈ²éѯµÄ¶«¶«£¬ÆäʵÎÒÃÇÖ»ÒªÔÚÕâÌõÓï¾äÉÏÉÙÁ¿µÄ¸Ä¶¯Ò»Ï¾ͿÉÒԵõ½ÎÒÃÇÏëÒªµÄXmlÊý¾ÝÁË£¬Ò²Ðí ÓÐÅóÓÑÒѾÏëµ½ÁËÊÇ For Xml ¶Ô¾ÍÊÇÕâÑùµÄ
SELECT CID,Cnumber,CName from ClassInfo WHERE CName='²©¿ÍÔ°Ò»°à' FOR xml raw
ÕâÑù²éѯµÃµ½µÄ½á¹ûÈçÏ£º
ÎÒÃÇÈç¹ûÏë¿´µÄ¸üÇå³þµÄ»°Ö»Òªµ¥»÷Ò»¸ö¾Í¿ÉÒԵõ½ÏàÓ¦µÄXmlÎļþµÄÐÎʽÁË
ÕâÀïÓ¦¸Ã¾ÍÊÇÎÒÃÇÏëÒªµÄXmlÎļþµÄÐÎʽÁË£¬Æäʵ¾ÍÊÇÕâô¼òµ¥µÄ£¬ÎÒÃÇ¿ÉÒÔͨ¹ýAdoµÄ·½Ê½ °ÑËû²éѯµÃµ½UIÖ±½ÓʹÓþÍOKÁË£¬
ÎÒÃÇ¿ÉÒÔ¿´µ½ÎÒÃǵõ½µÄÐÅÏ¢²¢²»ÍêÕû£¬Ã»ÓÐѧÉúÐÅÏ¢£¬ÎÒÃÇÒª°ÉʹÓÃÒ»¸öÁ¬½ÓµÄÐÎʽÀ´Íê³É¿´ÏÂÃæµÄSqlÓï¾ä
SELECT ClassInfo.CID,ClassInfo.Cnumber,ClassInfo.CName,Students.SID,Students.SName
from ClassInfo JOIN dbo.Students ON Students.CID=dbo.ClassInfo.CID
ORDER BY&n
Ïà¹ØÎĵµ£º
ÔÚSQL SERVER 2005ÖбØÐëÓÃרÓùÜÀíÁ¬½Ó²Å¿ÉÒԲ鿴¹ý³Ì¹ý³ÌÖÐÓõ½µÄ±í
EG£ºsqlcmd -A
1>use test
2>go
1>sp_decrypt 'p_testa'
2>go
Text
----------------------
Create procedure P_testa
with encryption
as
select * from test
create PROCEDURE [dbo].[sp_decrypt]
(@procedure s ......
1. еIJúÆ·°æ±¾
³ýSQL Server 2005±ê×¼°æºÍÆóÒµ°æÖ®Í⣬²úÆ·ÏßÖл¹¼ÓÈëÁËSQL Server 2005¼ò»¯°æ£¨SQL Server 2005 Express£©ºÍ¹¤×÷×é°æ£¨SQL Server 2005 Workgroup£©Á½¸öа汾¡£
SQL Server 2005 Express——Æä×÷ÓÃÊÇ´úÌæ΢ÈíSQL Server×ÀÃæÒýÇ棨Microsoft SQL Server Desktop Engine£¬MSDE£©¡£SQL Serve ......
Database Level
- shrinkdb
- shrinkfile
SQL Server 2008
1) Right click database
2) Tasks
3) Shrink
4) Database or file
Table level
- compression
SQL Server 2008
1) Right click table
2) Storage
3) Manage Compression ......
ת×Ô£ºhttp://lbccheng.blog.163.com/blog/static/314120920095525627390/
ÎÊÌâÒ»£ºÊ¹ÓÃJasperReportÉú³ÉHtml±¨±íºó£¬Êý¾ÝÏÔʾÕýÈ·£¬µ«¸÷ÖÖÏßÌõÏÔʾ²»³öÀ´
²úÉúÔÒò£ºÔÚ Éú³ÉHTMLÒ³ÃæʱJRHtmlExporterParameter.IMAGES_URI²ÎÊýÉèÖò»ÕýÈ·£¬Ö÷ÒªÊÇͼƬµÄ ......