Stack Overflow
Stack Overflow

Questions tagged [azure-data-studio]

Use this tag for issues related to Azure Data Studio and try tagging the platform as well. Ask the question on superuser.com if you are facing issues with installation

Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. This is similar to Sql Server Management Studio, but works on all platforms.

Github: https://github.com/Microsoft/azuredatastudio

253 questions
-1
votes
1 answer

MSSQL DB Multi-Table Export to Excel Issue

I need to export a subset of db data tables into a single file. I tried using SSMS to export to an excel workbook. Each table would have its own worksheet. Sounds ideal !! However, many of our table names are > 31 characters in length, thus table…
Walter Kelt
  • 2,199
  • 1
  • 18
  • 22
-1
votes
1 answer

How/what to import to dbdiagram.io?

Hey I'm pretty new to databases and I want to create a diagram of the db I'm using with dbdiagram.io so that I can't understand the relationships better. What sort of script/file am I supposed to use to import the schema from sql server? I'm…
KTQuestions
  • 1
  • 1
-1
votes
1 answer

Using Azure SQL Migration extension on Azure Data Studio

I have connected my azure account in Data Studio and I am using Azure SQL migration extension (v0.1.12) to migrate on-prem SQL to Azure Managed Instance. However my subscription details are not getting fetched. Screen Shot Attached Here When I…
justgops
  • 1
  • 1
-1
votes
1 answer

Join rows with same UnitOfMeasureId from two different tables

I know this is pretty basic, but I am having trouble figuring out this syntax and there is not a lot of content that I could find for these type of sql queries. I have a UnitOfMeasure Table in my db, then I have UnitOfMeasureSize. UOM Size has sizes…
Matthew Lemke
  • 151
  • 2
  • 12
-1
votes
3 answers

How do I work with temporary table in postgresql with Azure Data Studio?

I'm using a Postgresql database in Azure, but when I use the temporary table, an error occurs stating that it's not allowed. The example code is: select * into temptable from act_hi_taskinst And error is: SELECT ... INTO is not allowed here I…
Henrique Mauri
  • 718
  • 6
  • 20
-1
votes
2 answers

Add new column to all tables in database

I'm trying to figure out if there's a quick way or single query to add a new column to all tables in database. Right now I'm doing this for each table ALTER TABLE [dbo].[%TABLE_NAME%] ADD %COLUMN_NAME% DATATYPE NOT NULL DEFAULT %VALUE%; Is there a…
Anthony R
  • 89
  • 1
  • 10
-1
votes
2 answers

Foreign key 'Bestellung' references invalid column 'Bestellung' in referencing table 'Kunde'

My problem arises when I want to link two existing tables. I am very new to the field and have only been dealing with databases for a few days. It would be great if someone could help me and tell me what I did wrong. I use "microsoft /…
Kevin Boldemann
  • 1
  • 1
-1
votes
2 answers

Unable to execute the SQL queries in Azure Data Studio

I am following the instruction in Microsoft Learn Page https://learn.microsoft.com/en-us/learn/modules/understand-the-sql-dw-connector-with-azure-databricks/5-create-tables-perform-queries As I copy and execute the SQL queries in Azure Data Studio,…
David Chan
  • 1
  • 2
-1
votes
1 answer

How to obtain the insider build of Azure Data Studio?

I hear a lot about the insider preview build of Azure Data Studio but could not find any download link on the official Microsoft pages. How do I receive the insider build of the application?
ˈvɔlə
  • 9,204
  • 10
  • 63
  • 89
-2
votes
0 answers

:( Application Error If you are the application administrator // browser

image1 image2 image3 Connected to azure data studio and loaded tables successfully Publish is completed, but when you run the site, it appears in the browser :( Application Error If you are the application administrator, you can access the…
amira
  • 1
  • 1
-2
votes
1 answer

.NET6 not recognizing database from Azure data studio

I am trying to connect to a database for my application in .NET6. My connection string is as follows "ConnectionStrings": { "Default": "Server=localhost;Database=Tim;User Id=SA;Password=*****;TrustServerCertificate=true" } it is…
Tallion 22
  • 141
  • 1
  • 11
-2
votes
1 answer

Can't connect to SQL SERVER running on docker

I've installed a sqlserver docker container and it seems that the instalation its fine, as shown bellow: I've setup the server using this command: docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<@MystrongPassword1" -p 1433:1433 --name sql1…
Edson Júnior
  • 7
  • 3
-5
votes
3 answers

Comparing values in one column to get a calculated value if values are different

I am trying to print a column with calculated values from two tables in SQL. I need to compare both the order_items and orders tablea. I have the below two tables: Order_Items: Orders: Expected outcome. If there are different brands for an…
Amritpal Singh
  • 1
1 2 3
…
16
17