sql_ÉèÖÃȨÏÞ_Êý¾Ý¿â»ù´¡
ÉèÖÃȨÏÞ
²»ÂÛÓû§»ò½ÇÉ«£¬¶¼ÊÇȨÏÞµÄÉèÖöÔÏó¡£³ýÁËÓ¦ÓóÌÐò½ÇÉ«½ÏÌØÊ⣬ÓëÆäËû½ÇÉ«¼°ÓÃ
»§ÓÐÏ໥Åųâ¹ØϵÍ⣬Êý¾Ý¿â½ÇÉ«¼°³ÉÔ±ÔÚȨÏ޵ĹØϵÉϷdz£ÃÜÇС£Ò»¸öÓû§¿ÉÄÜͬʱÁ¥
ÊôÓÚ¶à¸öÊý¾Ý¿â½ÇÉ«£¬Ã¿Ò»½ÇÉ«ÓÖ¿ÉÓµÓв»Í¬È¨ÏÞ£¬´ËʱÓû§»ñȡʵ¼ÊȨÏÞµÄÔÔòÊÇ“²¢
¼¯”£¬³ý·ÇÓÐ deny£¨½ûÖ¹£©µÄÉèÖá£Èç½ÇÉ« A ½ûÖ¹¶ÁÈ¡Êý¾Ý±í B£¬µ«½ÇÉ« C ¿É¶ÁÈ¡Êý¾Ý±í
B£¬´ËʱͬʱÁ¥Êô½ÇÉ« A ºÍ C µÄÓû§£¬ÈÔÎÞ·¨¶ÁÈ¡Êý¾Ý±í B£¬ÒòΪËûÒѱ»½ûÖ¹¡£
ÔÚȨÏÞµÄ×÷ÓöÔÏóÉÏ£¬¿É·ÖΪ·þÎñÆ÷¼°Êý¾Ý¿â£¬¼´ÕâÁ½Õß¿É·Ö±ðÉèÖÃȨÏÞ£¬Çë¼ûÈçÏÂ
˵Ã÷¡£
Ö¸¶¨·þÎñÆ÷ȨÏÞ
£¨1£©ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷µÄ·þÎñÆ÷ÉÏÓÒ»÷£¬ÔÙÑ¡Ôñ“ÊôÐÔ”¡£
£¨2£©ÔÚ¶Ô»°¿òÖÐÇл»ÖÁ“ȨÏÞ”¡£
£¨3£©ÔÚ“µÇ¼Ãû»ò½ÇÉ«”ÖÐÑ¡ÔñÒªÉèÖÃȨÏ޵ĶÔÏó£¬ÔÚ“ÏÔʽȨÏÞ”Öзֱð¹´Ñ¡ÊÚȨ£¬
Íê³Éºóµ¥»÷“È·¶¨”°´Å¥£¬Èçͼ 15-21 Ëùʾ¡£
Èçͼ 15-21 Ëùʾ£¬¾ÍÊǶԷþÎñÆ÷µÄȨÏÞÉèÖᣓÊÚȨÕß”¾ÍÊǵ±Ç°µÇ¼ÖÁ SQL Server
·þÎñÆ÷µÄµÇ¼Ãû£»“ȨÏÞ”ÊÇËùÓе±Ç°µÇ¼Ãû¿ÉÉèÖõÄȨÏÞ£»“ÊÚÓè”±íʾÊÚÓèȨÏÞ£»Èô¹´
Ñ¡“¾ßÓÐÊÚÓ蔣¬±íʾ sa ÊÚÓèÑ¡ÖжÔÏóµÄȨÏÞ¿ÉÔÙÊÚÓèÆäËûµÇ¼Ãû£»“¾Ü¾ø”¾ÍÊǽûֹʹÓá£
ÕâÈý¸öÑ¡ÏîµÄÑ¡ÔñÓÐÆäÁ¬´ø¹Øϵ£¬¹´Ñ¡“¾Ü¾ø”£¬¾Í×Ô¶¯Çå³ý“ÊÚÓ蔼°“¾ßÓÐÊÚÓ蔣»Èô
¹´Ñ¡“¾ßÓÐÊÚÓ蔣¬ÔòÇå³ý“¾Ü¾ø”²¢Ñ¡Ôñ“ÊÚÓ蔡£
“µÇ¼Ãû»ò½ÇÉ«”¾ÍÊDZ»ÉèÖÃȨÏ޵ĶÔÏ󣬶ÁÕ߿ɵ¥»÷“Ìí¼Ó”°´Å¥£¬Ö¸¶¨ÆäËûµÇ¼
Ãû»ò½ÇÉ«£¬µ«ËùÓÐÄÚÖ÷þÎñÆ÷½ÇÉ«¾ùÎÞ·¨¸ü¸ÄȨÏÞ£¬µ«¿ÉÒÔΪ public ½ÇÉ«Ö¸¶¨È¨ÏÞ¡£
ÈôÒª²é¿´µ±Ç°Ñ¡ÔñµÇ¼Ãû»ò½ÇÉ«µÄȨÏÞ£¬Çëµ¥»÷“ÓÐЧȨÏÞ”°´Å¥£¬ÒòΪÓÐЧȨÏÞ¿É
Äܲ»Ö¹ÔÚͼ 15-21 ÖÐÉèÖ㬻¹ÒªÊӵǼÃûËùÊôµÄ½ÇÉ«¶ø¶¨¡£ËùÒÔͼ 15-21 Ö»»áÏÔʾÔÚ´ËÉè
Öö¨ÒåµÄȨÏÞ£¬Ä¬ÈÏÒÑÓеÄȨÏÞÔò²»»áÏÔʾ¡£
ͼ 15-21 ÉèÖ÷þÎñÆ÷ȨÏÞ
Ö¸¶¨Êý¾Ý¿âȨÏÞ
£¨1£©ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖÐÑ¡Ôñ eBook Êý¾Ý¿â£¬ÓÒ»÷ºóÑ¡Ôñ“ÊôÐÔ”¡£
£¨2£©ÔÚ¶Ô»°¿òÖÐÇл»ÖÁ“ȨÏÞ”¡£
£¨3£©ÔÚ“Óû§»ò½ÇÉ«”ÖÐÑ¡ÔñÒªÉèÖÃȨÏ޵ĶÔÏ󣬓ÏÔʽȨÏÞ”Öзֱð¹´Ñ¡È¨ÏÞ£¬Íê
³Éºóµ¥»÷“È·¶¨”°´Å¥£¬Èçͼ 15-22 Ëùʾ¡£
¶ÔÏóȨÏÞ
£¨1£©ÔÚ¶ÔÏó×ÊÔ´¹
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
´æ´¢¹ý³ÌgetRecordfromPageµÄÄÚÈÝ
//getRecordfromPage.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getRecordfromPage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[getRecordfromPage]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
G ......
1.
ËÀËøÔÀí
¸ù¾Ý²Ù×÷ϵͳÖеĶ¨Ò壺ËÀËøÊÇÖ¸ÔÚÒ»×é½ø³ÌÖеĸ÷¸ö½ø³Ì¾ùÕ¼Óв»»áÊͷŵÄ×ÊÔ´£¬µ«Òò»¥ÏàÉêÇë±»ÆäËû½ø³ÌËùÕ¾Óò»»áÊͷŵÄ×ÊÔ´¶ø´¦ÓÚµÄÒ»ÖÖÓÀ¾ÃµÈ´ý״̬¡£
ËÀËøµÄËĸö±ØÒªÌõ¼þ£º
»¥³âÌõ¼þ
(Mutual exclusion)
£º×ÊÔ´²»Äܱ»¹²Ïí£¬Ö»ÄÜÓÉÒ»¸ö½ø³ÌʹÓá£
ÇëÇóÓë± ......
1.ijҽԺ²¡·¿¼ÆËã»ú¹ÜÀíÖÐÐèÒªÈçÏÂÐÅÏ¢£º£¨15·Ö£©
¿ÆÊÒ£º¿ÆÃû£¬¿ÆµØÖ·£¬¿Æµç»°
²¡·¿£º²¡·¿ºÅ£¬ËùÊô¿ÆÊÒÃû
Ò½Éú£ºÐÕÃû£¬Ö°³Æ£¬ËùÊô¿ÆÊÒÃû£¬ÄêÁ䣬¹¤×÷Ö¤ºÅ
²¡ÈË£º²¡ÀúºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬Õï¶Ï£¬Ö÷¹ÜÒ½Éú£¬²¡·¿ºÅ£¬ÈëסÈÕÆÚ
ÆäÖУ¬Ò»¸ö¿ÆÊÒÓжà¸ö²¡·¿¡¢¶à¸öÒ½Éú£¬Ò»¸ö²¡·¿Ö»ÄÜÊôÓÚÒ»¸ö¿ÆÊÒ£¬Ò»¸öÒ½ÉúÖ»ÊôÓÚÒ»¸ö¿ÆÊÒ£¬µ«¿É¸º ......