SQL 2008 ÐÂÊÖÎÊÌ⣿£¿£¿
sql 2008ÖÐР¸½¼ÓµÄÊý¾Ý¿â£¬ÈçºÎÓÃDDLÓïÑÔÌí¼Ó¡°ËùÓÐÕß¡±£»
ÊÖ¶¯µÄ·½Ê½Îª£ºÊó±êÔÚи½¼ÓµÄÊý¾Ý¿âÉÏÓÒ¼ü——>ÊôÐÔ——>Îļþ——>ËùÓÐÕߣ¬È»ºóÓұ߿հ׼üÑ¡Ôñ£»
DDLÓï¾ä£º
ALTER AUTHORIZATION ON ÏîÄ¿¹ÜÀíϵͳ TO PC2009092821FTM£»
go
//¡°ÏîÄ¿¹ÜÀíϵͳ¡±ÎªÐ¸½¼ÓµÄÊý¾Ý¿âÃû£»PC2009092821FTMΪ¹ÜÀíÔ±Ãû
±¨´íΪ£ºÏûÏ¢ 15151£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÎÞ·¨¶Ô ¶ÔÏó 'ÏîÄ¿¹ÜÀíϵͳ' Ö´ÐÐ ²éÕÒ£¬ÒòΪËü²»´æÔÚ£¬»òÕßÄúûÓÐËùÐèµÄȨÏÞ¡£
×¢£ºÊÖ¶¯Ìí¼ÓÊdzɹ¦µÄ
ÊÇ ALTER AUTHORIZATION ²»¿ÉÒÔÕâÑùÓã¿»¹ÊÇÓÃÆäËûµÄÓï¾ä£¿£¿£¿Çë¸ßÊÖÖ¸µã~£¡
101.89%Õâ¸ö½áÌùÂÊÀ÷º¦
2008Ö»Äܰﶥ
SQL code:
use ÏîÄ¿¹ÜÀíϵͳ;
go
exec sp_msforeachtable 'sp_changeobjectowner ''?'', ''PC2009092821FTM'''
SQL code:
´´½¨½ÇÉ«£¬Óû§£¬È¨ÏÞ
/*--ʾÀý˵Ã÷
ʾÀýÔÚÊý¾Ý¿âpubsÖд´½¨Ò»¸öÓµÓбíjobsµÄËùÓÐȨÏÞ¡¢ÓµÓбítitlesµÄSELECTȨÏ޵ĽÇÉ«r_test
Ëæºó´´½¨ÁËÒ»¸öµÇ¼l_test£¬È»ºóÔÚÊý¾Ý¿âpubsÖÐΪµÇ¼l_test´´½¨ÁËÓû§ÕË»§u_test
ͬʱ½«Óû§ÕË»§u_testÌí¼Óµ½½ÇÉ«r_testÖУ¬Ê¹Æäͨ¹ýȨÏ޼̳лñÈ¡ÁËÓë½ÇÉ«r_testÒ»ÑùµÄȨÏÞ
×îºóʹÓÃDENYÓï¾ä¾Ü¾øÁËÓû§ÕË»§u_test¶Ô±ítitlesµÄSELECTȨÏÞ¡£
¾¹ýÕâÑùµÄ´¦Àí£¬Ê¹ÓÃl_testµÇ¼SQL ServerʵÀýºó£¬ËüÖ»¾ßÓбíjobsµÄËùÓÐȨÏÞ¡£
--*/
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
ÔÚÏȰ²×°ÁËvs.net 2008 ºóÔõô°²×° Sql server 2005¡£ËÑÁ˺ܶàÎÄÕ£¬¿ÉÊÇ»¹ÊÇûÓп´µ½Ôõô²ÅÄܹ»°²×°ÉÏ¡£
×ÜÊÇÔÚ°²×°sql serverµÄ¿Í»§¶Ë£¨management studio£©Ê±ºò±¨´í£¬×°ÄǸöÊý¾Ý¿â server ÒýÇæµÄʱºòûÓÐÎ ......
SQL±íÒ»
ÐòÁкÅ, ²úÆ· bz
0001 mc 0
0002 mc 0
0003& ......