SQL 2008 ÐÂÊÖÎÊÌ⣿£¿£¿
sql 2008ÖÐР¸½¼ÓµÄÊý¾Ý¿â£¬ÈçºÎÓÃDDLÓïÑÔÌí¼Ó¡°ËùÓÐÕß¡±£»
ÊÖ¶¯µÄ·½Ê½Îª£ºÊó±êÔÚи½¼ÓµÄÊý¾Ý¿âÉÏÓÒ¼ü——>ÊôÐÔ——>Îļþ——>ËùÓÐÕߣ¬È»ºóÓұ߿հ׼üÑ¡Ôñ£»
DDLÓï¾ä£º
ALTER AUTHORIZATION ON ÏîÄ¿¹ÜÀíϵͳ TO PC2009092821FTM£»
go
//¡°ÏîÄ¿¹ÜÀíϵͳ¡±ÎªÐ¸½¼ÓµÄÊý¾Ý¿âÃû£»PC2009092821FTMΪ¹ÜÀíÔ±Ãû
±¨´íΪ£ºÏûÏ¢ 15151£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÎÞ·¨¶Ô ¶ÔÏó 'ÏîÄ¿¹ÜÀíϵͳ' Ö´ÐÐ ²éÕÒ£¬ÒòΪËü²»´æÔÚ£¬»òÕßÄúûÓÐËùÐèµÄȨÏÞ¡£
×¢£ºÊÖ¶¯Ìí¼ÓÊdzɹ¦µÄ
ÊÇ ALTER AUTHORIZATION ²»¿ÉÒÔÕâÑùÓã¿»¹ÊÇÓÃÆäËûµÄÓï¾ä£¿£¿£¿Çë¸ßÊÖÖ¸µã~£¡
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚ
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
declare @test table(
title varchar(100),--±êÌâ
num decimal(18,6), --ÊýÁ¿
unitqty decimal(18,6) --µ¥Î»
)
insert into @test values('a',100,50)
insert into @test values('b ......