43 questions
2
votes
2
answers
81
views
Generate a script out of nullable column in SQL table [duplicate]
Following is my query:
SELECT 'INSERT INTO MyTable (
CancellationReason
)
VALUES (
''' + rc.CancelReason + '''
)'
FROM AnotherTable a
I get below result:
Since the column a.CancelReason is ...
0
votes
1
answer
128
views
how to configure to store azurediagnostics to store only Azure sql db login logout related events logs
I'm having an azure paas model sql server and a database in it.
my requirement is to configure the sqlauditing to capture Sql auditing events in AZUREDIAGNOSTICS table for querying it later to find ...
- 67
0
votes
1
answer
69
views
aliases for azure custom policy
what is the supported aliases under provider 'Microsoft.Sql' and resource type 'servers/databases' to create an azure policy to audit pitr and ltr
i tried the below
{
"properties": {
&...
- 1
0
votes
2
answers
326
views
Debezium SQL DB connector on AKS - InconsistentGroupProtocolException
I am getting the InconsistentGroupProtocolException infrequently when running Debezium SQL DB connector on an Azure AKS pod.
*org.apache.kafka.common.errors.InconsistentGroupProtocolException: The ...
- 23
0
votes
0
answers
195
views
Login failed for user token-identified principal. Token is expired
I have a singleton webjob hosted within Azure which is scheduled to run continuous mode type. In this web job, I have some database operations which are managed using EntityFramework. I am also using ...
- 1
0
votes
1
answer
502
views
Mock Sql DB connection in Nodejs Unit test cases
In My NodeJS Application, Connecting to Sql-DB using tedious, I want to unit test the microservices related to DB.
During the unit test I don't want connect real database.
But I am getting the error
...
0
votes
1
answer
1k
views
ImportError: No module named flask_mysqldb ("from flask_mysqldb import MySQL")
I'm using python 3.10. I want to use MySQL database, but whenever I am trying to import the module it throws the error. I am using MAC OS. There are certain file for windows to import but I wasn't ...
-2
votes
1
answer
345
views
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....
- 1
-1
votes
1
answer
45
views
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 format
Ownerid
...
-2
votes
1
answer
146
views
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 ...
- 3
1
vote
1
answer
48
views
what is the easiest way to build forms to import to db
I need to convert an excel sheet that is shared between couple of users and they do insert/update on it to a more DB/web-based application. What would be the easiest route to do that?
- 3,181
-2
votes
2
answers
327
views
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.
- 27
0
votes
1
answer
396
views
Is there any Option to execute below SQL query's using PowerShell?
The below mentioned SQL queries we are doing manually using the Query Editor in Azure Portal SQLDB. But, we have to execute these using the PowerShell, and I was went through the couple of articles ...
-2
votes
1
answer
96
views
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
0
votes
1
answer
447
views
Use the same DB transaction in different DAOs
I have a use case in one of my Golang applications to update multiple tables in an API and in case one of the updates fails, I would want all the previous updates to roll back (Something that @...
- 371
0
votes
0
answers
147
views
Increase data insert performance
We have created a code that loops in to CosmosDb records and inserts values to Sql db. But in the process, the data insertion perfomance is very slow. please help with suggestions, here is the code. ...
0
votes
1
answer
130
views
Inserting Data to Sql Db from Cosmos Db
I am looking out for a help, I am trying to move data from Cosmos db to Sql db using .Net. So, in the process, I am facing issue here.
This cnnInsert.Close(), gets closed after every single insertion ...
- 11
0
votes
1
answer
100
views
Power BI SQL Connection
I have a Power BI desktop report which extracts data from the database server through SQL.
Once complete, is it possible for me to disconnect the SQL DB connection but retain the data already ...
- 1
1
vote
1
answer
168
views
Move Azure SQLDB using SQL Data Sync to new resource group
The Googles are failing for my specific concern. Has anyone moved a database (DBaaS) and the associated parent resource which is part of a SQL Data Sync Group to a new resource group within Azure? I'...
1
vote
0
answers
1k
views
Async db call - slower than sync
The program is written in C#. It gets data one by one sequentially from event hub and makes an entry to sql db.
To improve is performance, I made the sql insert async.
In my local machine 8 GB ram ...
- 59
1
vote
2
answers
1k
views
C# cannot remove object from DbContext
Hi everyone I am trying to update my local sqldb without success.
I created a DbContext:
public class DbContextWeather1 : DbContext
{
public DbSet<WeatherRoot> Weathers { get; ...
- 302
0
votes
1
answer
2k
views
Oracle SQL Developer import wizard missing?
I am using this tool to import a csv file to a MS sql database. I've just downloaded the free package for version 18.1.0. I am new to the tool. My research shows that if I right-click on 'Tables' I ...
- 31
1
vote
1
answer
53
views
How to debug an issue in a proprietary SQL database
Our application from a vendor is using SQL Server 2008 R2 as its database on the backend. Although rarely, but sometimes an issue comes up that we think is related to their database (for example a ...
- 24.3k
0
votes
1
answer
126
views
ExecuteOnInstall and RollbackOnUninstall attributes on SqlScript in WiX
I have the following piece of code in my wxs file for DB.
<Binary Id="binCreateTbl" SourceFile="CREATE_TABLE.sql" />
<sql:SqlScript BinaryKey="binCreateTbl" Id="script_CreateTbl" ...
- 265
1
vote
0
answers
367
views
Columns missing when viewing db table in the field explorer
I am connecting a SQL database to a crystal report. There is a specific column from a table that I need to pull data from. When I go to the field explorer, the column does not appear. I checked to ...
- 11
0
votes
1
answer
38
views
Setting web service xml to readable format
I work with K2 BlackPearl BPM tool. Currently at a Client site, and I need to consume web services to create my SmartObjects.
The web service that am calling has XML as its input and output.
So, ...
- 21
1
vote
1
answer
45
views
ASP.NET MVC5 add 2 Sync Times to the Application
I Added the 2 Sync Times to my DB as 2 new columns and inserted values as below:
USE [DB]
ALTER TABLE [dbo].[TableName]
ADD ColumnName2 time, ColumnName3 time
This was for adding the columns.
...
- 11
1
vote
1
answer
244
views
Azure Resource Manager SQL db templates
I am trying to create an ARM templates for Azure SQL DB deployment. I started by exporting template for an existing Azure sql database which was created and configured from portal. However I see quite ...
- 425
-1
votes
1
answer
99
views
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 ...
14
votes
3
answers
41k
views
How to check/view data in SQL DB in Microsoft Azure
I have a web app in azure which let user to input some data. I want to save them in sql db which I created in azure. Is there a way to check/view the entered data . I am referring to something like "...
- 167
-2
votes
1
answer
405
views
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 ...
- 3
2
votes
1
answer
344
views
How to migrate off SQLDB service on IBM Bluemix?
IBM is pulling the SQLDB service on Bluemix. Does anybody know how I can move my stored data, what are my options in terms of service?
- 25
0
votes
1
answer
74
views
update a column in sqldb using node red and bluemix
I am using Node-RED to insert information into the included sqldb.
I am successful at entering the data but I can't seem to update it. I am unsure of the syntax. The table is called ITEMS and there ...
1
vote
1
answer
103
views
Bluemix SQL Database service and triggers
I'm not able to create triggers on the SQL Database Service on Bluemix. I always get the error message "queryExecFailure - Unupported SQL statement or command." Which is clear enough.
Does someone got ...
- 11
1
vote
1
answer
342
views
SQLDB Java Sample code doesn't work
Hi I'm new in Bluemix and I just tried some of sample code of SQLDB in Bluemix.
I tried example from this site.
I follow the step from readme.md file. But after I deployed my application, error ...
- 1,081
1
vote
2
answers
396
views
I need to restore SQL Server 2000 backup to SQL Server 2012 [duplicate]
I have SQL Server 2000 database backups with me. And I need to restore them to SQL Server 2012.
Can you tell me the best approach to do it?
- 750
0
votes
1
answer
2k
views
SQL Database + LOAD + CLOB files = error SQL3229W
I'm having trouble making loads of tables that have CLOBS and BLOBS columns in a 'SQL Database' database in Bluemix.
The error returned is:
SQL3229W The field value in row "617" and column "3" is ...
- 11
2
votes
2
answers
70
views
How can I change the Bluemix documentation?
I found that the Bluemix documentation is wrong in an example of the SQLDB service and I ran into an issue. I was able to fix it myself. How can I change the Bluemix documentation? How do I submit ...
- 17.3k
1
vote
2
answers
95
views
Bluemix Liberty SQLDB
I have created an "enterprise template" Liberty server with an EAR file application requiring a few SQLDB connections. This is working and I am able to cf push this server to the Bluemix environment. ...
- 31
-2
votes
1
answer
460
views
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
...
- 353
0
votes
2
answers
219
views
When using the SQLDB HA Premium Bluemix Service via JDBC, how can I reduce the connection and read timeouts?
The SQLDB Bluemix Service's Premium Plan enables DB2 High Availability. However, the default JDBC URL provided by service credentials uses more forigiving timeouts than I would like to use. Here is ...
- 7,399
0
votes
1
answer
88
views
Get IBM Bluemix SQL Database service credentials before I bind it to application, is it possible?
When I bind SQL Database service to an application I can see credentials from application panel. But in case I've created a service and would like to work with it before I'm binding to any application,...
- 5,291
0
votes
1
answer
97
views
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 ...
- 7,399