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

sql¸ñʽ»¯Êä³ö

SQL code:

SQL> col deptno format a10 heading "񅧏"
SQL> select * from dept;

±àºÅ ²¿ÃÅ LOC
---------- ---------- -------------
########## ACCOUNTING NEW YORK
########## RESEARCH DALLAS
########## SALES CHICAGO
########## OPERATIONS BOSTON

¸ñʽ»¯»¯Êä³öÈ«ÊÇ¡®#¡¯°¡£¿
a10СÁË£¬´óÒ»µã£¬

»¹ÓоÍÊÇÔõô°Ñ¡°±àºÅ¡±Õâ¸ö±êÇ©¸ø¸Ä»ØÀ´£¬¸Ä³Édepton
ÎÒÓÃ
col 񅧏 heading depton
Ôõô²»Ðа¡£¿

ÒýÓÃ
a10СÁË£¬´óÒ»µã£¬

ÎÒ¶¼Éèµ½a500ÁË»¹ÊÇÒ»Ñù¡£ÊÇÄĸöµØ·½´íÁËÂð£¿

select ±àºÅ "depton" from dept;  ÊDz»ÊÇÕâ¸öЧ¹û£¿

ÒýÓÃ
select ±àºÅ "depton" from dept;  ÊDz»ÊÇÕâ¸öЧ¹û£¿

Ïë¸Ä³ÉÕâÖÖÐÎʽ
SQL code:

deptno ²¿ÃÅ LOC
---------- ---------- -------------
########## ACCOUNTING NEW YORK
########## RESEARCH DALLAS
########## SALES CHICAGO
########## OPERATIONS BOSTON


ÖªµÀÁË£¡
SQL> col deptno format 9999999999999
Õâ¾ÍºÃÁË


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

Çë½Ì¸÷λ´ó¸çÒ»¸öSqlÎÊÌ⣬Äĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¿

СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´


°à¼¶±í                  ½Ìʦ±í

°à¼¶ID    & ......

ÇósqlÓï¾ä

pln_id netnode_id
1          2
2          3
1          3
2          4

ÎÒ Ïë° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ