Search In
Index in SQL can be thought of as index of a book. Suppose, We have a book of 50 pages and we don't have indexes. Now if we have to navigate to a random topic then we have to start with first page and then second and so on, No problem here we can
How to convert XML data to SQL database table
Step 1 : Create a table named "tblStudent" in database by following query in which xml data is to be inserted
CREATE TABLE tblStudent
(
StudentId INT,
StudentName VARCHAR(
Few days ago, I was creating an ASP.NET Web API by generating Entity Framework scaffolding API controller. There were simply two tables in the database Product and Title. In the edmx file, the auto-generated classes were as follows:
public p
Passing primary key values in the parent table to foreign key values in child table with parent insert and child insert being in separate stored procedures.
Parent is Lease table, the child is Rent table. I am getting null values for le
Hello Readers!
In my earlier blog post, I explained about the checkbox validation using Javascript. This blog post will explain you the same thing using HTML5. Let me give a brief overview of checkbox validation here too.
While filling an o
Duck game using pure CSS3
Hello all,
Below is an example of pure CSS3 game using CSS3 animation, pseudo class. This example show efficiency of CSS3.
There is no .gif image used. Find the attachment for complete code below.
*{margin:0px;padding:
SQL insert statement is used to insert the data in a table in database . Using this statement we can insert single or multiple data in a table .
We can insert the data by two ways :
1) By SQL insert into statement : we can insert data either by colum
Foreign Key is used to establish a link between two tables . It always define in reference of Primary key ( another table ) . It act as a Primary key in its own table and foreign key for another table .
Difference between Primary key and Foreign key
This wildcards is used when we want to match a string pattern . And this can be do with the help of wildcards only .
In SQL there are two types of wildcards :
% : Percentage sign which represent 0 , 1 or more characters .
_ : Underscore which repr
Hello all,
The below tutorial will help you in displaying SQL row data as a column wise with user specific column name.
here, I've a table with #Temp1 name that contains the following columns Id, ReferenceId and Total.
SQL Code:--
CREATE TABLE #T
