sqlÀàÐÍת»»º¯ÊýcastºÍconvert
¼ò½é£º
Êý¾ÝÀàÐÍת»»¿ÉÒÔͨ¹ýCAST()ºÍCONVERT()º¯ÊýÀ´ÊµÏÖ¡£´ó¶àÊýÇé¿öÏ£¬ÕâÁ½¸öº¯ÊýÊÇÖصþµÄ£¬ËüÃÇ·´Ó³ÁËSQLÓïÑÔµÄÑÝ»¯ÀúÊ·¡£ÕâÁ½¸öº¯ÊýµÄ¹¦ÄÜÏàËÆ£¬²»¹ýËüÃǵÄÓï·¨²»Í¬¡£ËäÈ»²¢·ÇËùÓÐÀàÐ͵ÄÖµ¶¼ÄÜת±äΪÆäËûÊý¾ÝÀàÐÍ£¬µ«×ܵÄÀ´Ëµ£¬ÈκοÉÒÔת»»µÄÖµ¶¼¿ÉÒÔÓüòµ¥µÄº¯ÊýʵÏÖת»»¡£
Óï·¨£º
CAST ( expression AS data_type )
CONVERT (data_type[(length)], expression [, style])
ÓÃÀý£º
A.¼ìË÷ÊéÃûµ±Ç°ÏúÊÛ¶îµÄµÚһλÊý×ÖΪ3£¬Í¨¹ý½«ytd_salesת»»Îªchar(20)ʵÏÖ¡£
USE pubs
GO
SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales
from titles
WHERE CAST(ytd_sales AS char(20)) LIKE '3%'
GO
USE pubs
GO
SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales
from titles
WHERE CONVERT(char(20), ytd_sales) LIKE '3%'
GO
B. ʹÓôøÓÐËãÊõÔËËã·ûµÄCAST
USE pubs
GO
SELECT CAST(ROUND(ytd_sales/price, 0) AS int) AS 'Copies'
from titles
GO
C. ʹÓÃCAST½øÐд®Áª
USE pubs
GO
SELECT 'The price is ' + CAST(price AS varchar(12))
from titles
WHERE price > 10.00
GO
D.ʹÓÃCAST»ñµÃ¸ü¶àÒ׶ÁÎı¾
USE pubs
GO
SELECT CAST(title AS char(50)), &n
Ïà¹ØÎĵµ£º
Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ czdImport Dat ......
1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......
µ¼Èë·½·¨£ºÍ¨¹ýMsSqlDump¹¤¾ßÉú³Ésql½Å±¾²¢µ¼Èë
µ¼ÈëMSSQLÊý¾Ý¿âµÄµÚÈýÖÖ·½·¨£¬ÊÇͨ¹ýµÚÈý·½MsSqlDump¹¤¾ßÉú³Ésql²¢µ¼Èë¡£
ÊÊÓ÷¶Î§£ºÃ»Óд´½¨Êý¾Ý¿âµÄsql½Å±¾£¬µ«ÊÇÓÐÕýÔÚÔËÐеÄÊý¾Ý¿â
ÕâÖÖ±¸·Ý·½·¨£¬ÐèÒª½èÖúµÚÈý·½¹¤¾ß£ºMsSqlDump ¡£
Ê×ÏÈÔÚ±¾µØ¿ª·¢»·¾³ÉÏ£¬´ò¿ªMSSQLÆóÒµ¹ÜÀíÆ÷£¬ÕÒµ½ÕýÔÚÔËÐеÄÊý¾Ý¿â¡£ÀýÈçÒª¶Ô±¾ ......
SQL Server Express 2005£¨ÒÔϼò³Æ SQLExpress£© ÊÇÓÉ΢Èí¹«Ë¾¿ª·¢µÄ SQL Server 2005£¨ÒÔϼò³Æ SQL2005£©µÄËõ¼õ°æ£¬Õâ¸ö°æ±¾ÊÇÃâ·ÑµÄ£¬Ëü¼Ì³ÐÁË SQL Server 2005 µÄ¶àÊý¹¦ÄÜÓëÌØÐÔ£¬È磺°²È«ÐÔÉèÖá¢×Ô¶¨Ò庯ÊýºÍ¹ý³Ì¡¢Transact-SQL¡¢SQL¡¢CLR µÈ£¬»¹Ãâ·ÑÌṩÁ˺ÍËüÅäÌ׵ĹÜÀíÈí¼þ SQL Server Management Studio Expre ......
SQL Óï·¨Ìصã:
1 ÿ¸öÓï¾äÒÔ;½áÊø£¬ÖмäÓÃ()°üº¬£¬,¼ä¸ô¡£
2 ¶Ô±äÁ¿ºÍ³£Á¿µÈÐèÒªÓÃ()°üº¬¡£
3 ¹Ø¼ü×Ö´óд£¬±äÁ¿ÃûÊ×´óд×ÖĸÓñíÃû±íÕ÷£¬È»ºóÓÃСд±íÕ÷ÊôÐÔ
»ù±¾Óï¾ä:
DESC ±íÃû
²é¿´±íÏêϸÊôÐÔ
½¨±í: CREATE TABLE ±íÃû
( ÊôÐÔÃû ÀàÐÍ(Ô¼Êø) Ö÷¼ü(PRIMARY KEY)
Èç¹ûÊÇÓòΪÖ÷¼ü PRIMARY KEY(ÊôÐÔ.. ......