Tutorial by Examples: for

First of all, Merged Cells are there only to improve the look of your sheets. So it is literally the last thing that you should do, once your sheet and workbook are totally functional! Where is the data in a Merged Range? When you merge a Range, you'll only display one block. The data will be ...

Pigeonhole Sort is a sorting algorithm that is suitable for sorting lists of elements where the number of elements (n) and the number of possible key values (N) are approximately the same. It requires O(n + Range) time where n is number of elements in input array and ‘Range’ is number of possible va...

Radix Sort is lower bound comparison based algorithm. It is a non-comparative integer sorting algorithm that sorts data with integer keys by grouping keys by individual digits which share some significant position and value. Radix sort is a linear time sorting algorithm that sort in O(n+k) time whe...

If you're creating an image, decoding an image, or resizing an image to fit the large notification image area, you can get the correct pixel dimensions like so: Resources resources = context.getResources(); int width = resources.getDimensionPixelSize(android.R.dimen.notification_large_icon_width)...

DBCC commands can show information about database objects. DBCC PROCCACHE Displays information in a table format about the procedure cache. DBCC OUTPUTBUFFER ( session_id [ , request_id ]) Returns the current output buffer in hexadecimal and ASCII format for the specified session_id (and o...

To render your new component in a view, you cust call: @Html.Action("MemberLoginForm", "MemberLoginSurface")

If you want to do different things based on the kind of error, use multiple rescue clauses, each with a different error type as an argument. def divide(x, y) begin return x/y rescue ZeroDivisionError puts "Don't divide by zero!" return nil rescue TypeError put...

Yu can define format of the file that will be imported using FORMATFILE option: INSERT INTO mytable SELECT a.* FROM OPENROWSET(BULK 'c:\test\values.txt', FORMATFILE = 'c:\test\values.fmt') AS a; The format file, format_file.fmt, describes the columns in values.txt: 9.0 2 1 SQ...

PERFORM VARYING TALLY FROM 1 BY 1 UNTIL TALLY > 5 DISPLAY TALLY END-PERFORM

PERFORM some-paragraph

All roles granted to user. select * from dba_role_privs where grantee= :username Privileges granted to user: system privileges select * from dba_sys_privs where grantee = :username object grants select * from dba_tab_privs where grantee = :username Permissions grante...

The following query will return informationa about qeries, their plans and average statistics regarding their duration, CPU time, physical and logical io reads. SELECT Txt.query_text_id, Txt.query_sql_text, Pl.plan_id, avg_duration, avg_cpu_time, avg_physical_io_reads, avg_logica...

SQL Query optimizer will choose the baes possible plan that he can find for some query. If you can find some plan that works optimally for some query, you can force QO to always use that plan using the following stored procedure: EXEC sp_query_store_unforce_plan @query_id, @plan_id From this poi...

Objective-C First add the Social Framework to the XCode project. Import the #import "Social/Social.h" class to the required ViewController Twitter with text, image and link //- - To Share text on twitter - - if([SLComposeViewController isAvailableForServiceType:SLServiceTypeTwitter]) ...

Consider a simple asynchronous method: async Task Foo() { Bar(); await Baz(); Qux(); } Simplifying, we can say that this code actually means the following: Task Foo() { Bar(); Task t = Baz(); var context = SynchronizationContext.Current; t.ContinueWith(task...

An Odd-Even Sort or brick sort is a simple sorting algorithm, which is developed for use on parallel processors with local interconnection. It works by comparing all odd/even indexed pairs of adjacent elements in the list and, if a pair is in the wrong order the elements are switched. The next step ...

First off, let's assume this is your initial model, inside an application called discography: from django.db import models class Album(models.Model): name = models.CharField(max_length=255) artist = models.CharField(max_length=255) Now, you realize that you want to use a ForeignKey ...

// initialize library $this->load->library('form_validation'); $this->form_validation->set_rules('username', 'Username', 'required|max_length[20]'); // Add validation rules for require and max $this->form_validation->set_rules('password', 'Password', 'required|matches[passw...

Different countries have different number formats and considering this we can have different formats using Locale of java. Using locale can help in formatting Locale locale = new Locale("en", "IN"); NumberFormat numberFormat = NumberFormat.getInstance(locale); using above fo...

Catalan numbers algorithm is Dynamic Programming algorithm. In combinatorial mathematics, the Catalan numbers form a sequence of natural numbers that occur in various counting problems, often involving recursively-defined objects. The Catalan numbers on nonnegative integers n are a set of numbers t...