Linq to SQL equivalent to TOP

C# > LINQ > Take

Take returns the first specified number of elements.

Example

Linq to SQL equivalent to TOP

var query = from q in dc.Queries.OrderBy(f => f.name).Take(10)

Oracle DBMS_SCHEDULER

Oracle >  SYS.DBMS_SCHEDULER 

The DBMS_SCHEDULER package provides a collection of scheduling functions and procedures.

• Create job

Oracle create job example

Oracle >  SYS.DBMS_SCHEDULER > CREATE_JOB

The CREATE_JOB procedure creates a single job. You can create multiple jobs using the CREATE_JOBS procedure.

Example:

Oracle create job example

BEGIN

    SYS.DBMS_SCHEDULER.CREATE_JOB (

            job_name => '"db"."job"',

            job_type => 'PLSQL_BLOCK',

            job_action => 'delete from item',

            number_of_arguments => 0,

            start_date => TO_TIMESTAMP('19-FEB-14 04.51.50.316000000 PM', 'DD-MON-RR HH.MI.SS.FF AM'),

            repeat_interval => 'FREQ=DAILY;BYHOUR=3',

            end_date => NULL,

            job_class => 'DEFAULT_JOB_CLASS',

            enabled => false,

            auto_drop => true,

            comments => NULL);

END;

sys.schemas SQL Server example

SQL Server > Catalog Views > sys.schemas

Gets information about database schema.

Example:

select * from sys.schemas

Result

Timestamp to date Oracle

Oracle > Timestamp > To Date

select * from your_table
where
TO_DATE (TO_CHAR (timestamp_date, 'YYYY-MON-DD'),'YYYY-MON-DD') = '18-FEB-2014'
 

sys.data_spaces SQL Server

SQL Server > Catalog Views > sys.data_spaces

Return info for each data space.

Example

select * from sys.data_spaces

Add Image Column to Telerik Radgrid

Telerik > RadGridView > GridViewImageColumn

GridViewImageColumn displays read-only images for database columns of image data





GridViewImageColumn imageColumn = new GridViewImageColumn();
imageColumn.Name = "imgCol";
imageColumn.FieldName = "dbPhoto";
imageColumn.HeaderText = "Picture";
imageColumn.ImageLayout = ImageLayout.Zoom; // Zoom - Image is zoomed but the aspect ratio is preserved:
radGridView1.MasterTemplate.Columns.Insert(3, imageColumn);