|
Description
|
Oracle
|
SQL Server
|
|
Format Date
|
to_date(dtt_CreatedDate,'DD-MON-YYYY') as dtt_CreatedDate,
|
Convert(varchar,dtt_CreatedDate,106) as dtt_CreatedDate,
|
|
Null to number
|
NVL(int_UserId,0) as int_UserId,
|
isnull(int_UserId,0) as int_UserId,
|
|
Current date
|
SYSDATE
|
GETDATE
|
|
Get substring from string
|
SUBSTR
|
SUBSTRING
|
|
Find string in string
|
INSTR
|
CHARINDEX
|
|
Concatenate string
|
CONCAT(str1,str2)
|
Str1 + str2
|
|
|
if intID=0 then
|
if @intID=0
|
Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts
Thursday, March 14, 2013
Oracle versus Sql Server
Subscribe to:
Posts (Atom)