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
Ïà¹ØÎĵµ£º
×î½üÒ»Ö±ÔÚÓÃSQL SERVER, ·¢ÏÖÆ½Ê±»ýÔܵÄһЩÎÊÌâÈç¹û²»¼°Ê±µÄ¼Ç¼ÏÂÀ´,ºÜ¿ì¾ÍÍüÁË. ¹ý¶Îʱ¼äÔÙ·¢ÏÖÏàͬÎÊÌâʱ,»¹Òª×öÖØ¸´¹¤×÷.
¶à×öЩ±Ê¼Ç°É, Ìá¸ßһϹ¤×÷ЧÂÊ.
1, ¶ÁÈ¡DBFÎļþ£¬´æÈëµ½SQL SERVERʱ£¬³öÏÖÎÊÌâÁ½¸ö¡£
µÚÒ»¸ö´íÎóÐÅÏ¢£º“·¢Éú´íÎó£ºERROR [IM001][Microsoft][ODBCÇý¶¯³ÌÐò¹ÜÀíÆ÷]Çý¶¯³ÌÐò²»Ö§³Ö´Ë ......
Ìí¼Ó¡¢É¾³ý¡¢ÐÞ¸ÄʹÓÃ
db.Execute(Sql)ÃüÁîÖ´ÐвÙ×÷
╔----------------╗
¡î Êý¾Ý¼Ç¼ɸѡ ¡î
╚----------------╝
×¢Ò⣺µ¥Ë«ÒýºÅµÄÓ÷¨¿ÉÄÜÓÐÎó(ûÓвâʽ)
Sql = "Select
Distinct
×Ö¶ÎÃû from Êý¾Ý±í"
Distinctº¯Êý£¬²éѯÊý¾Ý¿â´æ±íÄÚ²»Öظ´µÄ¼Ç¼
......
Á¬½Ó²éѯ£¬¾ÍÊǽ«
Á½¸ö»ò¶à¸ö
±í»òÊÓͼ
ͨ¹ýÒ»¶¨µÄÌõ¼þ
½«È«²¿»ò²¿·Ý×Ö¶Î
È«²¿»ò²¿·Ý¼Ç¼
Á¬½Óµ½Ò»Æð£¬µÃµ½Ò»¸öеÄÊý¾Ý¼¯ºÏ¡£
È磺ÓÐÈËÔ±µµ°¸ºÍ¹¤×ʵµ°¸Á½¸ö±í£¬Á½¸ö±íÓй²Í¬µÄ¹Ø¼ü×Ö¶ÎXMDM(ÐÕÃû´úÂ룩£¬ÆäÖÐÈËÔ±µµ°¸´æ´¢ÁËÈËÊÂ×ÊÁÏ£¬¹¤×ʵµ°¸´æ´¢ÁËн³ê×ÊÁÏ¡£
Òò´Ë¿ÉÒÔͨ¹ýXMDM×ֶν«Á½¸ö±íÁ¬½ÓÆðÀ´£¬´Ó¶øÊ¹²éѯ½ ......
ÀûÓÃhibernateµÄQuery½øÐÐÖ±½ÓÖ´ÐÐSQLÓï¾ä
Ò»¡¢
String sql = "insert into SHOP_MALL_ACCOUNT_MAP_T (MALL_NO,ACCOUNT) values ('"
+ mallNo + "','" + userId + "')";
SQLQuery query = getSession().createSQLQuery(sql);
query.executeUpdate();
¶þ¡¢
String sql = "select to_char(SYN_DATE,' ......