Search In
Basically Primary key is used to identify each row in a table . In a table Only one Primary key can be present . When in a table , there is more than one primary key then it would be called composite Primary key . Composite key is used when we need m
Sometime in a table we need two or more column to uniquely identify each row . Composite key is the combination of two or more Primary key . Primary key or candidate key come from the composite key .
Syntax in SQL :
create table table_name col_name1
A view is a virtual table which is stored in database with an associated name .Using views query we can select specific data from a large table . Suppose there is large database of any college , so i want to view the records of any one branch from th
This blog will help you to restrict data from a database.
You can restrict the rows returned from the query by using the WHERE clause. A WHERE clause contains a condition that must be met, and it directly follows the FROM clause. If the condition i
This blog will help you to restrict data from a database.
You can restrict the rows returned from the query by using the WHERE clause. A WHERE clause contains a condition that must be met, and it directly follows the FROM clause. If the condition i
First create a layout for Map Activity. The name of layout is activity_main.xml
<fragment
xmlns:android="http://schemas.android.com/apk/res/android"
android:id="@+id/map"
class="com.google.android.
This blog will show you how to create an xml from sql query having sql data. Write down the followng query to generate xml:-
WITH XMLNAMESPACES ('http://www.dossia.org/v2.0/xml/phr' as phr)
Select OrderResultID,OrderID ,PatientID ,SpecimenNumber ,Ac
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
Warning: "Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that requ
You can simply use below code to show the multiple markers on google map.
var arr = new Array();
function initialize() {
var i;
var Locations = [
{
lat:48.856614,
