Click here to Skip to main content
14,970,948 members
Everything / Database Development

Database Development

database

Great Reads

by Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
by Rob Culhane
Dynamically add access database columns at runtime using vb.net
by Paul D. Sheriff
As more and more users interact with web applications on their mobile devices, it is becoming increasingly important for software developers to allow them to work offline; PouchDB can help.
by Nikola M. Živković
Introduction to NoSQL and Polyglot Persistence

Latest Articles

by David Wincelberg
Strings that differ by typos can be matched.
by DaveNoderer
In this article, we explore how to set up one component, an SQL pool.
by Evgeniy Gribkov
The examples of SQL Server database documentation using both the extended properties and a third-party utility.
by Private Dobbs
How to initialise a database and then automatically keep it up to date with version releases

All Articles

Sort by Score

Database Development 

Please Sign up or sign in to vote.
19 Feb 2015
DrABELL
Technique to extend capability of standard SQL by adding the Aggregate Product Function
Please Sign up or sign in to vote.
4 Apr 2021
Rijwan Ansari
Learn about SQL Server Database Project (Template) available in VS
Please Sign up or sign in to vote.
19 Feb 2010
Md. Marufuzzaman
This is good... You can also consider this link.[^]
Please Sign up or sign in to vote.
4 Feb 2012
RasikaLB
2 alternatives  
You can find queries to find a specific string from MSSQL Server
Please Sign up or sign in to vote.
19 Jun 2015
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.
Please Sign up or sign in to vote.
21 May 2021
rev78
Simply bypass the 255 columns in MFC CRecordset
Please Sign up or sign in to vote.
31 Jan 2017
#realJSOP
Using common table expressions to build data from thin air.
Please Sign up or sign in to vote.
30 Jul 2014
DiponRoy
How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first
Please Sign up or sign in to vote.
18 Dec 2016
NightWizzard
Convert amounts to their spoken equivalents
Please Sign up or sign in to vote.
22 Sep 2017
#realJSOP
It doesn't always happen the way you expect.
Please Sign up or sign in to vote.
26 Aug 2010
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
Please Sign up or sign in to vote.
19 Feb 2015
DrABELL
Generate large data series by using Cartesian Product and small data table
Please Sign up or sign in to vote.
24 Dec 2010
Shahriar Iqbal Chowdhury/Galib
Reset PLSQL sequence value
Please Sign up or sign in to vote.
17 Feb 2011
dontumindit
While dealing with databases, sometimes there is a need to get a list of tables in the application
Please Sign up or sign in to vote.
25 Sep 2011
ludovicianul
The easiest and elegant way to read images from the database and display them in the UI.
Please Sign up or sign in to vote.
31 May 2012
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.
Please Sign up or sign in to vote.
27 Nov 2012
Aadhar Joshi
Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.
Please Sign up or sign in to vote.
10 Dec 2013
Bruce Yang CL
A way to query the data from Internet
Please Sign up or sign in to vote.
5 Aug 2014
Anis Derbel
The easy way to connect to Mysql using Wamp server on WPF
Please Sign up or sign in to vote.
4 Nov 2014
binit.ku.singh
Connect MongoDB from any working directory on ubuntu
Please Sign up or sign in to vote.
5 Dec 2014
Md.Sajidur rahman
This structure describes how to process data from multiple branches and store to analysis.
Please Sign up or sign in to vote.
22 Feb 2016
Sifiso W Ndlovu
This tip illustrates a workaround to SQL Server pivoting on variable character data types.
Please Sign up or sign in to vote.
4 Mar 2014
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.
Please Sign up or sign in to vote.
26 Apr 2010
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...
Please Sign up or sign in to vote.
7 Apr 2010
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...
Please Sign up or sign in to vote.
28 Apr 2011
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
Please Sign up or sign in to vote.
22 May 2011
fgoldenstein
Cannot open Microsoft Access database -> Exception message "unknown"
Please Sign up or sign in to vote.
16 Aug 2011
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 ...
Please Sign up or sign in to vote.
21 Aug 2011
Mike Hankey
Updating an SQLite database to a new version and copying the contents of the old one into the updated database.
Please Sign up or sign in to vote.
7 Jan 2012
Carlos Luis Rojas Aragonés
How to backup multiple databases using Perl
Please Sign up or sign in to vote.
14 Jan 2012
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.
Please Sign up or sign in to vote.
25 Jul 2012
cesar_boucas
"Application performance depends on the number of database round-trips to retrieve data. The less round-trips, the better the performance."
Please Sign up or sign in to vote.
13 Jun 2013
Deepali Dhingra
This tip explains how to create a to do or Shopping List app with listview, sqlite, dialog and customadapter.
Please Sign up or sign in to vote.
12 Sep 2013
dmgcodevil
Framework for performing aggregation and plain MongoDB queries in myBatis style
Please Sign up or sign in to vote.
29 May 2014
NIKS SHINE
Uploading database of higher version of DBMS to the lower version one.
Please Sign up or sign in to vote.
7 Jan 2017
SrikantSahu
This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.
Please Sign up or sign in to vote.
12 Sep 2018
Clifford Nelson
Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access
Please Sign up or sign in to vote.
5 Apr 2021
Rijwan Ansari
How to compare two databases using SQL Server Database Project (Template) available in VS.
Please Sign up or sign in to vote.
8 Feb 2010
Huisheng Chen
DUMP TRANSACTION FooDB WITH NO_LOGBACKUP LOG FooDB WITH NO_LOGDBCC SHRINKDATABASE(FooDB)EXEC sp_dboption 'FooDB', 'autoshrink', 'TRUE'
Please Sign up or sign in to vote.
26 Aug 2010
Pranay Rana
Number of different ways to get total number of rows from tables
Please Sign up or sign in to vote.
2 Oct 2010
kasiarun
How to connect to Analysis Services (SSAS) from a different domain user
Please Sign up or sign in to vote.
5 Jan 2011
thatraja
How to Shrink SQL Server database files?
Please Sign up or sign in to vote.
13 Jan 2012
Robby Tendean
How to do SQL atomic operations on UPDATE and DELETE syntax.
Please Sign up or sign in to vote.
27 Jan 2012
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.
Please Sign up or sign in to vote.
7 Feb 2012
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'--
Please Sign up or sign in to vote.
28 Jan 2013
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.
Please Sign up or sign in to vote.
27 Aug 2013
hmdmgd3
SQL code allows you to find objects using multiple keywords in your DB
Please Sign up or sign in to vote.
6 Jul 2015
Mike Trank
Simple Daily SQL Server Database Backup Batch File
Please Sign up or sign in to vote.
11 Jul 2015
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.
Please Sign up or sign in to vote.
11 Nov 2015
Masteramuk
Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB
Please Sign up or sign in to vote.
14 Jun 2020
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.
Please Sign up or sign in to vote.
19 Dec 2013
Shweta Lodha
Automatic numbering for the primary key column
Please Sign up or sign in to vote.
1 Oct 2016
Suvendu Shekhar Giri
Enhancement on dropping an object with check for existence in SQL Server 2016
Please Sign up or sign in to vote.
20 May 2014
Ed Nutting
How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"
Please Sign up or sign in to vote.
23 Aug 2011
Armando de la Torre
How to load an image from the filesystem and save it into a Database
Please Sign up or sign in to vote.
6 Dec 2015
Tamer J. Mehyar
A simple way to keep track of DB objects versions (DDL updates) in SQL Server
Please Sign up or sign in to vote.
16 Aug 2011
thatraja
4 alternatives  
The below query can be used to get the record count of all tables in the current database.
Please Sign up or sign in to vote.
21 Jan 2011
Mahendra Vishwakarma
Tips for SQL-Indexes
Please Sign up or sign in to vote.
25 Aug 2016
Gene R. Browning
Generate random dates (and times if you like) for your test data environment.
Please Sign up or sign in to vote.
30 Oct 2015
JoaoSousa23
SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering
Please Sign up or sign in to vote.
6 Dec 2014
saddam abu ghaida
1 alternative  
This article describes how to convert any Data Table to List of Objects at runtime using Reflection
Please Sign up or sign in to vote.
17 Jul 2017
Arif H Shigri
This tip will discuss the difference between ROW_NUMBER(), RANK() and DENSE_RANK().
Please Sign up or sign in to vote.
8 Dec 2014
PIEBALDconsult
This is an alternative for "C# Convert DataTable to List of Objects Dynamically"
Please Sign up or sign in to vote.
19 Jul 2012
Sudheer Reddy Battula
My perspective on “where to begin” to address this issue in a general sense for a Microsoft centric web application.
Please Sign up or sign in to vote.
29 Nov 2015
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
Please Sign up or sign in to vote.
15 Sep 2016
GhostHost
Compare two databases to detect which object has been modified from an old version of the same database.
Please Sign up or sign in to vote.
8 Oct 2014
Peter Leow
The OO way to writing your database operation code in PHP
Please Sign up or sign in to vote.
6 Apr 2021
Satya Karki
How to import or restore BACPAC file using SSMS
Please Sign up or sign in to vote.
26 Feb 2014
VIGNESH SUKUMAR
Quick view of Biztalk MessageBox Tables
Please Sign up or sign in to vote.
8 Mar 2016
markkang
This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database
Please Sign up or sign in to vote.
3 May 2016
Michael Haephrati
How to overcome an error message preventing you from saving a change in an SQL Server database
Please Sign up or sign in to vote.
17 Sep 2018
adriancs
A tool to backup & restore all MySQL databases in one click
Please Sign up or sign in to vote.
20 Oct 2016
Bryan Kowalchuk
The two most common database lookup table patterns are examined
Please Sign up or sign in to vote.
31 Jan 2017
#realJSOP
A scalar function to determine if a given DateTime is one of the ten US federal holidays, using SQL Server.
Please Sign up or sign in to vote.
6 May 2010
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...
Please Sign up or sign in to vote.
17 Sep 2016
Midi_Mick
A set of helper functions to cope with DBNull results from database queries
Please Sign up or sign in to vote.
2 Mar 2013
Syed Moula Ali
Replicate/Clone/Duplicate selected data in a Table using merge statment
Please Sign up or sign in to vote.
2 Sep 2014
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.
Please Sign up or sign in to vote.
7 Aug 2012
kennysun
encrypt all stored procedures in SQL server with powershell
Please Sign up or sign in to vote.
5 Jan 2011
thatraja
1 alternative  
How to Shrink SQL Server database log files?
Please Sign up or sign in to vote.
29 Mar 2016
VijayRana
CRUD operation in ASP.NET/C# with SQL Server for beginners
Please Sign up or sign in to vote.
27 Mar 2012
Marian Placko
This article shows a simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism
Please Sign up or sign in to vote.
12 Mar 2010
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...
Please Sign up or sign in to vote.
19 Apr 2011
Amit Kumar Tiwari
1 alternative  
Boost application speed and performance
Please Sign up or sign in to vote.
23 Jul 2010
deostroll
write classes meant for use in aspx code behind pages which talk with the database
Please Sign up or sign in to vote.
6 Jun 2015
Magyar András
Load videos automatically from selected Youtube channel with PHP and Youtube Data API v3
Please Sign up or sign in to vote.
4 Sep 2014
Emiliarge
A JavaFX/Swing NetBeans 8.0 Project with JFrame created by NetBeans's GUI Builder
Please Sign up or sign in to vote.
19 May 2019
DiponRoy
The aim of this helper class is to divide a large IEnumerable into multiple small list.
Please Sign up or sign in to vote.
28 May 2013
Bob Crowley
How to use a CASE statement in ORDER BY to avoid dynamic SQL
Please Sign up or sign in to vote.
20 Mar 2015
Sarathi Balakrishnan
Remove duplicate files with same file content, even with different file name using FILETABLE with simple CTE.
Please Sign up or sign in to vote.
29 Mar 2010
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...
Please Sign up or sign in to vote.
2 Apr 2016
SantanuDebnath
Write one SP for multiple Search
Please Sign up or sign in to vote.
2 May 2011
pankajupadhyay29
A nice way to get aggregated value without group by
Please Sign up or sign in to vote.
2 Jan 2016
RickZeeland
This console application converts an SQL Server database to PostgreSQL.
Please Sign up or sign in to vote.
30 Sep 2019
NightWizzard
Read and/or modify database objects like views, triggers, stored procedures and functions from .NET code.
Please Sign up or sign in to vote.
22 Feb 2010
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 >...
Please Sign up or sign in to vote.
27 Feb 2010
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 ...
Please Sign up or sign in to vote.
18 Dec 2016
NightWizzard
Convert amounts to their spoken equivalents
Please Sign up or sign in to vote.
22 Sep 2017
#realJSOP
It doesn't always happen the way you expect.
Please Sign up or sign in to vote.
26 Aug 2010
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
Please Sign up or sign in to vote.
19 Feb 2015
DrABELL
Generate large data series by using Cartesian Product and small data table
Please Sign up or sign in to vote.
24 Dec 2010
Shahriar Iqbal Chowdhury/Galib
Reset PLSQL sequence value
Please Sign up or sign in to vote.
17 Feb 2011
dontumindit
While dealing with databases, sometimes there is a need to get a list of tables in the application
Please Sign up or sign in to vote.
25 Sep 2011
ludovicianul
The easiest and elegant way to read images from the database and display them in the UI.
Please Sign up or sign in to vote.
31 May 2012
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.