Stack Overflow
Stack Overflow

Questions tagged [sqldb]

39 questions
0
votes
1 answer

How to reclaim disk space in a SQLDB service instance?

I have an instance of a SQLDB Free Plan that I managed to consume all 100 MiB of disk space. Attempts to insert any new data fail with SQLCODE=-289 SQLSTATE=57011, which basically indicates that there is no more disk space. I dropped all of the…
Jim Hurne
  • 7,187
  • 4
  • 44
  • 44
-1
votes
1 answer

Column value of one table should be column headings when query is executed

I have two tables: pet type Id TypeB 1 dog 2 cat 3 snake Then another owners Ownerid Pettype 001 1 002 2 003 3 004 0 I am trying to get the values those owners who have pets as in this…
Kalpana K Kalpana
  • 1
  • 1
-1
votes
1 answer

Best SQL DB Design for an overused table that causes Database locking

Problem: We have 3 TRANSACTION table with about 1.5 Million records each, and at the moment they don't have any relationship at all and are independent at each other. In our Web Portal, whenever we click on the "Transaction" Tab, our SQL query will…
Michael Co
  • 1
  • 1
  • 1
-2
votes
1 answer

How to import office 365 usage analytics data to SQL DB using azure data factory

I would like to import office 365 usage analytics dataset to our SQL DB using azure data factory pipelines on month on month basis. Because it only keeps for sometime and we want to keep historic data. I have tried to connect to…
Yashi
  • 1
  • 1
  • 3
-2
votes
1 answer

Stop inserting after reach the limit in PHP and SQL

I have table named books, this table will store the data of each book . each book has 5 pages only and each page has different details which belong to the same book. the name of the book stored in a column named "jalad" and the pages stored in a…
noor ail
  • 1
  • 3
-2
votes
2 answers

How to Converting string 'Tue, 07 Dec 2021 04:35:05 GMT' to smalldatetime (yyyy-mm-dd hh:mm:ss) in sql server

I have string 'Tue, 07 Dec 2021 04:35:05 GMT' and i need to convert to smalldatetime format like '2021-12-07 04:35:05'(yyyy-mm-dd hh:mm:ss) in sql server. please help. Thanks in advance.
Shankar
  • 29
  • 2
  • 6
-2
votes
1 answer

Create Login in Azure Sql db with EXTERNAL DATA SOURCE or any other way

USE statement is not supported in azure sql db. I want to create new login in master db from another database (for ex. Abc Database). Please let me know how i can achieve this. Error ScreenShot
property kpt
  • 1
  • 2
-2
votes
1 answer

Failed to connect to SQL Database Premium Plan on Bluemix (Error code SQL1776N)

I develop an application using "Ruby on Rails runtime" and "SQL Database Premium Plan" on Bluemix. When I restart the application, it cannot connect to SQL Database. The application was operating normally until yesterday. How can I solve this…
Tak
  • 3
  • 1
-2
votes
1 answer

Best way to download .db from url and use it. Android Studio

What is the best way to download .db from url and use it in my app? Thanks for help. I was looking a lot in google but no one method helped me. I'm using android.database.sqlite.SQLiteDatabase; and android.database.sqlite.SQLiteOpenHelper;
Yas
  • 351
  • 2
  • 17
1 2
3