Tutorial by Examples: b

In Production its good practice to secure your data and only allow operations on it to be undertaken via Stored Procedures. This means your application can't directly run CRUD operations on your data and potentially cause problems. Assigning permissions is a time-consuming, fiddly and generally oner...

XmlView: <mvc:View controllerName="sap.m.sample.ListCounter.List" xmlns:mvc="sap.ui.core.mvc" xmlns="sap.m"> <List headerText="Products" items="{products>/Products}"> <!-- Template of ...

Install apache: sudo apt-get install apache2 Install MySql: sudo apt-get install mysql-server Install PHP: sudo apt-get install php5 libapache2-mod-php5 Restart system: sudo systemctl restart apache2 Check PHP installation: php -r 'echo "\n\nYour PHP installation is working fi...

set clipboard=unnamed This makes it possible to copy/paste between Vim and the system clipboard without specifying any special register. yy yanks the current line into the system clipboard p pastes the content of the system clipboard into Vim This only works if your Vim installation has cli...

1. $_ : The default input and pattern-searching space. Example 1: my @array_variable = (1 2 3 4); foreach (@array_variable){ print $_."\n"; # $_ will get the value 1,2,3,4 in loop, if no other variable is supplied. } Example 2: while (<FH>){ chomp($_); # $_ re...

By default communication over the channcels is sync; when you send some value there must be a receiver. Otherwise you will get fatal error: all goroutines are asleep - deadlock! as follows: package main import "fmt" func main() { msg := make(chan string) msg <- "He...

<mvc:View controllerName="sap.m.sample.ListCounter.List" xmlns:mvc="sap.ui.core.mvc" xmlns="sap.m"> <List headerText="Fruits" items="{path:'products>/Products', sorter:{path:'Name'}, filter:{path:'Type', o...

Basic concept of IDisposable

Use the quotestar register to copy/paste between Vim and system clipboard "*yy copies the current line into the system clipboard "*p pastes the content of the system clipboard into Vim

One of the most important implementations of Dynamic Programming is finding out the Longest Common Subsequence. Let's define some of the basic terminologies first. Subsequence: A subsequence is a sequence that can be derived from another sequence by deleting some elements without changing the orde...

Weighted Job Scheduling Algorithm can also be denoted as Weighted Activity Selection Algorithm. The problem is, given certain jobs with their start time and end time, and a profit you make when you finish the job, what is the maximum profit you can make given no two jobs can be executed in parallel...

Suppose you are asked, given the total weight you can carry on your knapsack and some items with their weight and values, how can you take those items in such a way that the sum of their values are maximum, but the sum of their weights don't exceed the total weight you can carry? The 0-1 indicates e...

In general, we tend to back up the DB with the pgAdmin client. The following is a sh script used to save the database (under linux) in two formats: SQL file: for a possible resume of data on any version of PostgreSQL. Dump file: for a higher version than the current version. #!/bin/sh...

A public gist can be almost anything. A simple example of a Javascript function: function randomInt(min, max) { return Math.floor((max - min + 1) * Math.random()) + min; }

Go to Tools -> Options. Go to Environment -> Keyboard -> Query Shortcuts On the right side you can see some shortcuts which are by default in SSMS. Now if you need to add a new one, just click on any column under Stored Procedure column. Click OK. Now please go to a query window and sel...

Install the package: $ pip install pymssql import pymssql SERVER = "servername" USER = "username" PASSWORD = "password" DATABASE = "dbname" connection = pymssql.connect(server=SERVER, user=USER, password=PASSWORD, database=DATABASE...

XmlView: <mvc:View controllerName="sap.ui.demo.wt.controller.App" xmlns="sap.m" xmlns:mvc="sap.ui.core.mvc" displayBlock="true"> <App> <pages> <Page content="{path:'Tiles>/Tiles',fact...

Tables for Layout The structure of an HTML email file is similar to that of a web page: <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Hello!</title> </head> <body> &...

Apple iOS 10 Mail doesn't always auto-scale non-responsive emails. The auto-scale meta tag can be used to disable auto-scale feature in iOS 10 Mail entirely. <meta name="x-apple-disable-message-reformatting">