C#ÏîÄ¿´ò°ü£¬²¢×Ô¶¯°²×°SQLÊý¾Ý¿â
Ó¦Ò»Î»ÍøÓѵÄÐèÇ󣬲¢ÐÞÕýÁËMVPÀîºé¸ù".NETƽ̨ÏÂWEBÓ¦ÓóÌÐòµÄ²¿Êð(°²×°Êý¾Ý¿âºÍ×Ô¶¯ÅäÖÃ)"ÖеÄosqlÓ÷¨´íÎó£¬ÒѲâÊÔͨ¹ý¡£
Ò»).´´½¨²¿ÊðÏîÄ¿
1. ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£
2. ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñÖеē°²×°ÏîÄ¿”¡£ÔÚ“Ãû³Æ”¿òÖмüÈë setup1¡£
3. µ¥»÷“È·¶¨”¹Ø±Õ¶Ô»°¿ò¡£
4. ÏîÄ¿±»Ìí¼Óµ½½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÖУ¬²¢ÇÒÎļþϵͳ±à¼Æ÷´ò¿ª¡£
5. ÔÚ“ÊôÐÔ”´°¿ÚÖУ¬Ñ¡Ôñ ProductName ÊôÐÔ£¬²¢¼üÈë ÐÅÏ¢¹ÜÀíϵͳ ¡£
¶þ).½« Ö÷³ÌÐò ÏîÄ¿µÄÊä³öÌí¼Óµ½²¿ÊðÏîÄ¿ÖÐ
1. ÔÚ“Îļþϵͳ±à¼Æ÷”ÖУ¬Ñ¡Ôñ“Ó¦ÓóÌÐòÎļþ¼Ð”¡£ÔÚ“²Ù×÷”²Ëµ¥ÉÏ£¬Ö¸Ïò“Ìí¼Ó”£¬È»ºóÑ¡Ôñ“ÏîÄ¿Êä³ö”¡£
2. ÔÚ“Ìí¼ÓÏîÄ¿Êä³ö×é”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿”ÏÂÀÁбíÖеēÄãµÄ³ÌÐò”¡£
3. µ¥»÷“È·¶¨”¹Ø±Õ¶Ô»°¿ò¡£
4. ´ÓÁбíÖÐÑ¡Ôñ“Ö÷Êä³ö”ºÍ“ÄÚÈÝÎļþ”×飬Ȼºóµ¥»÷“È·¶¨”¡£
Èý).´´½¨°²×°³ÌÐòÀà
1. ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“н¨”£¬È»ºóÑ¡Ôñ“ÏîÄ¿”¡£
2. Ôړн¨ÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеēVisual Basic ÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñÖеēÀà¿â”¡£ÔÚ“Ãû³Æ”¿òÖмüÈë installDB¡£
3. µ¥»÷“´ò¿ª”¹Ø±Õ¶Ô»°¿ò¡£
4. ´Ó“ÏîÄ¿”²Ëµ¥ÖÐÑ¡Ôñ“Ìí¼ÓÐÂÏ£
5. ÔÚ“Ìí¼ÓÐÂÏî”¶Ô»°¿òÖÐÑ¡Ôñ“°²×°³ÌÐòÀà”¡£ÔÚ“Ãû³Æ”¿òÖмüÈë installDB¡£
6. µ¥»÷“È·¶¨”¹Ø±Õ¶Ô»°¿ò¡£
7. Ïêϸ´úÂ븽ºó¡£
ËÄ).´´½¨×Ô¶¨Òå°²×°¶Ô»°¿ò
1. ÔÚ½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÖÐÑ¡Ôñ“setup1”ÏîÄ¿¡£ÔÚ“ÊÓͼ”²Ëµ¥ÉÏÖ¸Ïò“±à¼Æ÷”£¬È»ºóÑ¡Ôñ“Óû§½çÃæ”¡£
2. ÔÚÓû§½çÃæ±à¼Æ÷ÖУ¬Ñ¡Ôñ“°²×°”ϵēÆô¶¯”½Úµã¡£ÔÚ“²Ù×÷”²Ëµ¥ÉÏ£¬Ñ¡Ôñ“Ìí¼Ó¶Ô»°¿ò”¡£
3. ÔÚ“Ìí¼Ó¶Ô»°¿ò”¶Ô»°¿òÖУ¬Ñ¡Ôñ“Ðí¿ÉÐÒé”¶Ô»°¿
Ïà¹ØÎĵµ£º
TEMPDB²»Ö§³Ö×Ô¶¯Ñ¹Ëõ£¬ÇÒËüµÄÊý¾Ý¿âºÍÎļþѹËõÄÜÁ¦ÊÇÓÐÏÞÖÆµÄ£»
Èç²»µÃ²»Ñ¹ËõTEMPDBµÄ´óС£¬½¨ÒéʹÓÃÀëÏß¹¦ÄÜ£¬ÈçϲÙ×÷£º
1.Í£Ö¹SQL SERVER·þÎñ£»
2.ÕÒµ½sqlservr.exeÔÚ´ÅÅÌÖеÄλÖã»
3.ʹÓÃsqlservr.exeÊäÈëÃüÁîsqlservr -c -f,ÕâÑùÆô¶¯SQL SERVERʱ£¬TEMPDBµÄ´óСÄܹ»±£³Ö×îС£»
4.ʹÓÃTSQLÃüÁALTER DATA ......
ת×Ô£ºhttp://hi.baidu.com/cszoo/blog/item/2439a5f517c19c2dbc31093c.html
£¨1£©
SELECT
±íÃû=case when a.colorder=1 then d.name else '' end,
±í˵Ã÷=case when a.colorder=1 then isnull(f.value,'') else '' end,
×Ö¶ÎÐòºÅ=a.colorder,
×Ö¶ÎÃû=a.name,
±êʶ=case when COLUMNPROPERTY( a.id,a.name,' ......
±¾ÎÄÑÝʾÁË SQL Server 2008 ·ÖÇø±íʵÀý;
1. ´´½¨²âÊÔÊý¾Ý¿â £»
2. ´´½¨·ÖÇøº¯Êý;
3. ´´½¨·ÖÇø¼Ü¹¹;
4. ´´½¨·ÖÇø±í;
5. ´´½¨·ÖÇøË÷Òý ;
6. ·ÖÇøÇл» ;
7. ²éѯÄÄЩ±íʹÓÃÁË·ÖÇø±í£»
-- ×÷³ÉÕß leno
-- ÈÕÆÚ: 2009-06-06 23:50:01.700
-- ......
-- ʾÀýÒ», ʹÓÃÖ¤Êé¼ÓÃÜÊý¾Ý.
-- ½¨Á¢²âÊÔÊý¾Ý±í
CREATE TABLE tb(ID int IDENTITY (1,1),data varbinary (8000));
GO
-- ½¨Á¢Ö¤ÊéÒ», ¸ÃÖ¤ÊéʹÓÃÊý¾Ý¿âÖ÷ÃÜÔ¿À´¼ÓÃÜ
CREATE CERTIFICATE Cert_Demo1
WITH
SUBJECT = N'cert1 encryption by database master key' ,
START_DATE = ......
ÎÒÃÇÏÈ¿´ NestedLoop ºÍ MergeJoin µÄËã·¨£¨ÒÔÏÂΪÒýÓ㬼û RicCC µÄ¡¶ ͨÍùÐÔÄÜÓÅ»¯µÄÌìÌà - µØÓü JOIN ·½·¨ËµÃ÷ ¡· ):
==================================
NestedLoop:
foreach rowA in tableA where tableA.col2=?
{
search rowsB from tableB where tableB.c ......