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
0
votes
0 answers

SQL Server Docker unable to restore databse

I am trying to restore database to Docker SQL Server. The backup was created on windows machine. I was trying with Azure Data Studio and I am getting this error: Restore Database: Microsoft.Data.SqlClient.SqlError: BACKUP LOG cannot be performed…
Mikart Aerang
  • 47
  • 9
0
votes
2 answers

How do you use a loop in SQL to compare a record to a previous record?

I am looking at a data set of Emergency Room visits. I only want to keep visits per ID that are 30 days apart. So as an example say I have this below. If I start with ID=1: In Row 1 I can see that the lag between row 1 and 2 is 15 days so I will…
Lorena
  • 1
  • 2
0
votes
1 answer

Declaring PROCEDURE with dynamic variable based on user input

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_SCHEMA = N'dbo' AND SPECIFIC_NAME = N'Reports' AND ROUTINE_TYPE = N'PROCEDURE') DROP PROCEDURE dbo.Reports GO CREATE PROCEDURE dbo.Reports…
sai
  • 3
  • 3
0
votes
1 answer

Azure Data Studio data script for indexes

I can't access the option "Scrip as Create" for indexes using Azure Data Studio. I just have the refresh option I think that should be like that, no? I've searched on Internet some solution, but I didn't found anything. Someone could help me?
Raul Britto
  • 47
  • 1
  • 5
0
votes
1 answer

when using insert into to load data into a column on sql, how do you exclude the null values?

i'm using azure data studio on a mac i want to load data from another table into a new table i have created, the original tables columns contain some null values that my new table is not supposed to have. how do i do insert into and exclude…
codingrainha
  • 119
  • 1
  • 11
0
votes
1 answer

Managing Database with SQL Server and Azure Data Studio

I'm working with a group on an ASP.NET Core MVC project. We are developing a web application which needs to connect to a database. But we are unsure how we can connect to the database. One member is using Windows - SQL Server and the other use MAC -…
shahad alshuhail
  • 61
  • 2
  • 9
0
votes
1 answer

How to use inner join in sql server to join two tables and overwrite that in first table

INNER JOIN Sales_Category c1 ON c1.MPCID = c1.Category_Id WHERE Date_of_Purchase > DATEADD(d, -90, getdate()) ORDER BY c1.MPCID Table1-OrderDetails contains fields=Bill_To_Id,MPC,Order_value,Category_Id Table2-Sales_Category contains fields =…
kavi
  • 35
  • 4
0
votes
0 answers

Azure Data Studio Cannot Connect to SQL Server Browser. Ensure SQL Browser has been started

Context: On my Windows 10 workstation I've recently installed Ubuntu via VirtualBox. Within Ubuntu, I've installed Azure Data Studio and I am trying to connect ADS to the SQL Server instance I have installed locally (on Windows). I'm getting this…
emalcolmb
  • 1,585
  • 4
  • 18
  • 43
0
votes
1 answer

Msg 5123, Level 16, State 1, Line 8 The CREATE FILE statement encountered operating system error 2 (The system cannot find the specified file.)

I'm new using the tool of azure data studio, and when trying to create a database I skip the following error. Msg 5123, Level 16, State 1, Line 8 The CREATE FILE statement encountered operating system error 2 (The system cannot find the specified…
v4r0_30
  • 1
  • 1
0
votes
2 answers

How can I convert an escaped string to a bytea in postgresql (\ is not a binary digit) with Azure Data Studio

This is probably a duplicate but I've been unable after quite some time to actually find out how to do this. What I'm trying to do is simply roundtrip a binary value. I select it, then paste it into another SQL query. I.e. I have a table with…
Orion Edwards
  • 121,657
  • 64
  • 239
  • 328
0
votes
1 answer

Login problems connecting with SQL Server in nodejs

I'm working in osx with SQL Server using a docker image to be able to use it, running: docker run -d --name sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=myStrongPass' -e 'MSSQL_PID=Developer' -p 1433:1433 microsoft/mssql-server-linux:2017-latest I…
jose920405
  • 7,982
  • 6
  • 45
  • 71
0
votes
0 answers

TRUNCATE TABLE on linked server failing

Context: I need to modify a stored procedure on my local instance of SQL Server 2019 to remotely connect to a linked server to truncate and re-populate a table. I create & verify the linked server with below, runs successfully: EXEC…
emalcolmb
  • 1,585
  • 4
  • 18
  • 43
0
votes
1 answer

Azure Data Studio on Mac issue with Slow Query (qds) Widget on Dashboard

I'm trying to follow the procedures here https://learn.microsoft.com/en-us/sql/azure-data-studio/tutorial-qds-sql-server?view=sql-server-ver15 to add the 5 slowest queries to the database dashboard, everything is going fine, but somehow the system…
borgesgj
  • 35
  • 2
0
votes
1 answer

Accessing Global Temporary Table through pyodbc

I am operating a python 3 notebook in Azure Data Studio (similar to jupyter notebook) and trying to access an existing global temp table (##TEMP1) via pyodbc. Here is my code: import pandas as pd import pyodbc con = pyodbc.connect( …
Mitchell Stearns
  • 17
  • 4
0
votes
1 answer

SQL Help - Summarize Customer Fiscal Year By Quarters

I've been at this question for a bit and I'm currently stuck: This is my current attempt: I only took an image of a small portion of the code since the general idea can be understood within the few case statements. It's turning out to be way…
NoobieDev
  • 1
1 2 3
…
16 17