I have a string column in an SQL-Server table on Azure which contains the following data: How can it be transformed into a comma-separated string containing “Jane, John”? Answer Here how to achieve this via a snippet of some of my older code, you should be able to loop through the table and do this for each row. There may
Tag: azure
Where Azure SQL Database logs for failed Data Manipulation SQL queries?
I can find tools in Azure to monitor and get logs on the performance of the Azure SQL database. However, what tools are available in the Azure portal to see logs of failed SQL data manipulation …
Query works but cant retrieve the data
I am new to Node.js (3 days total experience). I am using Node.js and the tedious package to query a database (azure SQL). I use the example as explained here: https://docs.microsoft.com/en-us/azure/…
What is the use of ROLES in Azure Syanpse if I cannot add any USER to it?
I am creating users, in particular, login_id in Azure synapse using Admin login id and password. As of now, I have to give permission individually to every login using the code below. (brown_batman is …
Failed to execute query. Error: String or binary data would be truncated in table xdbo.user_info’, column ‘uid’
I have problem inserting values in my SQL server database on Azure, I am getting the following error: I don’t understand where I am wrong, I just created the server, and I am trying to experiment but cant fix this. Creating the table works fine, the only thing that doesn’t work is the second command INSERT Answer I suspect that
Azure SQL Server Created Date
This could be the first of many questions I raise around Azure as I am currently on a mission to tidy up our Azure platform that has previously been setup by other teams. Our SQL Servers that have been setup on Azure have had no tags setup and I want to setup some new tags now on all our existing
How to write a JavaScript stored procedure in Azure Cosmo DB to return data from SQL API
I’m trying to create a Cosmo DB stored procedure to return the results of a relatively simple SQL statement. If it were purely SQL I would be fine but since I know nothing about JavaScript I’m struggling mightily. Any help would be very much appreciated. Here is the SQL query: Answer You can try something like this: By the way,
How to to create a new identifier in SQL for related addresses that have multiple relationships?
I have a data set like below that includes address and customer_id. In this example multiple customers can ship to the same address and a customer can ship to multiple addresses. I would like to use the relationships between these to create a new ID that joins all of the related addresses and customer_id’s with a new identifier. Original Table
Insufficient user permission performing an operation on Sql Server Azure
I am trying to re-run migration on a newly created DB in azure. DB, User, and all privileges were created from scratch. I basically granted all operation permission to the user including DB admin …
Azure SQL Does not allow login for Created Clients
I created several users for Azure SQL using the free acccount in a database in Azure Data Studio following the recommended procedure: add client ip addresses to firewall create login on the master database create users add appropriate roles that at least encompass db_accessadmin Despite this, my attempts to login with Azure Data Studio and SSMS continue to fail unless