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Çø·Ö¡¡
Çø·Ö´óСд:Èç¹ûÏëÈñȽϽ«´óд×ÖĸºÍСд×ÖĸÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî¡£
Çø·ÖÖØÒô:Èç¹ûÏëÈñȽϽ«ÖØÒôºÍ·ÇÖØÒô×ÖĸÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî¡£Èç¹ûÑ¡Ôñ¸ÃÑ¡Ï±È½Ï»¹½«ÖØÒô²»Í¬µÄ×ÖĸÊÓΪ²»µÈ¡£Çø·Ö¼ÙÃû:Èç¹ûÏëÈñȽϽ«Æ¬¼ÙÃûºÍƽ¼ÙÃûÈÕÓïÒô½ÚÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî¡£Çø·Ö¿í¶È:Èç¹ûÏëÈñȽϽ«°ë½Ç×Ö·ûºÍÈ«½Ç×Ö·ûÊÓΪ²»µÈ£¬ÇëÑ¡Ôñ¸ÃÑ¡Ïî
Ïà¹ØÎĵµ£º
MDX º¯Êý²Î¿¼
SQL Server 2008 Áª»ú´ÔÊ飨2009 Äê 7 Ô£©
MDX º¯Êý²Î¿¼ (MDX)
Microsoft SQL Server Analysis Services ÔÊÐíÔÚ¶àά±í´ïʽ (MDX) Óï·¨ÖÐʹÓú¯Êý¡£º¯Êý¿ÉÒÔÔÚÈκÎÓÐЧµÄ MDX Óï¾äÖÐʹÓ㬲¢ÇÒ¾³£ÓÃÓÚ²éѯ¡¢×Ô¶¨Òå»ã×ܶ¨ÒåÒÔ¼°ÆäËû¼ÆËã¡£ ±¾½Ú½éÉÜ Analysis Services ¸½´øµÄ MDX º¯Êý¡£
¿ÉÒÔʹÓÃÏÂÃæÕâÐ ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PE011_Page]
@TableName varchar(50), --±íÃû
@Fields varchar(5000) = '*', --×Ö¶ÎÃû(È«²¿×Ö¶ÎΪ*)
@OrderField varchar(5000), &n ......
<!--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 -->
......
--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(* ......
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER TABLE --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹
CREATE VIEW --´´½¨Ò»¸öÊÓͼ
DRO ......