how to use funcions Determine the result of each of the function calls in the fo

Question

how to use funcions

Determine the result of each of the function calls in the following questions. Assume values for variables as follows: Name = ' Ann Smith ' (underscore = space) New value = 4.743 NewDate = 2013-4-12 (no time part) OldDate=2012-4-12 (no time part) LTRIM(Name) RTRIM(Name) LTRIM(RTRIM(Name)) SUBSTRING(Name, 3,3) REVERSE(Name) REPLACE(Name,'Smith','Jones') Round(NewValue,0) ROUND(NewValue,1) ROUND(NewValue,0,1) ISNUMERIC(NewValue) FLOOR(NewValue) CEILING(NewValue) ROUND(SQUARE(NewValue)), ,3) DATEPART(year. NewDate) DATEPART(month, NewDate) DATEPART(day,Newdate) DATENAME(month, NewDate) ISDATE(NewDate) DATEADD(year, 1,NewDate) DATEADD(day, 5,NewDate) DATEDIFF(day. QldDate, NewDate) DATEDIFF(year, OldDate, NewDate) Suppose you designed a database table for a client with a 50 character text field named ADDRESS. The client has added about 500,000 records to this table. Now, they want to be able to break the address apart for sorting, etc. How would you do this?

Explanation / Answer

funstions are already defined in the libraray...you just have to call them

like for eg in C ,you can call them with

include<stdio.h>

include < conio.h>

sum(a:b)

here sum is a n already deifned fuction in the libraby and need not be defined everytime...

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.