Database

database

Great Reads

by ASP.NET Community

IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide

10 Things to Make Your Desktop Database Apps Better

by JasonShort

Here are 10 things to make your desktop database apps better

4db: A Dynamic File-based NoSQL Database for C++

by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

by SrikantSahu

This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

Latest Articles

.NET Application Modeling Language

by ASP.NET Community

IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide

10 Things to Make Your Desktop Database Apps Better

by JasonShort

Here are 10 things to make your desktop database apps better

4db: A Dynamic File-based NoSQL Database for C++

by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

by SrikantSahu

This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

All Articles

top

database

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

by SrikantSahu

This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

A Closer Look at Lookup Tables

by Bryan Kowalchuk

The two most common database lookup table patterns are examined

A simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism

by Marian Placko

This article shows a simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism

Aggregate Product function extends SQL

by DrABELL

Technique to extend capability of standard SQL by adding the Aggregate Product Function

ALTE Azure Table Storage Indexed ORM

by nickdenker

An ORM style layer which turns Azure Table Storage into a cheap and scalable indexed noSQL database - without the costs associated with Azure CosmosDB.

Always use Binding Variables in SQL queries

by Wild-Programmer

Boost application speed and performance

Always use Binding Variables in SQL queries

by reshi999

Thanks for that. In MS SQL Server, I use the following technique to avoid full compile:DECLARE @sql VARCHAR(100)DECLARE @pk INTSET @pk = 2SET @sql = 'SELECT id, pcname FROM pod WHERE id = ' + CAST(@pk AS VARCHAR)EXEC (@sql)-- or -- EXEC sp_sqlexec @SQL

Amount to Words

by NightWizzard

Convert amounts to their spoken equivalents

An Algorithm For Grouping Data on One or More Fields Using a DataReader In .NET

by jfernand

Introduction...

Android - To Do\Shopping List [Tip/Trick] - Part 2

by Deepali Dhingra

This tip explains how to create a to do or Shopping List app with listview, sqlite, dialog and customadapter.

Automatic Numbering for the Primary Key Column

by Shweta Lodha

Automatic numbering for the primary key column

Backup All MySQL Databases in C# WinForm with 1 Click

by adriancs

A tool to backup & restore all MySQL databases in one click

Build a Calendar Without Pre-Existing Tables

by #realJSOP

Using common table expressions to build data from thin air.

C# Convert DataTable to List of Objects Dynamically

by saddam abu ghaida

This article describes how to convert any Data Table to List of Objects at runtime using Reflection

Compare Two Databases, Find Differences and Update using Visual Studio

by Rijwan Ansari

How to compare two databases using SQL Server Database Project (Template) available in VS.

Connect MongoDB from Any Working Directory on ubuntu

by binit.ku.singh

Connect MongoDB from any working directory on ubuntu

Connect WPF with Wamp Server MySql

by Anis Derbel

The easy way to connect to Mysql using Wamp server on WPF

Convert DateTime string to DateTime variable

by Pranay Rana

Convert DateTime string to DateTime variable

Convert SQL Server Database to PostgreSQL

by RickZeeland

This console application converts an SQL Server database to PostgreSQL.

Coping with DBNull

by Midi_Mick

A set of helper functions to cope with DBNull results from database queries

Count Lines of code in a database

by Mycroft Holmes

Assuming that a carriage return represents a line of code, this will count the lines of code in a SQL 2008 database:SELECT ROUTINE_NAME,ROUTINE_TYPE,LEN(ROUTINE_DEFINITION )-len(REPLACE(ROUTINE_DEFINITION,CHAR(10),'')) LOCFROM INFORMATION_SCHEMA.ROUTINESCOMPUTE...

Create Insert SQL Statement from the Records in an Existing Table

by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

Create job to export Stored Procedure daily

by Aadhar Joshi

Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.

Creating a Windows Azure SQL Database

by Malak Zia Nasir

Cloud computing is the trend of nowadays; this article provides some basic steps to create and connect a Windows Azure SQL Database to a simple application.

Crystal Reports User Group Selections

by JasonDove

This is a great to allow users control over their reports and cutting down on the volume of reports needed to meet the business’s needs.The basis of this solution is to control which fields are grouped on within the report which will in turn change the summary operations and change the...

Crystal Reports: 3 New Uses For Sub Reports

by JasonDove

I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten reporting requirements can be met using a little forethought and...

Crystal Reports: 5 Tests for Top Performance

by JasonDove

It is complete, your masterpiece report. Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways.Then….Disaster!You try to run the report for a month against the live database and not...

Day 1 : Database Connectivity ASP.NET/C# with SQL Server (Create Operation)

by VijayRana

CRUD operation in ASP.NET/C# with SQL Server for beginners

Delete Similar Databases

by Manas Bhardwaj

I had these similar databases on my dev environment which I had to delete multiple times during development. As this process was becoming more and more mechnical, I wanted to have a script which would do this for me.

Detects Differences Between Databases

by GabrieleTronchin

Compare two databases to detect which object has been modified from an old version of the same database.

DROP IF EXISTS in SQL Server 2016

by Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

Dynamic ORDER BY with multiple criteria in T-SQL

by Bob Crowley

How to use a CASE statement in ORDER BY to avoid dynamic SQL

Easy Compare DB

by Eligio Morgado H.

Compare two SQL Server databases and show difference in tables and fields

Encrypt all Stored Procedures with PowerShell

by kennysun

encrypt all stored procedures in SQL server with powershell

Entity Framework Code First Migrations Alternative

by DiponRoy

How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first

Error Message: Saving Changes Is Not Permitted

by Michael Haephrati

How to overcome an error message preventing you from saving a change in an SQL Server database

Export & Import Data+Attach Database of Higher Version to Lower Version

by NIKS SHINE

Uploading database of higher version of DBMS to the lower version one.

Find Duplicate Files in FILETABLE

by Sarathi Balakrishnan

Remove duplicate files with same file content, even with different file name using FILETABLE with simple CTE.

Find Sp from database which is related to(using) table XXX

by Pranay Rana

Problem : - During project development I got the requirement that I have to modified the column name of the table which is used in the no of procedure i.e i have to found all procedure related to that table and modify it For the above problem following are the solution that i used First ...

Four Pitfalls of SQL Processing with NULL Values

by Tomas@PawSQL

How to cope with all scenarios regarding NULL value handling in your daily work

Framework for Performing Aggregation and Plain MongoDB Queries in myBatis Style

by dmgcodevil

Framework for performing aggregation and plain MongoDB queries in myBatis style

Full Service SQLite for WPF (Including File Handling)

by ergohack

System.Data.SQLite is great, but was missing some BLOB support. Switching to the native source project was easier than expected and provided significant functionality benefits.

Generating constructors at compile time

by PIEBALDconsult

This is an alternative for "C# Convert DataTable to List of Objects Dynamically"

GMapsTable: Usage

by AivanF

Read how to add a dynamic table on Google map for your webpage

How to backup multiple databases using Perl

by Carlos Luis Rojas Aragonés

How to backup multiple databases using Perl

How to connect to Analysis Services (SSAS) from a different domain user

by kasiarun

How to connect to Analysis Services (SSAS) from a different domain user

How to Create SQL Server Database Project With Visual Studio

by Rijwan Ansari

Learn about SQL Server Database Project (Template) available in VS

How to display images from the database in your JSP pages - the easy way

by ludovicianul

The easiest and elegant way to read images from the database and display them in the UI.

How to find a specific string from stored procedures, triggers and functions in database

by RasikaLB

You can find queries to find a specific string from MSSQL Server

How to find a specific string from stored procedures, triggers and functions in database

by jim lahey

Please see my alternative tip #2:Do the same thing with SMO[^]There's a Microsoft API for all this, it's been around for a while.

How to find a specific string from stored procedures, triggers and functions in database

by Member 2077086

Simply add your search phrase and run to find jobs, Stored Procedures, Keys, Tables, Views, Indexes, Defaults, and Functions.set nocount on declare @Keyword as varchar(200)set @Keyword = 'Search prase'--<---- enter keyword here--Search jobsselect name Job, enabled , description, ...

How to fix "LocalDB - Requested Login failed"

by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

How to get the details of Open Transaction in SQL Server

by tarun_j200

How to Insert HTML Table Data into SQL Server in a Single Batch by Using JQuery Ajax and Structured Parameter

by Amit Singh Baghel

Saving Details Table Data (An HTML Table) in Database by converting it into a jagged array and passing it to a table type parameter

How to Modify Views, Triggers and Procedures from Code

by NightWizzard

Read and/or modify database objects like views, triggers, stored procedures and functions from .NET code.

How to setup database versioning tool RoundhousE

by Rohan Kishor Garud

RoundhousE (RH) is a database migrations engine that uses plain old SQL Scripts to transition a database from one version to another.

How to Shrink SQL Server database files?

by thatraja

How to Shrink SQL Server database files?

How to Shrink SQL Server database log files?

by thatraja

How to Shrink SQL Server database log files?

by Huisheng Chen

DUMP TRANSACTION FooDB WITH NO_LOGBACKUP LOG FooDB WITH NO_LOGDBCC SHRINKDATABASE(FooDB)EXEC sp_dboption 'FooDB', 'autoshrink', 'TRUE'

How To Use Oracle's TRIM, LTRIM and RTRIM Functions

by Database Star

How to use these three functions and what the differences are between them

How-To Create a CLR Function with EffiProz Database

by arith silva

EffiProz(www.e...

HTML5 Tables Formatting: Alternate Rows, Color Gradients, Shadows

by DrABELL

HTML5/CSS3 advanced formatting of web Tables and ASP.NET GridView

Import or Restore BACPAC File using SQL Server Management Studio

by Satya Karki

How to import or restore BACPAC file using SSMS

Java & JDBC & SQLite: Read Data from User-selected db Table and Show in JTable

by Emiliarge

A JavaFX/Swing NetBeans 8.0 Project with JFrame created by NetBeans's GUI Builder

Known Limitation of MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4

by Masteramuk

Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB

Large Volume Data Synchronization Process Between Central Database (Remote) and Branch Database

by Md.Sajidur rahman

This structure describes how to process data from multiple branches and store to analysis.

List Batching/Paging With Entity Framework or Any IEnumerable in C#

by DiponRoy

The aim of this helper class is to divide a large IEnumerable into multiple small list.

List of Tables of Microsoft Access DataBase

by dontumindit

While dealing with databases, sometimes there is a need to get a list of tables in the application

Loading an Image and Saving it into a database

by Armando de la Torre

How to load an image from the filesystem and save it into a Database

Making It Easier to Replace Null with DBNull.Value

by raddevus

Function to help convert null to DBNull.Value for inserting in database

MessageBox Database Tables

by VIGNESH SUKUMAR

Quick view of Biztalk MessageBox Tables

Method to Change Source of a Form’s Subform Source to a Query or Table in Microsoft Access

by Clifford Nelson

Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

MFC CRecordset - How to Bypass the 255 Column Limit

by rev78

Simply bypass the 255 columns in MFC CRecordset

Microsoft SQL Server – Bulk Delete Prescription

by MinhajMohammed

This article is not going to give you a pinpoint solution for a specific delete challenge, but rather it is meant to give a broader picture of the problem domain and the various tools you can opt based on your situation.

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

Oracle Parameterized Queries for the .NET Developer

by Foothill

A Primer for Writing Parameterized Oracle Queries for the .NET SQL Server Developer

OracleDataReader FetchSize Property

by cesar_boucas

"Application performance depends on the number of database round-trips to retrieve data. The less round-trips, the better the performance."

Pay Attention to What "Script...To" Generates

by #realJSOP

It doesn't always happen the way you expect.

PHP's Database Operation- Go OO

by Peter Leow

The OO way to writing your database operation code in PHP

Pivoting on SQL Server Varchar Data Types

by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

Post on how to do Paging in Oracle

by Santopk

Oracle Paging

Problem with OLE Db Provider in Windows XP Media Center

by fgoldenstein

Cannot open Microsoft Access database -> Exception message "unknown"

Random Date/Time Test Data Generation

by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

Reading Duplicate Values from the Table

by Indrajeet Sutar

Hi, on many occasions we want to search some repeated values in one or more columns. It is quite simple to do this...select ColumnName, count(ColumnName) as NumberOfTimesfrom TableNameGroup By ColumnNamehaving (count(ColumnName) > 1)At the same time, there is also a requirement...

Record Count of Tables in SQL Server

by thatraja

The below query can be used to get the record count of all tables in the current database.

Record Count of Tables in SQL Server

by Md. Marufuzzaman

This is good... You can also consider this link.[^]

Record Count of Tables in SQL Server

by tarun_j200

Also use either this one:SELECT OBJECT_NAME(SYSINDEXES.id), SYSINDEXES.rowcntFROM SYSINDEXES INNER JOIN SYSOBJECTS ON SYSINDEXES.id = SYSOBJECTS.idWHERE SYSINDEXES.indid < 2 AND SYSOBJECTS.xtype = 'U'or this one:SELECT OBJECT_NAME(id),rowcnt FROM SYSINDEXES WHERE...

Record Count of Tables in SQL Server

by Pranay Rana

Number of different ways to get total number of rows from tables

Record Count of Tables in SQL Server

by Graham Cottle

Sometimes it is necessary to have the schema name included as well. I concatenate with the table name for my convenience, but it is not vital to do so.SELECT sys.sysindexes.rows, sys.schemas.name + '.' + sys.objects.nameFROM sys.objectsINNER JOIN sys.schemasON ...

Reset PLSQL sequence value

by Shahriar Iqbal Chowdhury/Galib

Reset PLSQL sequence value

Search in your DB-Objects With Multiple Keywords

by hmdmgd3

SQL code allows you to find objects using multiple keywords in your DB

Simple Daily SQL Server Database Backup Batch File

by Mike Trank

Simple Daily SQL Server Database Backup Batch File

Single SP for Multiple Search Scenario

by SantanuDebnath

Write one SP for multiple Search

Some internal SQL Sever Queries

by Gaurav Dudeja India

The following query uses the sys.objects catalog view to return all database objects that have been modified in the last 10 days.SELECT name AS object_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc ,create_date ,modify_dateFROM sys.objectsWHERE modify_date >...

SQL Atomic Operation on UPDATE and DELETE

by Robby Tendean

How to do SQL atomic operations on UPDATE and DELETE syntax.

SQL Executer to run SQL Queries

by dontumindit

Installing Oracle or SQL Server just to practice SQL Queries is not a good idea. They occupy a lot of space and also slow down the normal processing of the PC.

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

by JoaoSousa23

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

Streamlined [Data Model-less] Record Editing with a SQLite Data Object Window Base Class

by ergohack

This SQLite Data Object Window base class automates the data updates and the data bindings between the XAML presentation and the SQLite database allowing the minimum of code needed to present and edit SQLite database records.

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

by Arif H Shigri

This tip will discuss the difference between ROW_NUMBER(), RANK() and DENSE_RANK().

The Magic Of A Single Integer Number To Contain Huge Information

by sukeshchand

How to effectively store huge pieces of information by consuming less space

Tips for SQL-Indexes

by Mahendra Vishwakarma

Tips for SQL-Indexes

To Replicate/Clone/Duplicate, selected data in SQL Server 2012, 2008

by Syed Moula Ali

Replicate/Clone/Duplicate selected data in a Table using merge statment

Tracking SQL-Server DB Objects Versions

by Tamer J. Mehyar

A simple way to keep track of DB objects versions (DDL updates) in SQL Server

T-sql over clause to aggregating without groupby

by pankajupadhyay29

A nice way to get aggregated value without group by

Updating an SQLite database

by Mike Hankey

Updating an SQLite database to a new version and copying the contents of the old one into the updated database.

US Federal Holidays (SQL)

by #realJSOP

A scalar function to determine if a given DateTime is one of the ten US federal holidays, using SQL Server.

Use SQL to generate large data sequence

by DrABELL

Generate large data series by using Cartesian Product and small data table

Using Visual Studio to find a database connection string

by OriginalGriff

Visual Studio has a Server Explorer built in to handle database access - it can lalso generate database connection strings ready for saving in application config files.

Using XPath to Query the Internet

by Bruce Yang CL

A way to query the data from Internet

Why is my web application slow?

by Sudheer Reddy Battula

My perspective on “where to begin” to address this issue in a general sense for a Microsoft centric web application.

Writing DB Classes for the web

by deostroll

write classes meant for use in aspx code behind pages which talk with the database

Youtube video list with PHP

by Magyar András

Load videos automatically from selected Youtube channel with PHP and Youtube Data API v3