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£©ÔÚ¶ÔÏó×ÊÔ´¹
Ïà¹ØÎĵµ£º
´æ´¢¹ý³Ì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 ......
First:
create table gobo.gobo_om_reservations_2008b as
select * from gobo_om_reservations
where to_char(CREATION_DATE,'yyyy')<'2008'
delete from gobo_om_reservations
where to_char(CREATION_DATE,'yyyy')<'2008'
commit
After 2009Year:
create table gobo.gobo_om_reservations_????b as ......
Ö÷ÒªÕë¶ÔSQL ServerÊý¾Ý¿âËÀËøÏÖÏóµÄÔ¤·À¼°½â¾ö´ëÊ©½øÐÐÁËÏêϸµÄ½éÉÜ£¬¸ü¶àÄÚÈÝÇë´ó¼Ò²Î¿¼ÏÂÎÄ£º
¡¡¡¡ËÀËøÊÇÖ¸ÔÚij×é×ÊÔ´ÖУ¬Á½¸ö»òÁ½¸öÒÔÉϵÄÏß³ÌÔÚÖ´Ðйý³ÌÖУ¬ÔÚÕù¶áijһ×ÊԴʱ¶øÔì³É»¥ÏàµÈ´ýµÄÏÖÏó£¬ÈôÎÞÍâÁ¦µÄ×÷ÓÃÏÂ,ËüÃǶ¼½«ÎÞ·¨ÍƽøÏÂÈ¥£¬ËÀʱ¾Í¿ÉÄÜ»á²úÉúËÀËø,ÕâЩÓÀÔ¶ÔÚ»¥ÏàµÈ´ýµÄ½ø³Ì³ÆΪËÀËøÏ̡߳£¼òµ¥µ ......
create PROCEDURE [dbo].[AllDnn_NewsPublish_DeleteArticleByArticle]
@ArticleID nvarchar(200)
AS
declare @sql nvarchar(1000)
set @sql='DELETE dbo.Site_News_Article where ArticleID in ('+@ArticleID+')'
exec (@sql)
--[AllDnn_NewsPublish_DeleteArticleByArticle] '50,51' ......
SQL Server 2008 Áª»ú´ÔÊ飨2009 Äê 7 Ô£©
ÍÚ¾òÄ£ÐÍ£¨Analysis Services - Êý¾ÝÍÚ¾ò£©
±¾½Ú½éÉÜÁËÊý¾ÝÍÚ¾òÄ£Ð͵Ļù±¾Ìåϵ½á¹¹£¬¸ÅÊöÁËÊý¾ÝÍÚ¾òÄ£Ð͵ÄÊôÐÔ£¬²¢ËµÃ÷ÁË´´½¨ºÍ´¦ÀíÍÚ¾òÄ£Ð͵ķ½Ê½¡£
Mining Model Architecture
Defining Mining Models
Mining Model Properties
Mining Model Columns
Processing Min ......