SQL ³£Óú¯Êý ±Ê¼Ç
Garin Zhang
SQL³£Óú¯Êý£º
1. ASCII()£º·µ»Ø×Ö·û´®×î×ó¶Ë×Ö·ûµÄASCIIÂë¡£
2. CHAR()£º½«ASCIIת»»³É×Ö·û¡£(0~255)
3. LOWER()ºÍUPPER()¡£
4. STR()£º°ÑÊýÖµÐÍÊý¾Ýת»»Îª×Ö·ûÐÍÊý¾Ý
SRT(<float_expression>[,length[,<decimal>]])
LTRIM()°Ñ×Ö·û´®Í·²¿¿Õ¸ñÈ¥µô£¬RTRIM()°Ñ×Ö·û´®Î²¿Õ¸ñÈ¥µô¡£
È¡×Ó´®º¯Êý£º
1. LEFT(<chars>, length)£º·µ»Øchar×óÆðlength¸ö×Ö·û¡£
2. RIGHT(<chars>, length)£º·µ»ØcharÓÒÆðlength¸ö×Ö·û¡£
3. SUBSTRING(<chars>, <position>, length)£º·µ»Øchars×ó±ßµÚposition¸ö×Ö·ûÆðlength¸ö×Ö·û²¿·Ö¡£
×Ö·û´®±È½Ï£º
1. QUOTENAME(<chars>[,quote_char])£º·µ»Ø±»Ìض¨×Ö·ûÀ¨ÆðÀ´µÄ×Ö·û´®¡£quote_charȱʡΪ"[]"
2. REPLICATE(<chars>, integer)£º·µ»ØÒ»¸öÖظ´integer´ÎÊýµÄchars¡£
3. REVERSE(<chars>)£º½«chars×Ö·û´®µÄ×Ö·ûÅÅÁÐ˳Ðòµßµ¹¡£
4. REPLACE(str1, str2, str3)£ºÓÃstr3Ìæ»»ÔÚstr1ÖеÄ×Ó´®str2.
5. SPACE(length)£º·µ»ØÒ»¸öÓÐÖ¸¶¨³¤¶ÈµÄ¿Õ°××Ö·û´®¡£
6. STUFF(str1, start, length, str2)£ºÓÃstr2Ìæ»»str1ÖдÓstart¿ªÊ¼µÄlength³¤¶ÈµÄ×Ö·û´®¡£
Êý¾ÝÀàÐÍת»»º¯Êý£º
1. CAST(str1 AS <data_type>[length])£º½«str1ÏÔʾµÄת»»ÎªÁíÒ»Êý¾ÝÀàÐÍ¡£
2. CONVERT(<data_type>[length], <expression>[, style])¡£
ÔÚ±ê×¼SQLÖÐÓÃÓÚת»¯encoding£ºCONVERT('abc' USING utf8); // MySQL
CONVERT('abc', 'UTF8', 'LATIN'); // postgres
ÔÚSQL ServerÖУºÓëCASTÀàËÆ
ÈÕÆÚº¯Êý£º
1. day(str), ·µ»ØstrÖеÄÈÕÆÚÖµ
2. month(str), year(str)
3. DATEADD(<datepart>, <number>, <data>) // data¼ÓÉÏdatepartµÄaddÖ®ºóµÄÐÂÈÕÆÚ
4. DATEDIFF(<datepart>, <date1>, <date2>)
5. DATENAME(<datepart>, <date>) // ·µ»ØdatepartÖ¸¶¨²¿·Ö
6. DATEPART(<datepart>, <date>) //·µ»ØÕûÊý£¬DAT
Ïà¹ØÎĵµ£º
SQL Server Êý¾Ý¿â¹ÊÕÏÐÞ¸´¶¥¼¶¼¼ÇÉÖ®Ò»
2010-04-26 10:37:52 À´Ô´:TechTargetÖйú ÎÒÒªÊÕ²Ø
SQL Server 2005 ºÍ 2008 Óм¸¸ö¹ØÓڸ߿ÉÓÃÐÔµÄÑ¡ÏÈçÈÕÖ¾´«Êä¡¢¸±±¾ºÍÊý¾Ý¿â¾µÏñ¡£ËùÓÐÕâЩ¼¼Êõ¶¼Äܹ»×÷Ϊά»¤Ò»¸ö±¸Ó÷þÎñÆ÷µÄÊֶΣ¬Í¬Ê±Õâ¸öÊý¾Ý¿â¿ÉÒÔÔÚÄãÔÏȵÄÖ÷Êý¾Ý¿â³öÎÊÌâʱÉÏÏß²¢×÷ΪеÄÖ÷·þÎñÆ÷¡£È»¶ø£¬Äã± ......
create table students (
name varchar(25),
class varchar(25),
grade int
)
insert into students values ('ÕÅÈý','ÓïÎÄ',20)
insert into students values ('ÕÅÈý','Êýѧ',90)
insert into students values ('ÕÅÈý','Ó¢Óï',50)
insert into students values ('ÀîËÄ','ÓïÎÄ',81)
insert in ......
Oracle·¢²¼Ãâ·ÑÊý¾Ý¿â¿ª·¢¹¤¾ßSQL Developer 1.2
2007.09.25 À´×Ô£ºCSDN¡¡ ÄŲ»º° ¹²ÓÐÆÀÂÛ()Ìõ ·¢±íÆÀÂÛ ÊÕ²Ø
Oracle SQL DeveloperÊǼ׹ÇÎĹ«Ë¾Ãâ·ÑÌṩµÄÊý¾Ý¿â¿ª·¢¹¤¾ß£¬¿É°ïÖúÓû§¼ò»¯¿ª·¢¹¤×÷£¬Ìá¸ß±àÖƺ͵÷ÊÔSQLºÍPL/SQL´úÂëµÄЧÂÊ¡£ÏÖÔÚ£¬Õâ¸öÃâ·Ñ¹¤ ......
ÊÓͼ
SET¡¡NOCOUNT ON;
SET Northwind;
GO
IF OBJECT_ID('dbo.ViewName') IS NOT NULL
DROP VIEW dbo.ViewName;
GO
CREATE VIEW dbo.Viewname
AS
SELECT * from customer AS C
WHERE EXISTS
(SELECT * from dbo.Orders AS O
WHERE O.CustomerI ......