SQL-CE

Great Reads

by Tamer Oz

PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.

LiteDispatch - Logistic solution on the cloud

by Enrique Albert

Azure WebSite and W8 Store App using SQL-CE, Azure SQL, Mobile Services, SignalR, EF, WebAPI and integration to Bing Maps

Retrieving and Storing Call History

by Bryan Sachdeva

This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.

Semaphon™ semantic phone number-to-text converter

by DrABELL

App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine

Latest Articles

Code Review Checklist

by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

Easy application to detect and recognize faces with EmugCV

by Emanuel Santos

In this article i will show how to create a basic application to detect and recognize faces using EmugCV.

Sql Server In Clause With Multiple Literal Values Performance Behaviour

by Neeraj Prasad Sharma

This article deals with performance difference with literal values

Convert RTF to Plain Text (Revised Again)

by NightWizzard

Handling for hex expressions and the trailing '}'

All Articles

top

SQL-CE

Simple Data Access in C#

11 Jan 2009

6opuc

Fast and easy to use data access class library.

C#3.0

C#2.0

.NET3.0

Auto Adjusting Date Ranges on Entry of a New Range using SQL

28 Sep 2009

acarpio1975

Given date ranged data, adjust existing ranges on entry of a new ranged data.

How to search for related query inside the Database using ASP.NET

12 Aug 2014

Afzaal Ahmad Zeeshan

This article explains how you can use ASP.NET (C#) and search for related queries in your Database.

Benchmarking the Performance of Embedded DB for .NET: SQL CE 4.0 vs SQLite

4 Jul 2011

Alexander Galkin

Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.

Mobile Birthday Reminder and Automatic SMS Sender

5 Jul 2010

Amit Kumar Tiwari

This code sends automatic SMS to birthday boys/girls :) from phone

Database Deadlocks for Dummies

2 Oct 2008

Andrew J Dixon

Explaining Database deadlocking to non-technical people

The Basics of The Palm Pre Linux

21 Sep 2009

Apriorit Inc, Oleksandr Dodatko

This article describes the process of initial configuration and basic work with Palm Web OS on the lower level than it's described in Palm SDK docs.

Simple Data Paging

23 Oct 2005

Barend Jnr

Simple Data Paging

Easy SQL-CE Access Utility in C#

9 Nov 2012

Bart-Jan Verhoeff

Access data in any SQL server compact edition datatable using only one line of code in C#

EasySqlCe: easy access to SQL CE in C#

23 Jan 2014

Bart-Jan Verhoeff

An easy way to access your SQL compact edition database in C#

HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express

18 Oct 2013

Brian C Hart

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!

Data Driven Unit Testing for a DotNetNuke Private Assembly Module

19 Jun 2007

Bruce Chapman DNN

Using data driven unit tests with SQL Server CE for DotNetNuke private module development.

Retrieving and Storing Call History

19 Dec 2007

Bryan Sachdeva

This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.

Visual Representation of SQL Joins

4 Feb 2009

C.L. Moffatt

This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.

T-SQL Coding Standard

1 Oct 2008

Casper Leon Nielsen

T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)

Easier Database Transactions - Extending the Using Statement to Perform Automatic Database Transactions

25 Oct 2004

Chad Z. Hower aka Kudzu

Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.

SQL Wizardry Part Three - Common Table Expressions (CTEs)

12 Jan 2014

Christian Graus

In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks

SQL Wizardry Part Four - passing lists of data to SQL Server

12 Jan 2014

Christian Graus

In which we talk of ways to pass an arbitrary list of values to SQL Server

SQL Wizardry Part Five - when not to use DISTINCT

6 Jan 2014

Christian Graus

Just a quick explanation of why it's not always a good idea to use DISTINCT

SQL Wizardry Part Six - Windowing Functions

13 Jan 2014

Christian Graus

A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012

SQL Wizardry Part Seven - PIVOT and arbitrary lists of data

16 Jan 2014

Christian Graus

Discussion on pivot and other ways to turn columns of data in to rows in SQL Server

SQL Wizardry Part Eight - Tally Tables

21 Jan 2014

Christian Graus

A description of the best way to create tally tables, and how to use them

Thinking in SQL - Generating Random Numbers

23 Jan 2014

Christian Graus

A discussion of ways to create random number sequences in SQL Server

Simple bit of Transact SQL to help locate text in a database

12 Dec 2007

codelion

Simple bit of Transact SQL to help locate text in a database using cursors

SQL Injection Attacks and Some Tips on How to Prevent Them

23 Jan 2005

Colin Angus Mackay

Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.

SQL Battleship 2008

15 Dec 2007

craigd

Single-player game using GEOMETRY datatype and spatial functions in SQL Server.

Accessing MS SQL Server CE v1.0/v2.0 without ADO

2 Mar 2003

CT CHANG

Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.

Code First with SQL CE

9 Nov 2013

Damijan Vodopivec

Sample Code First project with SQL CE 4.0 database

Semaphon™ semantic phone number-to-text converter

8 Oct 2015

DrABELL

App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine

HeMoSiBi™

16 Feb 2015

DrABELL

Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)

Implementing multi-level trees in MS SQL Server

14 Aug 2012

Duong Ba Hong Minh

A good way to setup and install a multi-tree level structure by using a MS SQL Server database.

Code Review Checklist

24 Feb 2017

Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

Easy application to detect and recognize faces with EmugCV

7 Sep 2016

Emanuel Santos

In this article i will show how to create a basic application to detect and recognize faces using EmugCV.

WCF by Example - Introduction

28 May 2013

Enrique Albert

Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate

WCF by Example - Chapter I - Baseline

19 Dec 2012

Enrique Albert

First draft version of the model, repository, and services.

WCF by Example - Chapter XVI - EF 5 & SQL CE - AzureWebSites Deployment

31 Jan 2013

Enrique Albert

EF Code First implementation of generic repository and unit of work. With deployment to Azure web sites using SQL Compact.

LiteDispatch - Logistic solution on the cloud

24 Jun 2013

Enrique Albert

Azure WebSite and W8 Store App using SQL-CE, Azure SQL, Mobile Services, SignalR, EF, WebAPI and integration to Bing Maps

Multiple filters on a WHERE clause

2 May 2005

fhunth

How to write multiple filters on a WHERE clause on a sql sentence

Very Lightweight Data Access Layer in C# and .NET 2.0

4 Apr 2007

Fitim Skenderi

Very Lightweight Data Access Layer in C# and .NET 2.0

Convert a Text File to a PDF File

14 Dec 2005

Florence FZ Li

This article shows how to convert a text file to PDF.

Sending complex emails in .NET 1.1

16 Mar 2006

FlorentinB

This article describes complex issues about sending emails in .NET 1.1 (such as using a SMTP server that requires authentication).

SQL Tuning Tutorial - Understanding a Database Execution Plan (1)

18 Apr 2005

Gael Fraiteur

If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.

A SQL Management Console for MSSQL 2000 & 2005, MySQL 5.0,...

20 Apr 2008

gan.gary

An article on a SQL IDE for different type of RDBMS databases

Data Synchronization in SQL Express

15 Oct 2010

Ganesan Krishnan

Data Synchronization in SQL Express

Install and Configure SQL Server for SQLCE replication

13 Sep 2003

Garth Tissington

After pulling my hair out for several days I finally figured out how to install and configure SQLCE with SQL Server for replication to a Windows CE device. I hope this saves you some pain

Creating Pocket PC Application Setup Packages Using the CAB Wizard - 2

14 Jul 2004

Girish Nurani Sankaranarayanan

An article describing the implementing of Custom actions in Pocket PC application Setup packages.

Merge Replication between SQL 2000 or SQL 2005 using SQLCE

20 Aug 2007

ihsanps

Merge Replication using SQL 2000 or 2005 using Compact Framework

Packaging and Deploying Pocket PC Applications and SQL Server CE 2.0

12 Nov 2005

JacobEgholm

This article is about making a package containing a Pocket PC application and a SQL Server CE. The package will be of type MSI. When you click it, it will first install SQL Server CE 2.0 and then it will install the Pocket PC application.

Create a Modified On Column in SQL Server

24 Dec 2007

james.wren

How to add a modified on column in SQL Server using triggers.

SQL Compact 3.5 Tidbits and Gotchas!

1 Aug 2008

Jammer

An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.

Audit for DB programming

25 Mar 2008

jangtimjang

Do you want to know what your DB programmers are doing?

Uncommon Common Table Expressions (CTEs)

25 Aug 2009

Jeremy Likness

Common table expressions (CTEs) are a powerful new construct for building advanced queries.

The LOGIC Behind Mad MAX()

11 Mar 2008

Joe Negron

The SQL MAX() function is a little tricky when trying to work with numeric data - Not quite the same in other languages.

White Stone Business Network: Bringing Businesses Closer to Their Customers

29 Apr 2013

JoewyCodes

White Stone Helps Businesses Give Their Customers Greater Value for their Money.

SQL Server to SQL Server Compact Edition Database Copy Utility

26 Jun 2008

johnnycantcode

Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases

Managing Blobs Using the ATL OLE DB Consumer Templates on the Pocket PC

30 Jun 2004

João Paulo Figueira

Managing large data types on SQL CE databases and the ATL OLE DB Consumer Templates.

ATL OLE DB Consumer Template Schemas

6 Feb 2005

João Paulo Figueira

Exploring SQL CE 2.0 schema information with the ATL OLE DB Consumer Templates.

Abstracting the ORM Framework

8 Jul 2013

JP van Mackelenbergh

Abstracting the ORM Framework via Repository/Unit Of Work patterns

How to Call SSIS Package from the Stored Procedure

21 Jun 2008

JustChiragPatel

No need to create web service for SSIS package call

How to Config Linked Servers in a Minute

29 Apr 2009

Kamran Hazari

How to create Linked servers in a minute in an easy way

Simplify Database Operations with Generic Fluent NHibernate

30 May 2012

Kieran Maltz, Cayen Systems

This article describes database communication using a generic Fluent NHibernate implementation.

Minimalistic Driver-less Native MySql Client

11 May 2009

Ladislav Nevery

Native MySql Client not requiring any special driver or library

LINQ to SQL

11 Dec 2007

Le Sourcier

How to use LINQ to SQL

SSIS Basic OLEDB / ODBC destination script

30 May 2008

madgardener

Simple destination script to use do updates with a sub query.

Table Data Sharing Across Stored Procedures

8 Aug 2012

ManojKumar19

This tip demonstrates how table data can be shared in two stored procedures.

LINQ Challenges and SQL Server Compact Edition

25 Mar 2008

Matt Sollars

Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.

LINQ and Deploying SQL Server CE 3.5

28 May 2009

Matt Sollars

How to deploy SQL Server CE 3.5 with an application that uses LINQ for data access.

How To Store Any File into SQL Database

22 May 2009

Md. Marufuzzaman

An easy technique to store any file into SQL database

How to Integrate an OLE Object with SQL Server

15 Jun 2009

Md. Marufuzzaman

This article will demonstrate how we can integrate T-SQL with an external application.

Get SQL Table Information

19 Jul 2009

Md. Marufuzzaman

Get SQL Table Information

How Many Records Are There in your Database?

20 Jul 2009

Md. Marufuzzaman

How many records are there in your database?

Procedure to Shrink the Database Transaction Log

25 Jul 2009

Md. Marufuzzaman

This article will demonstrate the procedure to shrink the database transaction log.

Get List of Extended storedProcedures that are Allowed to you for Common Use

26 Jul 2009

Md. Marufuzzaman

An easy way to get a list of extended storedProcedure allowed to you for common use

How Do I Protect My Stored Procedure Code

29 Jul 2009

Md. Marufuzzaman

This article will demonstrate the best practice to protect SQL server code object.

Overview of SQL Server Stored Procedure

13 Jul 2010

Md. Marufuzzaman

Overview of SQL server stored procedure

Overview of SQL Server database Triggers

7 Aug 2009

Md. Marufuzzaman

Overview of SQL Server database Triggers

An Easy But Effective Way to Split a String using Transact-SQL

9 Aug 2009

Md. Marufuzzaman

This article will demonstrate how to split a string using Transact-SQL.

An Easy Way to Get a File Name or a File Extension from a User Defined File Path using Transact-SQL

9 Aug 2009

Md. Marufuzzaman

This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.

Overview of SQL Server 2005/2008 Table Indexing (Part-1)

25 Aug 2009

Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

A Simple Use of SQL CASE Expression

19 Aug 2009

Md. Marufuzzaman

This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.

Global Variables in SQL Server

19 Aug 2009

Md. Marufuzzaman

A list of Global variables in SQL Server and their uses in Transact-SQL

End-to-End Real World BlackBerry Application, Part 6

16 Apr 2009

MiamiCoder

How to create a real-world BlackBerry application.

How to Validate ASP.NET and MVC Web Forms Using Business Rules Engine

14 Jul 2014

Misha1964

Learn how to validate complex web forms using business rules engine

Passing an Array as Parameter to SQL Server Procedure

13 May 2009

Mohammad Al Hoss

Passing an array as parameter to SQL server Procedure

Windows Mobile App Development Part 5: Intro to using SQL Server CE

30 Oct 2009

mstruys, dougturn

Learn to access data through DataSets and SQLCeResultSets in your Mobile apps.

LinqToSQL: Query Multiple Databases in One LINQ Expression and More...

1 Feb 2008

Muigai Mwaura

Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database

Web enabling data on a SQL Anywhere Server using a native web service

6 Jan 2008

mysorian

An HTML Native web Service on SQL Anywhere Database Server

Sql Server In Clause With Multiple Literal Values Performance Behaviour

26 Aug 2016

Neeraj Prasad Sharma

This article deals with performance difference with literal values

Parse DataSet via Reflection

1 Sep 2009

NeoPunk

This article shows how to bind relational data model with object design model

Windows Forms Setup Saver

26 Apr 2005

Nick Kopp

Presents a generic method of saving and reloading the status of a Form's controls using XML.

Document SQL Server 2000/2005 Database

17 Oct 2009

Nitinpatel

T-SQL script to generate the document of SQL 2000/2005 database

URL Decoding in pure T-SQL

25 Jan 2007

orinoco77

How to decode a URLEncoded URL with T-SQL

RegiRide, a complete Windows Phone application

25 Jun 2012

Patrick Kalkman

A complete WP7 application with SQL compact database, LINQ to SQL, MVVM Light and Dropbox integration

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5

19 Sep 2009

Paul Rony

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application

Improving the performance of queries using SQL Server: Part 2

4 May 2007

Pete O'Hanlon

These articles are on prioritizing and improving query performance in SQL Server.

DbProvider Profiler using WCF and DbProviderFactory Injection: Part II of IV

20 Sep 2011

Pieter Van Parys

Creating profiling information in our ProxyDbxxx classes

SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table

17 Jun 2007

pinaldave

SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table

SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download

29 Jul 2007

pinaldave

I tried to accommodate all of them in the last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer to at your convenience.

SQL SERVER – Order of Columns in Update Statement Does not Matter

9 Mar 2010

pinaldave

SQL SERVER – Order of Columns in Update Statement does not matter

SQL Performance: Good Practices for Beginners

23 May 2007

Praveen Nair (NinethSense)

This article gives simple practical guidelines which will help a developer to design good performance, high quality SQL databases.

A SQLProcedure For MSSQL 2005 Of CustomPaging With RowNum And CustomPaging Without RowNum Both For MSSQL 2000 And MSSQL 2005

29 May 2009

qubing

WITH Clause AND EXEC sp_executesql Clause Used In MSSQL 2005

SQL Champ - A Quiz to Prove Your SQL Knowlege

31 Mar 2008

r.stropek

software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server.

DataBinding in WPF Browser Application using SQL Server Compact

22 Aug 2011

RameshSengamalai

DataBinding in WPF Browser Application using SQL Server Compact

SQL Server CE Query Tool

9 Sep 2011

ray_mayukh

User friendly query designer and data manipulation tool for SQL Server CE

Format Excel Sheet from DTS when Excel is Not Installed on SQL Server

18 Dec 2008

s_arun_kumar

Format Excel Sheet from DTS when Excel is not installed on SQL Server

Introductory Mobile Tracker Application for SmartPhones

5 Feb 2009

Santosh Ingawale

Merge Replication between SQL Server 2000 and SQL Server CE

24 Apr 2006

sebagomez

An article on how to configure a SQL Server 2000 and SQL CE on different PPC that syncronize their data with the SQL Server 2000

SQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)

17 Mar 2008

Shabdar Ghata

A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures

SOA Interview Questions: Part 1

19 Sep 2013

Shivprasad koirala

Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).

Caching Interview Questions: Part 1

21 Aug 2008

Shivprasad koirala

Some caching interview questions: Part 1.

Caching Interview Questions: Part 2

4 Mar 2014

Shivprasad koirala

Caching Interview Questions Part 2

ADO.NET Interview Questions: Part 1

20 Mar 2012

Shivprasad koirala

Ado Dot Net Interview Question Part 1

ASP.NET Interview Questions: Part 1

28 Aug 2008

Shivprasad koirala

ASP.NET interview questions: Part 1.

Asp.Net Interview Question Part 3

18 Oct 2008

Shivprasad koirala

Asp.Net Interview Question Part 3

4 steps to use readymade DAL component (Data application blocks)

24 Mar 2009

Shivprasad koirala

4 steps to use readymade DAL component (Data application blocks)

Implementing Audit Trail using Trigger

27 Apr 2009

Shivprasad koirala

Implementing Audit trail using trigger

4 steps to create free SSL certificate for development

4 May 2009

Shivprasad koirala

4 steps to create free SSL certificate for development

Optimizing LINQ Queries using DataLoadOptions

5 Jul 2009

Shivprasad koirala

Optimizing LINQ Queries using DataLoadOptions

How To Handle Concurrency in LINQ to SQL?

20 Jul 2009

Shivprasad koirala

How to handle concurrency in LINQ to SQL?

LINQ FAQ: Part 3

28 Jul 2009

Shivprasad koirala

Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.

Azure FAQ Part 1

4 Mar 2014

Shivprasad koirala

Azure FAQ Part 1

6 Steps to Enable Transactions in WCF

26 Nov 2013

Shivprasad koirala

6 steps to enable transactions in WCF

.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code

17 Aug 2010

Shivprasad koirala

.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code

7 Simple Steps to Run Your First Azure Blob Program

26 Feb 2014

Shivprasad koirala

7 simple steps to run your first Azure Blob Program

Six important .NET concepts: Stack, heap, value types, reference types, boxing, and unboxing

14 May 2012

Shivprasad koirala

An introduction to stack, heap, value types, reference types, boxing, and unboxing.

6 Steps to Implement DUAL Security on WCF using User name + SSL

20 May 2010

Shivprasad koirala

6 steps to implement DUAL security on WCF using User name + SSL

ASP.NET authentication and authorization

15 Aug 2010

Shivprasad koirala

ASP.NET authentication and authorization

VS 2010 Deployment (Package, One click deploy and Web.config transformation)

23 Aug 2010

Shivprasad koirala

VS 2010 Deployment (Package, One click deploy and Web.config transformation)

.NET 4.0 MEF FAQ (Socket, Plug and extension)

8 Sep 2010

Shivprasad koirala

.NET 4.0 MEF FAQ (Socket, Plug and extension)

Workaround: When a user clicks "Select All", the report should pass a blank value instead of parsing everything in the MultiSelect DropDown parameter

12 Feb 2008

Shobhit Dixit

If you have a long list of drop down items and you want to pass in one value, you can use this method

Store and forward GPS data for Smart Phones

28 Jul 2009

Slava Khristich

How to deliver GPS data asynchronously to the server over the internet without queues.

LINQ Code generator

31 Dec 2007

Sree Nivas

This generates Basic linq codes just by giving necessary inputs

Array Parameter Handling in a Stored Procedure

12 Jun 2008

Srinath Gopinath

How to handle an array parameter in a Stored Procedure [SQL Server].

How to Save and Update Data in Windows Mobile using the Emulator and Retrieve them Back

6 Jan 2009

sun1programmer

This article shows you how you can get your saved data once you closed the Windows mobile emulator.

Password Safe Reader for Windows Mobile

20 Mar 2010

Svante Seleborg, Alphons van der Heijden, Dave Shaw, katakana2

A Windows Mobile C# reader for the popular Password Safe archive files.

SQL Server Compact (CE) Database Maintenance Helper

22 May 2013

Tadeusz Kaliszewski

A small .NET class library for maintaining SQL CE database schema written in C#.

PocketPcAgent

8 Sep 2009

Tamer Oz

Disaster Recovery Plan In MOSS 2007

10 May 2008

Tariq Younas

Article describes how to make backup and recovery plan of MOSS 2007.

SQL Server – Active Directory Interaction

17 Aug 2007

ThomasMiller

Descripe the SQL Server 2000/2005 interaction with Active Directory on Windows 2000 or 2003 server

Coding an N-Tier Application in C# Without Any Wizard: Part II

6 Jan 2013

Vimalsoft(Pty) Ltd

Coding an N-Tier application in C# without using Wizards.

Efficient data processing with ADO in C++: Method GetRows

6 Jul 2005

Vitaly Tomilov

Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.

Very fast test data generation using exponential INSERT

28 Aug 2009

weilidai2001

Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.

Layout: fixed | fluid