Can anyone please advise: I have an existing nodejs server running on azure, running node 10.14 on Linux. The project code is on github and when I push changes they are automatically pushed to azure. …
Tag: azure
Azure SQL Database Manipulation
Is it possible to create a table in an Azure sql database using Python? I am pulling a list of things from an API and then want to push them to a table in my Azure sql db but can not find a tutorial or guide on how to do so. Googling for it led me to tutorials on how
How to type Degree symbol (°) in Azure SQL data warehouse
I have data source like this: 1°18’19.74″N But when I insert it to Azure data warehouse it look like this: 1�18’19.74″N
Convert simple JSON to SQL SELECT Statement
I have the following JSON: I’m trying to convert to SQL as follows: All i get is an empty resultset (0 rows when it should be 2 rows), what am i doing wrong? Answer Your JSON has square brackets round the whole thing, meaning it is an array (it only has one element) so your OPENJSON starting point will have
Azure LogicApp cannot get rowid from SQL Server
I have an Azure logicapp that connects to a SQL Server database in Azure. The table has a uniqueidentifier column as the primary key. In the logic app the delete or update requires the rowid in order to perform update, the primary key does not work here and throws an error when running, stating that the table does not have
Is it possible to create Azure SQL Database master master replication
I am sorry because I’m new to use Azure service. I want two SQL databases (one in Southeast Asia and one in Central US) for high availability or replication master-master. Now I just found two ways to sync both databases. Azure Geo-Replication but the problem is this method use master-slave replication. Azure Sync to other databases but the sync frequency
Azure mobile EasyTables connection string
I am fairly beginner in here, so any help would be much appreciated 🙂 So, I created a SQL Database and I want to connect EasyTables to it. Apparently the automatic option has been removed and I have …
How can i query to get to this result?
id string id2 1 a 1 2 b 1 3 a 2 4 c 2 5 d 3 Ok, so i can get SELECT * FROM table WHERE string NOT IN (‘a’,’c’): 2 …
Rename Column in Azure Data Warehouse
I know I can accomplish my objective with this process: Create new column Update new from old Drop old I am looking for a way to do this with one command. I know that remane object works at the table level. For example, I can do this: But these all fail with various error messages: Plus, according to this, sp_rename
Migrate from Azure SQL back to Access
I have a SQL database in Azure. Is there any way of downloading the SQL database in .mdb format?