SQL Server Êý¾Ý¸ñʽÐÞ¸Äʱ£¬Ã»Óб£´æ°´Å¥µÄÇé¿ö½â¾ö
Èç¹ûÄãʹÓõÄÊÇ SQL Server 2008£¬ µ±ÄãÐÞ¸ÄÊý¾Ý½á¹¹ºó£¬±£´æÊ±»á±¨ÏÂͼÇé¿ö£º Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created. ÕâÊÇ SQL Server 2008 µÄÒ»ÖÖ×ÔÎÒ±£»¤£¬µ±ÄãµÄÐ޸ĿÉÄܵ¼ÖÂÊý¾Ý±í±»É¾³ý²¢ÖØÐ´´½¨Ê±£¨dropped and re-created£©£¬¾Í»áÓÐÕâ¸öÌáÐÑ¡£ µ¼ÖÂ±í±»ÖØÐ´´½¨¿ÉÄÜÊÇÒÔϼ¸ÖÖÇé¿ö£º ÔÚ±íÖмäÌí¼ÓÒ»¸öÐÂÁУ» ɾ³ýÁÐ ¸ü¸ÄÁÐΪ Null ÐÔ ¸ü¸ÄÁеÄ˳Ðò ¸ü¸ÄÁеÄÊý¾ÝÀàÐÍ ÈôÒª²»Ê¹ÓÃÕâ¸ö±£»¤£¬ÐèÒªÔÚ¡°¹¤¾ß¡±²Ëµ¥Öе¥»÷¡°Ñ¡Ï£¬Õ¹¿ª¡°Éè¼ÆÆ÷¡±£¬È»ºóµ¥»÷¡°±íÉè¼ÆÆ÷ºÍÊý¾Ý¿âÉè¼ÆÆ÷¡±¡£ Çå³ý¡°×èÖ¹±£´æÒªÇóÖØÐ´´½¨±íµÄ¸ü¸Ä¡±¸´Ñ¡¿ò¡£ on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box. ÈçÏÂͼ£º ²Î¿¼×ÊÁÏ£º Save (Not Permitted) Dialog Box
http://msdn.microsoft.com/en-us/library/bb895146.aspx
Ïà¹ØÎĵµ£º
/*
±êÌ⣺һ¸öÏîÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä(ÕûÀí°æ)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê£¬ÊØµÃ±ùɽѩÁ«»¨¿ª)
ʱ¼ä£º2010-05-10
µØµã£ºÖØÇ캽ÌìְҵѧԺ
˵Ã÷£ºÒÔÏÂÎåÊ®¸öÓï¾ä¶¼°´ÕÕ²âÊÔÊý¾Ý½øÐйý²âÊÔ£¬×îºÃÿ´ÎÖ»µ¥¶ÀÔËÐÐÒ»¸öÓï¾ä¡£
ÎÊÌâ¼°ÃèÊö£º
--1.ѧÉú±í
Student(S#,Sname,Sage,Ssex) --S# ѧÉú±àºÅ,Sname ѧÉúÐÕÃû,S ......
´íÎóÌáʾ£º
Ö¸¶¨µÄÁ¬½ÓÀàÐÍ“OLEDB”δ±»Ê¶±ðΪÓÐЧµÄÁ¬½Ó¹ÜÀíÆ÷ÀàÐÍ¡£µ±ÊÔͼ´´½¨Î´ÖªÁ¬½ÓÀàÐ͵ÄÁ¬½Ó¹ÜÀíÆ÷ʱ»á·µ»Ø´Ë´íÎó¡£Çë¼ì²éÁ¬½ÓÀàÐÍÃû³ÆµÄƴдÊÇ·ñÕýÈ·¡£
½â¾ö·½·¨£º
sqlserver2005-ÅäÖù¤¾ß-SqlServer configuration manager-SqlServer2005·þÎñ-sqlserver Integration Services£¬ÓÒ»÷-Ñ¡ÔñÊôÐÔ£¬È»ºó° ......
Á¬½Ó²éѯ£¬¾ÍÊǽ«
Á½¸ö»ò¶à¸ö
±í»òÊÓͼ
ͨ¹ýÒ»¶¨µÄÌõ¼þ
½«È«²¿»ò²¿·Ý×Ö¶Î
È«²¿»ò²¿·Ý¼Ç¼
Á¬½Óµ½Ò»Æð£¬µÃµ½Ò»¸öеÄÊý¾Ý¼¯ºÏ¡£
È磺ÓÐÈËÔ±µµ°¸ºÍ¹¤×ʵµ°¸Á½¸ö±í£¬Á½¸ö±íÓй²Í¬µÄ¹Ø¼ü×Ö¶ÎXMDM(ÐÕÃû´úÂ룩£¬ÆäÖÐÈËÔ±µµ°¸´æ´¢ÁËÈËÊÂ×ÊÁÏ£¬¹¤×ʵµ°¸´æ´¢ÁËн³ê×ÊÁÏ¡£
Òò´Ë¿ÉÒÔͨ¹ýXMDM×ֶν«Á½¸ö±íÁ¬½ÓÆðÀ´£¬´Ó¶øÊ¹²éѯ½ ......
sql server 2005 ¼òµ¥ÔËÓú¯Êý
1.null º¯Êý
Ó÷¨ÓëoracleÖÐnvl()ÀàËÆ£¬´¦Àíº¯ÊýΪisnull()£¬
ÀýÈ磺
select ename,sal+isnull(comm,0)
from emp
go
isnull(comm,0)µÄÓ÷¨ÊÇ£º commΪnull Ôò·µ»Ø0 ·ñÔòΪ commµÄÖµ¡£
2.V ......
Èç¹ûûÓÐÔ¶³ÌÊý¾Ý¿âËùÔÚ·þÎñÆ÷µÄwindowsÕ˺ÅÃÜÂ룬½öÓÐÔ¶³ÌSQL ServerÊý¾Ý¿âµÄÓû§ÃÜÂ룬¸ÃÈçºÎ±¸·ÝÔ¶³ÌÊý¾Ý¿âdb1µÄÊý¾Ýµ½±¾µØÄØ£¿
1£ºÔÚ±¾µØ°²×°Í¨°æ±¾µÄÊý¾Ý¿âÈí¼þ£¨±ÈÈ磺SQL Server2000£©
2£ºÔÚ±¾µØÊý¾Ý¿â·þÎñÆ÷ÉÏ´´½¨Êý¾Ý¿âdb2£»
3£ºÊ¹Óñ¾µØ“ÆóÒµ¹ÜÀíÆ÷”×¢²áÔ¶³ÌÊý¾Ý¿â£¬²¢½ ......