Click here to Skip to main content
15,867,937 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 Aleksandr Ulanov
Learn how to use Redis and its geospatial indexes and commands for complex geo calculations
by Rob Culhane
How to 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.

Latest Articles

by Nicolas DESCARTES
What are vector databases?
by Ștefan-Mihai MOGA
How to solve real-life problems using B-trees
by Mark Pelf
Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment
by Mark Pelf
Tutorial on EF7 – Code First approach using Command Line (CLI)

All Articles

Sort by Score

Database Development 

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