sql ʵÏּǼÓÐÖظ´Ö»ÏÔʾһÌõ¡£
col_1 col_2 col_3 col_4
---------- ---------- ---------- ----------
a 111 222 333
a 11 22 33
b 111 222 333
b 11 22 333
ÐèÇó£º ÊµÏÖÈç¹ûcol_1ÁеÄÖµ³öÏÖÏàͬ£¬ Ö»ÏÔʾµÚÒ»Ìõ.
½á¹û:
col_1 col_2 col_3 col_4
---------- ---------- ---------- ----------
a 111 222 333
b 111 222 333
ÈçºÎȥʵÏÖ£¿
Ïà¹ØÎĵµ£º
¿ª·ÅÐÔ ¡¡¡¡SQL Server
¡¡¡¡Ö»ÄÜÔÚWindows ÉÏÔËÐУ¬Ã»ÓÐË¿ºÁµÄ¿ª·ÅÐÔ£¬²Ù×÷ϵͳµÄϵͳµÄÎȶ¨¶ÔÊý¾Ý¿âÊÇÊ®·ÖÖØÒªµÄ¡£Windows9XϵÁвúÆ·ÊÇÆ«ÖØÓÚ×ÀÃæÓ¦Óã¬NT serverÖ»ÊʺÏÖÐСÐÍÆóÒµ¡£¶øÇÒWindowsƽ̨µÄ¿É¿¿ÐÔ£¬°²È«ÐÔºÍÉìËõÐÔÊǷdz£ÓÐÏ޵ġ£Ëü²»ÏóUnixÄÇÑù¾Ã¾¿¼Ñ飬ÓÈÆäÊÇÔÚ´¦Àí´óÊý¾ÝÁ¿µÄ¹Ø¼üÒµÎñʱ¡£
¡¡¡¡Oracle
......
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý¡£
select datediff(day,'2004-09-01','2004-09-18') --· ......
SQL Server CONVERT() º¯Êý
¶¨ÒåºÍÓ÷¨
CONVERT() º¯ÊýÊÇ°ÑÈÕÆÚת»»ÎªÐÂÊý¾ÝÀàÐ͵ÄͨÓú¯Êý¡£
CONVERT() º¯Êý¿ÉÒÔÓò»Í¬µÄ¸ñʽÏÔʾÈÕÆÚ/ʱ¼äÊý¾Ý¡£
Óï·¨
CONVERT(data_type(length),data_to_be_converted,style)
data_type(length) ¹æ¶¨Ä¿±êÊý¾ÝÀàÐÍ£¨´øÓпÉÑ¡µÄ³¤¶È£©¡£data_to_be_converted º¬ÓÐÐèҪת»»µÄÖµ¡£styl ......
ʲôÊÇË÷Òý
¡¡¡¡
¡¡¡¡Ë÷ÒýÊǽ¨Á¢ÔÚ±íµÄÒ»Áлò¶à¸öÁÐÉϵĸ¨Öú¶ÔÏó£¬Ä¿µÄÊǼӿì·ÃÎʱíÖеÄÊý¾Ý£»
¡¡¡¡
¡¡¡¡Oracle´æ´¢Ë÷ÒýµÄÊý¾Ý½á¹¹ÊÇB*Ê÷£¬Î»Í¼Ë÷ÒýÒ²ÊÇÈç´Ë£¬Ö»²»¹ýÊÇÒ¶×ӽڵ㲻ͬB*ÊýË÷Òý£»
¡¡¡¡
¡¡¡¡Ë÷ÒýÓɸù½Úµã¡¢·ÖÖ§½ÚµãºÍÒ¶×Ó½Úµã×é³É£¬Éϼ¶Ë÷Òý¿é°üº¬Ï¼¶Ë÷Òý¿éµÄË÷ÒýÊý¾Ý£¬Ò¶½Úµã°üº¬Ë÷ÒýÊý¾ÝºÍÈ·¶¨ÐÐ ......
Sql Server2005µÄ:
SELECT
TableName=CASE WHEN C.column_id=1 THEN O.name ELSE N'' END,
TableDesc=ISNULL(CASE WHEN C.column_id=1 THEN PTB.[value] END,N''),
Column_id=C.column_id,
ColumnName=C.name,
PrimaryKey=ISNULL(IDX.PrimaryKey,N''),
[IDENTITY]=CASE WHEN C.is_identity=1 THEN N'√' ......