Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQl Create Table has error=>is not valid...

½ñÌìÏÂÁ˸öWIN7µÄÓ¢ÎÄ°ü°Ñϵͳ»»³ÉÓ¢Îĵġ£¸Ð¾õ»¹ÐУ¬¿ÉÊǵ±´´½¨Êý¾Ý¿â±íʱ·¢ÏÖ³ö´íÁË£¬²éÁËϲÅÖªµÀÊÇSQLµÄÅÅÐò³öÎÊÌâÁË
ÏÂÃæÊÇCTRL+c V¸ã¹ýÀ´µÄ£¬Ö»ÊÇ·½±ã´ó¼ÒÓÐÕâÑùµÄÎÊÌâ¿ÉÒԵõ½½â¾ö
ʹÓÃSQL2005½øÐд´½¨Êý¾Ý¿âµÄʱºò£¬Èç¹ûÓöµ½´´½¨Ê§°ÜµÄÇé¿ö£¬ÈçÏ£º
Create ¶ÔÓÚ Êý¾Ý¿â“xxxx”ʧ°Ü¡£ (Microsoft.SqlServer.Smo)
Collation '<·þÎñÆ÷ĬÈÏÖµ>' is not valid.
(Microsoft.SqlServer.Smo)
     
ÕâÊÇÒòΪ´´½¨Êý¾Ý¿âµÄʱºò£¬Ã»ÓÐÖƶ¨ÕýÈ·µÄCollation£¨¼´“Ñ¡Ïî”ÖеēÅÅÐò¹æÔò”£©£¬Ò»°ãÇé¿öÏÂĬÈÏÊôÐԾͿÉÒÔÁË£¬µ«ÊÇÒ²²»Åųý³öÏÖÎÊÌâµÄ¿ÉÄÜ£¬ËùÒÔ£¬Èç¹û³öÏÖÉÏÊöÎÊÌ⣬Çë×ÔÐÐÖƶ¨ÕýÈ·µÄÅÅÐò¹æÔò¼´¿É:
Chinese_PRC_CI_AS¡£
      ¾ÍÅÅÐò¹æÔòµÄº¬Ò壬Ҳ×öϼòµ¥µÄ½éÉÜ£º MSÊÇÕâÑùÃèÊöµÄ£º
      "ÔÚ Microsoft SQL Server 2000
ÖУ¬×Ö·û´®µÄÎïÀí´æ´¢ÓÉÅÅÐò¹æÔò¿ØÖÆ¡£ÅÅÐò¹æÔòÖ¸¶¨±íʾÿ¸ö×Ö·ûµÄλģʽÒÔ¼°´æ´¢ºÍ±È½Ï×Ö·ûËùʹÓõĹæÔò¡£" ¡¡¡¡
      ÔÚ²éѯ·ÖÎöÆ÷ÄÚÖ´ÐÐÏÂÃæÓï¾ä£¬¿ÉÒԵõ½SQL¡¡SERVERÖ§³ÖµÄËùÓÐÅÅÐò¹æÔò¡£
   ¡¡¡¡¡¡¡¡select * from ::fn_helpcollations()
      ÅÅÐò¹æÔòÃû³ÆÓÉÁ½²¿·Ý¹¹³É£¬Ç°°ë²¿·ÝÊÇÖ¸±¾ÅÅÐò¹æÔòËùÖ§³ÖµÄ×Ö·û¼¯¡£È磺
¡¡¡¡Chinese_PRC_CS_AI_WS Ç°°ë²¿·Ý£ºÖ¸UNICODE×Ö·û¼¯£¬Chinese_PRC_Ö¸Õë¶Ô´ó½¼òÌå×ÖUNICODEµÄÅÅÐò¹æÔò¡£
      ÅÅÐò¹æÔòµÄºó°ë²¿·Ý¼´ºó׺ º¬Ò壺¡¡¡¡
_BIN ¶þ½øÖÆÅÅÐò¡¡¡¡
_CI(CS) ÊÇ·ñÇø·Ö´óСд£¬CI²»Çø·Ö£¬CSÇø·Ö¡¡¡¡
_AI(AS) ÊÇ·ñÇø·ÖÖØÒô£¬AI²»Çø·Ö£¬ASÇø·Ö¡¡¡¡¡¡¡¡¡¡
_KI(KS) ÊÇ·ñÇø·Ö¼ÙÃûÀàÐÍ,KI²»Çø·Ö£¬KSÇø·Ö¡¡     
_WI(WS) ÊÇ·ñÇø·Ö¿í¶È WI²»Çø·Ö£¬WSÇø·Ö¡¡
      Çø·Ö´óСд:Èç¹ûÏëÈñȽϽ«´óд×ÖĸºÍСд×ÖĸÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî¡£
     
Çø·ÖÖØÒô:Èç¹ûÏëÈñȽϽ«ÖØÒôºÍ·ÇÖØÒô×ÖĸÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî¡£Èç¹ûÑ¡Ôñ¸ÃÑ¡Ï±È½Ï»¹½«ÖØÒô²»Í¬µÄ×ÖĸÊÓΪ²»µÈ¡£Çø·Ö¼ÙÃû:Èç¹ûÏëÈñȽϽ«Æ¬¼ÙÃûºÍƽ¼ÙÃûÈÕÓïÒô½ÚÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî¡£Çø·Ö¿í¶È:Èç¹ûÏëÈñȽϽ«°ë½Ç×Ö·ûºÍÈ«½Ç×Ö·ûÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî


Ïà¹ØÎĵµ£º

[SQL Server2008]MDX º¯Êý²Î¿¼ (MDX)

MDX º¯Êý²Î¿¼
SQL Server 2008 Áª»ú´ÔÊ飨2009 Äê 7 Ô£©
MDX º¯Êý²Î¿¼ (MDX)
Microsoft SQL Server Analysis Services ÔÊÐíÔÚ¶àά±í´ïʽ (MDX) Óï·¨ÖÐʹÓú¯Êý¡£º¯Êý¿ÉÒÔÔÚÈκÎÓÐЧµÄ MDX Óï¾äÖÐʹÓ㬲¢ÇÒ¾­³£ÓÃÓÚ²éѯ¡¢×Ô¶¨Òå»ã×ܶ¨ÒåÒÔ¼°ÆäËû¼ÆËã¡£ ±¾½Ú½éÉÜ Analysis Services ¸½´øµÄ MDX º¯Êý¡£
¿ÉÒÔʹÓÃÏÂÃæÕâÐ ......

SQL SERVER 2005·ÖÒ³´æ´¢¹ý³Ì

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PE011_Page]
  @TableName varchar(50),        --±íÃû
 @Fields varchar(5000) = '*',    --×Ö¶ÎÃû(È«²¿×Ö¶ÎΪ*)
 @OrderField varchar(5000),    &n ......

Hibernate ²»Í¬Êý¾Ý¿âµÄÁ¬½Ó¼°SQL·½ÑÔ

<!--MySql Çý¶¯³ÌÐò eg. mysql-connector-java-5.0.4-bin.jar-->
  <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
  <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
  <!-- JDBC URL -->
......

sql Áгö¿âÖÐËùÓÐ±í¼°×Ö¶ÎÏêϸÐÅÏ¢

--select name from sysobjects where type='U' order by name
SELECT
(case when a.colorder=1 then d.name else '' end) ±íÃû,
-- a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) ±êʶ,
(case when (SELECT count(* ......

sql³£ÓÃÓï¾ä¼¯½õ

--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER TABLE --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹
CREATE VIEW --´´½¨Ò»¸öÊÓͼ
DRO ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ