ITCanopy

Go to Contact for which you want to mute ring tone: Touch on Default Ringtone and select None . When this contact calls you will not hear ring tone, but if you have enabled vibration or mobile is in vibration mode you mobile will still vibrates.

Below query will return column details: SELECT COL.ROW_ID AS 'Column Id' ,COL.NAME AS 'Column Name' ,COL.LENGTH AS 'Column Length' ,TAB.NAME AS 'Table Name' FROM S_COLUMN COL LEFT JOIN S_TABLE TAB ON TAB.ROW_ID = COL.TBL_ID WHERE 1=1

Add below in your SQL query and it will get date difference and convert into years: (DATEDIFF(MONTH,TABLE.BIRTH_DT,CURRENT_TIMESTAMP)/12) The DATEDIFF() function returns the difference between two dates. DATEDIFF(Interval, date_1, date_2) The CURRENT_TIMESTAMP() function returns the current date and time. SELECT CURRENT_TIMESTAMP()

Add below in your SQL query and it will subtract date column from today's date and convert into days: CONVERT(INT, GETDATE() - TABLE.CREATED_DATE) AS 'Age' OR DATEDIFF(DAY,TABLE.CREATED,GETDATE()) The GETDATE() function returns the current database system date and time. SELECT GETDATE() The CONVERT() function converts a value (of any type) into a specified datatype. CONVERT(data_type), expression/ value) SELECT CONVERT(INT, 1.1) The DATEDIFF() function returns the difference between two dates. DATEDIFF(Interval, date_1, date_2)

For getting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set SessionAccessService in Business Service Name. Set GetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Add Profile Attribute name against Name input argument. Go to Output Arguments and set the arguments as below: Add Process Property name in which you want to get Profile Attribute value.

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set  SessionAccessService in Business Service Name. Set  SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.

SQL : Structured Query Language SQL is used for storing, retrieving and manipulating (managing data) data in databases (MySql, Oracle, Sybase, MS Access). SQL is a query language, not a programming language. The SQL language is divided into queries, clauses and statements etc. It helps consumer (user) to describe and manipulate the data. Importance SQL is used for the query, insert, collect and manages data from the database. It store and fetch data from database immediately. It helps to find the needed data (information) easily. You can easily write commands almost same as we write English as it is a query language not a programming language. Almost every database system needs SQL for processing. Reasons to learn Easy to learn It doesn't require coding (SQL manages the database system by using standard SQL). You can run SQL on laptop, servers, e.t.c. SQL Standard (Databases are used by established standards. ANSI in 1986 and ISO in 1987). SQL defines foll...