PowerDesignerÉú³ÉSQL½Å±¾Ê±±íÃû¡¢×Ö¶ÎÃû´øÒýºÅÎÊÌâ
PowerDesignerÉú³ÉSQL½Å±¾Ê±±íÃû¡¢×Ö¶ÎÃû´øÒýºÅÎÊÌâ
ʹÓÃPowerDesignerÉú³ÉÊý¾Ý¿â½Å±¾Ê±£¬±íÃûÒ»°ã»á´øÒýºÅ¡£ÈçÏ£º
¼ÓÒýºÅÊÇPL/SQLµÄ¹æ·¶£¬Êý¾Ý¿â»áÑϸñ°´ÕÕ“”ÖеÄÃû³Æ½¨±í£¬Èç¹ûûÓГ”£¬»á°´ÕÕORACLEĬÈϵÄÉèÖý¨±í£¬Ä¬ÈÏÊÇÈ«²¿´óд£¬ÕâÑù£¬ÔÚORACLEÊý¾Ý¿âÀïµÄ×ֶξÍÈç“Column_1”£¬Èç¹ûÄã°ÑÒýºÅÈ¥µô£¬ORACLE×Ô¶¯Ä¬ÈÏΪȫ²¿´óд£¬¼´“COLUMN_1”£¬ËùÒÔ²»±Øµ£ÐÄ£¬Õâ¶ÎSQLÔÚPL/SQLÖÐÖ´ÐеÄʱºòÊÇûÓÐÈκÎÎÊÌâµÄ£¬Èç¹û²»¼ÓÒýºÅ£¬ÔÚPL/SQL»á×Ô¶¯Ê¶±ðΪ´óд¡£
Õâ¸öÎÊÌâÊÇÉú³É½Å±¾¸ñʽµÄÎÊÌ⣬ÎÒÃÇ¿ÉÒÔ³¢ÊÔÔÚDBMSÅäÖÃÎļþÖÐÐÞ¸ÄÏàÓ¦µÄ¸ñʽÉèÖÃÀ´½â¾öÕâ¸öÎÊÌâ¡£ÔÚPowerDesignerÖУ¬Ñ¡ÔñDatabase->Edit current database£¬Ñ¡ÔñScript-->Sql->Format£¬ÓÐÒ»ÏîCaseSensitivityUsingQuote£¬ËüµÄcommentΪ “Determines if the case sensitivity for identifiers is managed using double quotes”£¬±íʾÊÇ·ñÊÊÓÃË«ÒýºÅÀ´¹æ¶¨±êʶ·ûµÄ´óСд£¬¿ÉÒÔ¿´µ½ÓұߵÄvaluesĬÈÏֵΪ“Yes”£¬ÈçÏÂËùʾ£º
½«“Yes”ÐÞ¸ÄΪ“No”£¬µã»÷¡¾È·¶¨¡¿°´Å¥¡£ÔÚµ¯³öµÄÈ·È϶Ի°¿òÖеã»÷¡¾È·ÈÏ¡¿¡£
ÕâÑùÉèÖÃÖ®ºó£¬Éú³ÉSQL¾Í²»»á´øÒýºÅÁË¡£ÈçÏÂËùʾ£º
Áí£ºÈç¹û½¨±í½Å±¾ÖÐʹÓÃÒýºÅ¡£Ôöɾ¸Ä²éʱ£¬±íÃû¡¢×Ö¶ÎÃûÒ²Òª¼ÓÒýºÅ¡£ÁíÍ⣬ÎÞ·¨Ê¹ÓÃdescÃüÁîÀ´²é¿´±íµÄ½á¹¹¡£¾ÙÀýÈçÏ£º
l ½¨±í(SQLÖеıíÃû¡¢×Ö¶ÎÃû´øÒýºÅ)£º
create table "xxxx" (
"alarm_def_id" NUMBER(12) not null,
"alarm_type_id" CHAR(1) not null
constraint CKC_xxx check ("alarm_t
Ïà¹ØÎĵµ£º
Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......
How To Use Dynamic Sql in Sql Server ?
¶¯Ì¬SQL ÔÚsql server ProcedureÖеÄÓ¦ÓÃ
Create PROCEDURE [dbo].[Proc_Get_Serial_No]
(
@Table_Name varchar(20),
......
1¡¢ÔÚ°²×°ÓÐSQL SERVER 2000µÄµçÄÔÉÏ´ò¿ª“ʼþ̽²éÆ÷”£¬²Ù×÷Èçͼ£º
2¡¢Ôړʼþ̽²éÆ÷”ÖÐн¨Ò»¸ö¸ú×Ù£ºÎļþ/н¨/¸ú×Ù
3¡¢ÊäÈëÁ¬½Ó·þÎñÆ÷µÄÃØÃÜ£¬×¢ÒâÊÇU8µÄÊý¾Ý·þÎñÆ÷£¬¿ÉÒÔ¸ù¾Ýʵ¼ÊÐÞ¸ÄIPµØÖ·¡£
4¡¢¸ü¸Ä¹ýÂËÉèÖ㺿ÉÒÔÔÚ¡¾Îļþ/ÊôÐÔ¡¿´ò¿ªÕâ¸ö¶Ô»°¿ò£¬µ«ÊÇÒª¸ü¸Ä£¬Ê× ......
¶àÓàµÄ»°¾Í²»¶à˵ÁË£¬ÕýÊÔlinq to sqlµÄѧϰ¡£
ÏÈÀ´¿´¿´linq to sql µÄÌØÐÔ:
×Ô¶¯ÊôÐÔ(Auto-Implemented Properties)
Òþº¬ÀàÐ;ֲ¿±äÁ¿(Local Variable Type Inference)
ÄäÃûÀàÐÍ(Anonymous Types)
¶ÔÏóÓ뼯ºÏ³õʼ»¯Æ÷(Object and Collection Initializers)
À©Õ¹·½·¨(Extension Methods)
Lambda±í´ïʽºÍLambda±í´ïʽ ......
ÏÖÔÚÓÃMSSQLµÄµØ·½Ì«¶àÁË£¬Óкܶà×ö¼¼ÊõµÄ¸öÈ˵çÄÔÉÏÒ²°²×°SQLרҵ°æ£¬ÒòΪËüÓõĶ࣬µ«ÓõÄÈ˶¼ÖªµÀ£¬SQLÓиö³¬¼¶Óû§sa£¬´ËÓû§Ä¬ÈÏÇé¿öÏ£¬ËüÖ¸Åɸø¹Ì¶¨·þÎñÆ÷½ÇÉ« sysadmin£¬²¢²»ÄܽøÐиü¸Ä¡£Ò»°ã¶®µã°²È«ÎÊÌâµÄ¼¼ÊõÈËÔ±¶¼»á°ÑÕâ¸öÃÜÂëÐ޸ĵô£¬µ«ÐÞ¸ÄÔÙ¸´ÔÓµÄÃÜÂ붼²»ÊǾø¶Ô°²È«µÄ£¬Ò»Ð©±©Á¦ÆƽâÈí¼þ£¬²ËÄñ¶¼»áÓá£
ÄÇ ......