Can someone help me parse this oracle insert statement into SQL Server please?
insert into notify_template (subject, body, priority)
values
(
'
Budgeted time exceeded for task [18040]
',
'
Actual Time exceeds Budgeted time for the following task'
|| chr(10) || chr(10) ||
' Task Name : [18040]
Root Program Name : [18049]
Actual Days : [2000000100]
Budgeted Days : [2000000101]
Estimated Time : [2000000102]'
|| chr(10) || chr(10) ||
' The following resource(s) in the above task have exceeded the budgeted time:'
|| chr(10) || chr(10) ||
' [2000000784]'
|| chr(10) || chr(10) ||
' Click here : [12865]
',
2)Got it...
+ CAST(CHAR(10) AS VARCHAR) + CAST(CHAR(10) AS VARCHAR) +
for || chr(10) || chr(10) ||
No comments:
Post a Comment