My application reads a html table and then a script (TableToCSV) converts it into a .csv format. After that I convert that .csv into a sqlite database. After th
We have a MVC application running with SQL Server database. We are using windows authentication, and when we want to give user access to our site we add them i
I am currently developing an IVR system, my question is more on a development side of basic architecture and opening/closing a database connection. As you can
all. Include details about your goal: I'm trying to mock repository in e2e test Describe expected and actual results: Request to server will not have access
I am trying to export a large Access .mdb database to an SQL Server database and have been running into a problem where Microsoft DTS does not recognise the dat
What I'm trying to acheive I'm trying to fetch users for a certain database. What I did so far I was able to find function to list the databases or create us
I want to perform some data analysis of my own on my Anki history. I found out that my history should be contained in ~/.local/share/Anki2/User 1/collection.ank
I'm trying to insert data in my db. this is the code im using SqlCommand cmd = new SqlCommand("dbo.UsersInsert", cnn); cmd.CommandType = CommandType.StoredPro
I've created a table with some NOT NULL columns using phpMyAdmin. CREATE TABLE `TEST` (`ID` INT PRIMARY KEY AUTO_INCREMENT, `Firstname` V
I'm looking for the best solution to implement messaging to multiple users within the system(Facebook-style). I'm came up with the following idea: where each
i would like to return all rows and fields from a table, where neither the tablename nor the fieldnames are known in advance. Something like: select * from [TA
I am trying to import an XML invoice to SQL database. After some research, I have managed to put it in SQL database but it has x rows whereas it should be a sin
I've looked all over the place and cant find a solution that helps my case. I hope someone can help? I have this and receive Warning: sqlite_query() expects pa
How to get hierarchy data(recursive tree) as a new column like below? (if there is last child then column child array is empty) rows: [{ 'id' : 1, 'paren
I got this error while migrating here is my models.py file: from django.db import models from django.conf import settings from decimal import Decimal # Create y
Generate the following two result sets: 1). Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each
I have downloaded Microsoft SQL Server on my Mac with the Docker image as described here, and also I have downloaded the database AdventureWorks2019 as an exam
I have one button retrieve I just want to get the database table "account" value by its row and col and display it in a textbox. I keep on getting errors on th
I am trying to use SQLite in VSCode. I have installed SQLite extension by Alexcvzz. after opening the database when I right-click on the table and select "Show
What is the difference between "=null" and "IS NULL"? How are they used differently?