Search In
<-- Chapter 22: SQL Select Top
Chapter 23
SQL Wildcards
SQL Wildcard characters are used to substitute any characters in a string. As we have discussed LIKE operator in chapter 10. SQL supports two wildcard operators with LIKE operator i.e (
A cursor is a database object that can be created at runtime. It is used to get data from a result set line by line(or row by row) rather than executing all the rows in the result set at a single time like an SQL-transaction. Generally, w
Some of the most famous games for mobiles are found on Android. In recent years we have seen an influx of so many games in different genres. First, we saw many parts of Angry Birds taking off on Android and later we saw famous games like Candy Crush
Drupal provide a mean to pass information easily to JavaScript. Many applications want to pass configuration information to JavaScript that runs on a page.
"Hello World!"), 'setting');
//Inline Js
drupal_add_js('alert(Drupal.settings.helloworld);',
As i have already defined what all things we need as prerequisite to access a blob in Azure in my previous blog Retrieve File from a private container in Azure, Here is the code for Storing byte array in an Azure blob
public string UploadByteArrayTo
The SQL like clause is used to look for the values which are similar to the values in the table with the help of wildcard operators. We have two types of wildcard operators:
1. "%” - percent sign
2. “_”- underscore
Syntax:
SELECT FROM
There are many ways to restore MSSQL Server database from backup files(.bak) like using tools available in SQLServer Management tools. But we face problems when the backup was not created on the same machine or it was shared by someone else or it wa
I have an app that contains a database using java sql, and has a jTable that displays the database info. It works fine, EXCEPT for when I am trying to store and display images to one of the columns. I used the jTable1.setModel(DbUtils.resultSet
1> Read CSV file
When you read the CSV file in php you use the code given below.Here we use the fopen(), fgetcsv() functions to read the csv file.
The below code reads data from a CSV file read.csv
<?php
if (($handle = fopen("read.csv", "r"
@PathVariable:
Sometimes we need to pass parameters along with the url to get the data. In Spring MVC framework, we can customize the URL in order to get data. For this purpose @PathVariable annotation is used in Spring framework. @PathVariable is u
