Sep
24
2009
| Açıklama | Oracle | MS SQL Server |
|---|---|---|
| Smallest integer >= n | CEIL | CEILING |
| Modulus | MOD | % |
| Truncate number | TRUNC | <none> |
| Max or min number or string in list | GREATEST, LEAST |
<none> |
| Translate NULL to n | NVL | ISNULL
As of 7.0, also: COALESCE |
| Return NULL if two values are equal | DECODE
As of Oracle 9i, also: |
NULLIF |
| String concatenation | CONCAT(str1,str2) | str1 + str2 |
| Convert ASCII to char | CHR | CHAR |
| Capitalize first letters of words | INITCAP | <none> |
| Find string in string | INSTR | CHARINDEX |
| Find pattern in string | INSTR | PATINDEX |
| String length | LENGTH | DATALENGTH |
| Pad string with blanks | LPAD, RPAD |
<none>
Workaround: Use REPLICATE(' ', n) and string concatenation |
| Trim leading or trailing chars other than blanks | LTRIM(str,chars), RTRIM(str,chars) |
<none> |
| Replace chars in string | REPLACE | STUFF, REPLACE |
| Convert number to string | TO_CHAR | STR, CAST |
| Convert string to number | TO_NUMBER | CAST |
| Get substring from string | SUBSTR | SUBSTRING |
| Char for char translation in string | TRANSLATE | <none> |
| Date addition | ADD_MONTH or + | DATEADD or + |
| Date subtraction | MONTHS_BETWEEN or - | DATEDIFF |
| Last day of month | LAST_DAY | <none> |
| Time zone conversion | NEW_TIME | <none> |
| Next specified weekday after date | NEXT_DAY | <none> |
| Convert date to string | TO_CHAR | DATENAME, CONVERT |
| Convert string to date | TO_DATE | CAST |
| Convert date to number | TO_NUMBER(TO_CHAR(d)) | DATEPART |
| Parse date into parts (year, month, day, hour, min, sec, etc.) | TO_CHAR(date, format_string) Examples: TO_CHAR(SYSDATE, 'yyyy') TO_CHAR(SYSDATE, 'ss') etc. Also, as of Oracle 9.2: EXTRACT (date_part FROM date) Examples: EXTRACT(YEAR FROM SYSDATE) EXTRACT(SECOND FROM SYSDATE) etc. |
DATEPART(date_part, date) Examples: DATEPART(YEAR, GETDATE()) DATEPART(SECOND, GETDATE()) etc. Also: YEAR(), DAY(), MONTH() |
| Date round | ROUND | CONVERT |
| Date truncate | TRUNC | CONVERT |
| Current date | SYSDATE | GETDATE or CURRENT_TIMESTAMP |
| Convert hex to binary | HEXTORAW | CAST |
| Convert binary to hex | RAWTOHEX | CONVERT |
| If statement in an expression | DECODE As of Oracle 9i, also: CASE ... WHEN or COALESCE |
CASE ... WHEN or COALESCE |
| User's login id number or name | UID, USER | SUSER_ID (deprecated), SUSER_NAME (deprecated), SUSER_SNAME (preferred) |
| User's database id number or name | UID, USER | USER_ID, USER_NAME |
| Current user | USER | USER |
vigrx yazdı : 10/24/09 10:08 AM
Hi, I can’t understand how to add your site in my rss reader. Can you Help me, please :)