Science topics: Computer ScienceSQL Programming
SQL Programming - Science topic
Explore the latest questions and answers in SQL Programming, and find SQL Programming experts.
Questions related to SQL Programming
Orchid related data in SQLite DB format attached in Asset folder with Android Application and application work only upto Android 8 (API level 26) but the inbuilt Database is not visible in Android 9 (API level 28) . What's the reason behind this?
Application built in Eclipse Juno Framework
I'm trying to delete a table and create them again in PostgreSQL, but, in more than 24 hours, the command DROP TABLE or TRUNCATE don't finished.
This table have a lot of tuples (millions), but, this command don't have to be fast?
What can I do to delete this table completely?
I have a column number 1,2,3,4,.............................................600. I am using here
SELECT 1,2,3,4,5 FROM tbl;
here i get only the column no with data consisting of 1, 2, 3, 4,5 ....
My question is how I get from 1 to 16.
After i need the data from 18 to 59
i want to group...
please tell me what syntax will i use?
I need to retrieve fields from a relational database that has more than twenty tables. I am having difficulty in extracting required 63 fields from the database. Someone advice please.
I use the following query for retrieving data from SQLite database in android.But I do'nt know how to retrieve data randomly?
I'm try to create and application with CodeIngiter, I use a MySQL DB for it, but I need have access to others Databases make it with SQL Server, recompile information from them and integrate to my MySQL DB on my application.
I have set of multiple-choice questions that want to ask them from users for getting his/her performance in answering the questions.
I want to do research on the above mentioned topic. I need ur suggestions
Inmon, Kimball, Hefesto or another? I'm currently building a data warehouse to pave the way for data mining, the goal of this work is to improve the process of decision-making in education policy. This requires knowing what the best architecture is.
I want to find a special string in a given set of strings. For example I have an address, street A 59 (or just A 59, street has not been entered in the database), in contrast, there exists a park with the name of A or other places. I want to search the keyword A and find all the streets with the name A, not other places, e.g. park. and there are thousands of rows in the database.
I use this command for my situation: UPDATE my-column SET my-column = 2
WHERE my-column LIKE '%A%'
But I don't know how to search for string A plus a number in front of it (I mean search A 12, A 13,... simultaneously (A+Number). Could you please help me?
Thank you so much in advance.
I want to read all transactions such as insert, update, delete for a specific table and database in SQL Server 2005 or SQL Server 2008
DECLARE @RowCount INT
SET @RowCount = (SELECT COUNT(ID) FROM Table1)
DECLARE @I INT
SET @I = 1
WHILE (@I <= @RowCount)
DECLARE @word VARCHAR(50), @len int
SELECT @word = word, @len = LEN(@word) FROM Table1 WHERE ID = @I
INSERT INTO Table2 (base, part) VALUES (@word, SUBSTRING(@word,1,@len))
SET @I = @I + 1
Transactions control the queries that perform complete or rollback.
I need a function that doesn't have limitation of 32 kb buffer size like "encode to base64"
an example in attachment.