Click here to Skip to main content

Submit your article

Database Development

database

Great Reads

Model-driven REST or GraphQL API for CRUD and More

by Evoluteur

Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

Using Redis for Storing and Working with Geospatial Data

by Aleksandr Ulanov

Learn how to use Redis and its geospatial indexes and commands for complex geo calculations

Dynamically Add Access Database Columns at Runtime using VB.NET

by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Getting Started with PouchDB - Part 1

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

Understanding Vector Databases

by Nicolas DESCARTES

What are vector databases?

Introduction to B-trees: Concepts and Applications

by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

SqlServer & EF7: Using datetime vs datetime2 date type

by Mark Pelf

Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment

Entity Framework 7 – Code First – Using CLI

by Mark Pelf

Tutorial on EF7 – Code First approach using Command Line (CLI)

All Articles

Database Development

"Merging" list operations with database

31 Aug 2010 by helianthus87

Here's the scenario.After page loaded user is getting List of his for example Phones. He can modify, delete, add some records without databse interaction during this process. After this he can click "Save" button to populate all changes to database.My problem is:At the end of user's...

entity-framework

"Merging" list operations with database

1 Sep 2010 by Gordon Kushner

My technique is to pass in all the ids to the stored procedure. You can do this with XML.Using the XML data type, you can DELETE the ids in dbPhones that are NOT IN the ids for userPhones, UPDATE the matching records and INSERT the new ones in one procedure call.Here is a SQL Server 2005...

entity-framework

"Out of memory" error when trying to read an image from sql database?

19 May 2011 by programmer1234

In my windows form I've made a textbox which the user uses to enter the website address and then click a button to screen scrap that website into a browser control. They can also save that screen scraped website to an sql database. Now the screen scraped page is saved to database as an image and...

"Out of memory" error when trying to read an image from sql database?

19 May 2011 by fcronin

Found the following block here... Retrieve Image[^]public Stream DisplayImage(int theID){ SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString());string sql = "SELECT image FROM Table1 WHERE id =...

"Standard ACE DB" "Microsoft bas cryptograghic provider" in first line of file, how to open it?

2 Sep 2012 by umar.techBOY

can we break the encryption, all i found by google and experiments is:The first line of a file (78MB 8n size) (database of a free religious books software) contains these strings "Standard ACE DB" "M i c r o s o f t b a s e c r y p t o g r a g h i c p r o v i d e r" (reading in c#,...

"Unimplemented or unreasonable conversion" error when trying to save images into oracle BLOB having more than 4k size. Im using Oracle 11g with asp.net 4.0 .

19 May 2015 by Member 11445380

Please Help me Its way too urgent!!!and i need to store images itself not their pathI have the requirement to save image into Database.Description of my question is : I have a asp.net 4.0 web application that uploads a image and then my application converts that image into byte...

"Unimplemented or unreasonable conversion" error when trying to save images into oracle BLOB having more than 4k size. Im using Oracle 11g with asp.net 4.0 .

2 Jun 2015 by Member 11445380

Problem has been resolved by using Oracle Transaction!!!

'ddReceivedby' has a SelectedValue which is invalid because it does not exist in the list of items.

13 Feb 2015 by zaiby

public void LoadInventory(int ID) { btnSave.Text = "Update"; DataTable dt = new DataTable(); SilkSchoolProvider SqlProvider = new SilkSchoolProvider(); dt = SqlProvider.SpGetInventoryOutByID(ID); ddBranch.SelectedValue =...

'ddReceivedby' has a SelectedValue which is invalid because it does not exist in the list of items.

13 Feb 2015 by Abhinav S

Run the query select EmployeeID from table and then check if you get a result.The error suggests this column does not exist in the table.

'Microsoft.ACE.OLEDB.12.0' not registered on local machine ERROR

22 May 2010 by sporrow

private void ekle_Click(object sender, EventArgs e) { string kaynak = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=gunluk2.accdb"; ; OleDbConnection baglanti = new OleDbConnection(kaynak); baglanti.Open();//error is here string...

'Microsoft.ACE.OLEDB.12.0' not registered on local machine ERROR

23 May 2010 by Estys

The message is clear.Does this[^] help?Cheers

.NET Application Modeling Language

14 Jan 2014 by ASP.NET Community

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

.NET Dynamically Invoke Service / Web Service

19 Jul 2010 by psynergy

Is there an existing framework or example of calling a service / web service settings stored within a Database that can be dynamically invoked?I have looked into Microsoft Service Factory 2008, Service Invocation Framework and Web Service Dynamic Proxy but not found anything all that helpful.

web_development

.NET Dynamically Invoke Service / Web Service

19 Jul 2010 by #realJSOP

Your question makes little sense. If you are asking if you can get aweb serive's settings from a database in order to communicate with the web service, yes you can, but only if that database can be accessed without the use of the web service. Typically, a web service can only be accessed...

web_development

.Net Entityframework Performance Issues

21 Dec 2012 by m.bleimuth

Hi,since one week i am using the .net entityframework to access a sqlserver database, so far everything worked fine. But now i have some Performance issues, when i want to update a table with about 90 entities the linq and savechanges commands take a very Long time (about 3-5 seconds) to get...

.Net Entityframework Performance Issues

23 Dec 2012 by Usman Khan Mohammad

[See this...]

.Net EntityFramework SaveChanges Delete Rows

22 May 2013 by m.bleimuth

Hi Experts,i am developing an application that uses entityframework to store the data. I have some columns with not too many data. Therefore i load all tables at Startup and work on the Cache.When i call savechanges all updates and inserts are stored correctly in my database. My Problem is...

.Net EntityFramework SaveChanges Delete Rows

22 May 2013 by David Melcher

You have to call the "DeleteObject" method of the specific objectset.Documentation

10 Things to Make Your Desktop Database Apps Better

3 Feb 2011 by JasonShort

Here are 10 things to make your desktop database apps better

1NF,2NF,3NF.......inDBMS not GEtting

2 Mar 2011 by sagarssg

How to recognize 1NF, 2NF, 3NF in DBMS? :confused:

1NF,2NF,3NF.......inDBMS not GEtting

2 Mar 2011 by Henry Minute

This is a difficult thing to answer in the small space available in a forum like this, so your best bet is to search the internet for articles/blogs/tutorials and read as many of them as you can until it clicks.Here[^] is one of the clearer ones I have found.If you are interested in...

2 Tables are 2 hours to execute simple select statement in mysql database

15 May 2013 by Member 9671482

2 tables are taking hours of time even simple select statement.likeselect * from dbo.people limit 3if any one know the answer please reply.Thanks & RegardsLakshman

2 Tables are 2 hours to execute simple select statement in mysql database

15 May 2013 by ZurdoDev

It is likely one of the following:1. There is a ton of data2. The server is slow3. Indexing is not appropriate.

2 Tables are 2 hours to execute simple select statement in mysql database

21 May 2013 by Member 9671482

i got this problem becouse some quries are executing internally.in database on that tables. First we have to see those executing process.usingshow prosseslistthen kill the process using process id.killprocess processid

2 way syncing mssql local database and remote database on cloud server

25 May 2015 by Ag_Sharad

I am working on a project with central database at a cloud online, and 2 clients one on mobile and other on PC. Both will have data read, write and update option. I want to have both local databases on each platform to work in case of offline and also remote database updation facility....

3 types of users but have different column , separate or one table?

6 Aug 2015 by Sergey Alexandrovich Kryukov

It's always better to have one single table for all users, and a separate table for roles, and the user should have an attribute (column) referencing a role.—SA

29 Sep 2010 by prabut

we are using three tier architecture now .we have separate the database codes into DAL.covert tat arguments into BLL into Page.But we need to add another level Database related queries store in text file.Is It Possible to Apply?if Yes Means How?Pls.Reply Me.thx and regards by prabu.

15 Oct 2010 by Mohd Wasif

Make a class DBConnetion for ConnectionMake a Class DBacess for Defining all defination for different queries and stored procedures.Make Classes passing DBQuery for .Make classes for Business Logics

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

22 Nov 2021 by Michael Sydney Balloni

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

8000 Limit of varchar.

8 Sep 2010 by Hiren solanki

Hello, Folks,I have one Query,And the Length of the query Exeeds the limit of varchar(max) which is 8000and i am not able to put it into EXEC('') Statement,as EXEC Statement itself supports only length of 8000 max only.Is there any way to do it ?

8000 Limit of varchar.

9 Sep 2010 by Sandeep Mewara

Break the query!Use SP/Functions/Views...Well, actually if you have a query of length more than 8000, chances are it's not well formed. You need have a proper DB designed and then various ways to get data out of it like having Views in place.

8000 Limit of varchar.

9 Sep 2010 by Abhinav S

I really dont think having a query that is 8000 characters is a good idea.It is just too long.Think of the guy who has to maintain this query (or make changes to it later).

8000 Limit of varchar.

9 Sep 2010 by Chris Maunder

Can you convert some or all of it to a stored procedure?

8000 Limit of varchar.

9 Sep 2010 by Abhijit Jana

Try to break the query string and append in EXEC Statement. LikeEXEC (@SQLQuery1 + @SQLQuery2 + @SQLQueryry3)Ref: Read the thread http://www.sqlservercentral.com/Forums/Topic589708-9-1.aspx#bm589762[^]

8000 Limit of varchar.

9 Sep 2010 by Abhijit Jana

I am not agree with the statement that you have mentioned. "though i will break query but at the end when i will put it into EXEC('only supports 8000 chars only').I can execute the query which having chars more than 8000declare @cmd varchar(max)set @cmd = 'print /*' + replicate ('-',...

8000 Limit of varchar.

9 Sep 2010 by dan!sh

Always avoid dynamic queries. It should be the last resort. It will hamper the performance considerably. Also, 8000 lines is way too much. Break it into peices. Try and get rid of dynamic queris.

8000 Limit of varchar.

9 Sep 2010 by #realJSOP

Put the query into a stored proc, and pass the necessary parameters into that stored proc.

951015 - how to connect to access database via C#?

3 Jan 2017 by ilostmyid2

I create an access database file by using Microsoft Access 2007. I use Visual Studio 2010 to write a program which need a database. I want to use the file as the database. I think this is the simplest way to write a rapid program to hold some data and manage them. Am I right?Then, in the...

951015 - how to connect to access database via C#?

3 Jan 2017 by Wendelius

I wouldn't think happened because a user isn't defined. As far as I know 0x8000FFFF is a catastrophic failure so for some reason the connection cannot be established.I would check if the OleDb provider is correctly installed and can you connect to the database from the code using...

951015 - how to connect to access database via C#?

4 Jan 2017 by #realJSOP

I provided a class in my solution to this answer: How do I run access from a WS 2012 and IIS 8 with ASP.NET[^]

951015 - how to connect to access database via C#?

3 Jan 2017 by OriginalGriff

There are quite a few reasons why that may be a problem.Start with the obvious: is the file available to all users? It's quite possible that the Connection Wizard isn't using your user ID to access the file, so if the file or teh folder it's sitting in doesn't have the required access...

[C#] display data from a mysql database in a form

5 Jul 2016 by TatsuSheva

How could I do to display data using MySql and use it for deleting or editing ? But now I have to display data and give the choice of: 1- use it to edit or2- to delete.So how can I do it ? Thank you.What I have tried:I did already the form of inserting data on MySql.

[C#] display data from a mysql database in a form

5 Jul 2016 by Leo Chapiro

Take a look: Connect C# to MySQL

[C#] EXPORT DATABASE MYSQL TO EXCEL 2010

30 Jan 2013 by ox3nt

using MySql.Data.MySqlClient;using Excel = Microsoft.Office.Interop.Excel;using System.Runtime.InteropServices;using System.Reflection;private void MySqlConnected() { #region Connect to Mysql String conString = "Data...

[C#] EXPORT DATABASE MYSQL TO EXCEL 2010

30 Jan 2013 by Balamurugan1989

Try this process it will work,In design form add Savefiledialog from tool box and right click that,inside the savefiledialog write the below coding,private void saveFileDialog1_FileOk(object sender, CancelEventArgs e){ DataSet dds = new DataSet(); SqlConnection con = new...

[C#] How will I insert an image to MS Access Database?

28 Nov 2015 by Jeff Garcia Samson

Hi everyone, how will I insert an image to MS Access database after I converted the image into byte[]?I used this code to convert the image into byte[] public byte[] imageToByteArray(Image imageIn) { MemoryStream ms = new MemoryStream(); ...

[C#] How will I insert an image to MS Access Database?

28 Nov 2015 by ridoy

Like this one:var pic = File.ReadAllBytes(yourFileName);OleDbCommand cmd = new OleDbCommand();cmd.CommandType = CommandType.Text;cmd.CommandText = "insert into Table1 (id, picture) values (@p1, @p2)";cmd.Parameters.AddWithValue("@p1", TextBox1.Text);cmd.Parameters.AddWithValue("@p2",...

[C#] How will I insert an image to MS Access Database?

28 Nov 2015 by Krunal Rohit

public static void AddEmployee( string lastName, string firstName, string title, DateTime hireDate, int reportsTo, string photoFilePath, string connectionString){ byte[] photo = GetPhoto(photoFilePath); OleDbCommand command = new OleDbCommand( "INSERT...

[Help] system.data.sqlite.sqliteexception (0x80004005): SQL logic error or missing database near “)”: syntax error

25 Feb 2021 by Member 15073686

I was trying to execute this sqlite database in C# visual studio windows application but whenever I try to enter value in text boxes this error occur if anyone have idea please help I am using sqlite studio. What I have tried: using System;...

[Help] system.data.sqlite.sqliteexception (0x80004005): SQL logic error or missing database near “)”: syntax error

25 Feb 2021 by OriginalGriff

The basic error is that your list ends with a comma: insert into Login (UserName, PassWord,) But you main problems are a lot more serious. 1) Despite passing parameters to SQL, your command doesn't use them! Never concatenate strings to build a...

[Noob alert] How to include a db in to windows form app so that we don't need any other installation at client side

13 Aug 2014 by Jitendra Satpathy

I'm new to windows form development. So i have developed a windows form application for my dad.It uses a small portion of data base i have used sql server 2008 for designing the data base. Now i want to deploy the app so that it may run on my dad's pc without any need of installation of...

SQL-Server-2008R2

[Noob alert] How to include a db in to windows form app so that we don't need any other installation at client side

13 Aug 2014 by Sergey Alexandrovich Kryukov

Your dad needs to install the SQL server, period. Moreover, even though deployment of database service with the application is the acceptable practice, it all heavily depends on licensing models, actually available licenses and maybe business setting. Therefore, the choice #1 is still just...

SQL-Server-2008R2

[Not a question] C# Refresh Combo Box

11 Sep 2013 by Kaveen Abeywansa

I have a combo box with data bounded from a Data Base. I am having problems when adding new items to database and also editing and deleting items. When I do those actions, The combobox is not getting updated until the app restart. I am just a student and I need help for this. I bounded the data...

[Not a question] C# Refresh Combo Box

11 Sep 2013 by norbitrial

It can be a good solution if you put into your form a refresh button and with it you can make a query for your database and rebind the data to your combobox.

[Not a question] C# Refresh Combo Box

11 Sep 2013 by Jean A Brandelero

Just googled for 2 seconds and found this:foreach (Control ctl in this.Controls){ ctl.ResetBindings();}

[Not a question] C# Refresh Combo Box

14 Sep 2013 by Kaveen Abeywansa

Thanks for all who spent their time to help. Even I didn't get the answer, I found the way to do so. I will post it as a help to another beginner like me.SqlConnection con = new SqlConnection(@"PATH");con.Open();SqlCommand cmd = new SqlCommand("select Field from TableName",...

[Solved] Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack on grid view databind event

17 Nov 2015 by Am Gayathri

Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack on grid view databind event.what is the reason for this error? Am getting this error on databind event.Gridview1.DataBind(); //here am getting this error.it was working. What...

[Sql]-none data when query without nolock

18 May 2016 by khoi tran

Hi everyone,- When i use query: SELECT * FROM TABLE WHERE col > '20160505' It don't has any dataType of col: DatetimeI don't know why. Who can help me with this problem? Thank you so much everyoneWhat I have tried:- But when i use query : SELECT * FROM TABLE with(nolock) WHERE...

[Sql]-none data when query without nolock

18 May 2016 by Wendelius

If the results are different, the first thing that comes in mind is that the transaction is still ongoing or if you look after the transaction and still no data, a rollback has occurred.NOLOCK is evil. It will show you data that is in the middle of a transaction and in my opinion it should...

[VB.net/MS Access] Database not updating after removing row.

9 Mar 2011 by RadethDart

Alright, I am having the hardest time figuring this out. I have done research on fixing this for a couple days and I am stuck. It is time to ask for help.In my project I am trying to delete a row out of the database and I read how to do that from many different sources telling me to use Ole...

[VB.net/MS Access] Database not updating after removing row.

10 Mar 2011 by Dave Kreskowiak

I suggest reading the documentation on AcceptChanges and Update. Update writes the dirty records in the DataSet/DataTable back to the database. AcceptChanges tells the DataSet/DataTable that the changes that were made are now the current state of the records. The two operations are completely...

[Vb.net] export datatable to database

9 Nov 2016 by GhostHost

Visual Basic .NET programming for Beginners - Data Sets and Data Adapters[^]

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

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.

A better choice of database structure for hierarchical records

21 Apr 2014 by Sor Emi

In my Wpf VS application with SQLite, I want to use my old data sheet,whose entries are of something like an hierarchical structure below :Field name (F1 F2 F3 F4 F5 F6) Cell contents (x y z * * *) about 50,000 rows, string type The number of...

A better choice of database structure for hierarchical records

21 Apr 2014 by Manas Bhardwaj

I would suggest that you buy a good basic SQL book and go through it. It will help you to get most of the answers. And not only for this question, but for the future.Understanding of data modelization always helps.Coming back to you question. It's a small 6 columns table (datasheet). So,...

A blank space appears on the webpage

13 Apr 2018 by Member 13778035

This here is my form and i am using this form to take the input when a user clicks on it

A blank space appears on the webpage

13 Apr 2018 by W∴ Balboos, GHB

You should check your query spacing (for a start). You have select *from instead of select * from Using 'u' instead of 'you' and other such cell-phone-texting junk is a sure way to develop sloppy habits. It's OK for error in English - it is not your first language. I am not referring to...

A blank space appears on the webpage

13 Apr 2018 by Patrice T

$query5= "Select *from services where id = '$id'; "; Not a solution to your question, but another problem you have. Never build an SQL query by concatenating strings. Sooner or later, you will do it with user inputs, and this opens door to a vulnerability named "SQL injection", it is dangerous...

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

A Coder Interview With Vanessa Hurst

8 Aug 2012 by CodeProject, DBNess

Welcome to our continuing series of Code Project interviews in which we talk to developers about their backgrounds, projects, interests and pet peeves. In this installment we talk to Vanessa Hurst, founder of Developers for Good, co-founder of Girl Develop It!, and a consultant and advisor to startu

A Control To Browse And Select A Database Instance

11 Oct 2010 by Roger Wright

I've done a bit of searching but haven't found much that's relevant, so I'll ask here...In my app I want the user to select a SQL Server database on the network using a control similar to the browser provided by the SQL Server Management Studio. Is there a built-in control for this, or do I...

A Control To Browse And Select A Database Instance

11 Oct 2010 by Goutam Patra

Will this [^] help

A Database Initialiser for SQLite and NPoco

5 Jun 2021 by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

A design for entity framework?

21 Apr 2014 by Jeff Moeller

Could this design solution be solved by Entity Framework?An app named "car parts" v1.0 has one user and incorporates a relational database with strongly typed columns for each of the 10 car parts that applies to the user's vehicle data.The data is very searchable since it is in an...

entity-framework

A design for entity framework?

21 Apr 2014 by Jeff Moeller

Thanks you Sergey, it turns out that my question is about hybrid EAV patterns with SQL Server on which I'd appreciate any further input.

entity-framework

A First Look at NoSQL and MongoDB in Particular

16 Mar 2015 by Sander Rossel

Getting your feet wet in NoSQL with MongoDB!

A fuel products prices management system in .NET

8 Oct 2017 by David2509

hello i have to developpe a fuel products prices management system there are several prices with its formula that i have implemented and i have to calculate all this prices and store theme in database -price for domestic customers -prices for foreign customers -price for foreign regular...

entity-framework

A fuel products prices management system in .NET

8 Oct 2017 by F-ES Sitecore

1 There is rarely a "best" technology, but asp.net and mvc are certainly more than capable and a good option 2 It's up to you. These days people tend to use Entity Framework\LINQ as it's easier to do. Especially for simple operations like CRUD and basic queries so EF is probably a good option...

entity-framework

A good In-Memory Database that is embedded in your code.

10 Jan 2013 by Joezer BH

Heya fellow CoProjs, We need a good solution for an in-memory DB (not a hybrid solution, a pure in-memory one). We run a server farm on strenuous efforts of several weeks at a time, in which we use 100% CPU on all continuously!We are now looking into performance improve by moving the...

A good In-Memory Database that is embedded in your code.

10 Jan 2013 by Mehdi Gholam

Try the following site : http://nosql-database.org/[^]

A good In-Memory Database that is embedded in your code.

22 Jan 2013 by Joezer BH

Solved!After benchmarking around 8 of the top solutions in the market, We've come up with Oracle's TimesTen, and McObject's eXtreneDB as suiting for the job, just to get the impression of things: both answer for over 300,000 inserts per second!Prices are around $100K-$400K depending on...

A Hidden Feature sp_MSforeachtable–Run on Entire Tables of a Database - TIP# 51

6 Oct 2014 by Rajat-Indiandotnet

A Hidden Feature sp_MSforeachtable–Run on Entire Tables of a Database - TIP# 51

A More Useful Port of the Chinook Database to Postgresql

6 Apr 2015 by John Atten

A More Useful Port of the Chinook Database to Postgresql

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

10 Feb 2016 by Jesus Carroll

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

SQL-Server-2016

A problem with GROUP BY in SQL Server?

25 May 2011 by King Boy

Suppose I have a table (named MyIncome) with 3 columns, the first is Year (2008, 2008, 2009), the second is Month (1, 2, 1), the third is Income ($1000, $1500, $2000)Now I want to know how much the Income are for each year in the Year column. I used the following T-SQL statement:SELECT Year,...

A problem with GROUP BY in SQL Server?

25 May 2011 by arindamrudra

Can you have a look at the code given below:USE AdventureWorks2008R2;GOSELECT SalesOrderID, SUM(LineTotal) AS SubTotalFROM Sales.SalesOrderDetail AS sodGROUP BY SalesOrderIDORDER BY SalesOrderID;Link is: http://msdn.microsoft.com/en-us/library/ms177673.aspx[^]Examples using...

A Really Bizzare Case

15 Aug 2011 by loveangel888

The case is like this. I have to delete a record from the child table.But in the table schema there is a foreign key reference from the childtable to the parent table.Therefore in order to delete the record, i need to set the foreign keycell in the parent table null. But i found out...

A Really Bizzare Case

15 Aug 2011 by Peter_in_2780

Try thinking about a concrete example of what you are trying to do.Consider for the moment that the parent table represents whole bicycles, which *MUST* include front wheels, and the child table represents front wheels. What you are trying to do is steal the front wheel from a bicycle and...

A Really Bizzare Case

15 Aug 2011 by Wendelius

If you would be able to delete the child record what would be the expected result?Or example if you have a record in parenttable which is referencing childtable with id 1. Now you delete the childtable row, what would be the value on the remaining row in child_id?I suggest that you...

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

27 Mar 2012 by Marian Placko

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

A suitable hosting for a website with 3 databases

17 Sep 2014 by OriginalGriff

We can't answer that: most (if not all) of the paid services support multiple databases within the same server, but we have no idea of your other requirements.Find one that is local to you (or at least has technical support in your own timezone and language) that has the other features you...

A suitable hosting for a website with 3 databases

17 Sep 2014 by Sergey Alexandrovich Kryukov

Sorry, this is off-topic. Talk to the Web hosting providers when in doubt.—SA

A topic for papaer presentation in DBMS

4 Jan 2012 by Arjun Parameswaran

I need help in selecting a topic for paper presentation in DBMS. I dont mind even a project in it. But I am having no clue about what to be taken up. Please help asap.

A topic for papaer presentation in DBMS

4 Jan 2012 by Wendelius

Did I understand correctly that you would like ideas about a topic concerning DBMS for a presentation. If that was the question, I'd go for transaction management. Actually that's so huge topic that it would be wise to select an area to focus on. For example transaction handling at client...

A way to logically separate stored procedures in MySQL, aka equivalent for Oracle packages

3 Jun 2012 by krumia

MySQL stored procedures are great (thank you very much) for small projects, but when it gets bigger and bigger, the number of procedures get out of hand.I found a seven year old bug request here[^]. And reading the comments, I can be sure this feature is never going to be implemented.So,...

About boonex database

3 Sep 2013 by Member 10249310

Hi everyone,I'm a junior programmer, I want to get a database info for boonexSNS.Thinks.Thanks

About boonex database

3 Sep 2013 by ZurdoDev

This is the Quick Answers forum so please refer to http://www.boonex.com/trac/dolphin/wiki[^]If you have a more specific question please let us know.

About empty field in database

9 Dec 2012 by ITSRavik

Hi Team, I have a Table, which is contain number of database field are Empty. I just want to be know about that- 1- Is it make any impact on database performance. 2- It it occupied any Spaces in data base.Please guide me.ThanksRavik