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
1 answer

How to create a constraint on custom datatype in SQL Server

I want to create a custom datatype in SQL Server with some sort of constraint that checks and validates the type by running through a custom function and returns an error if it fails. For example I have some sort of a Hebrew calendar in SQL Server,…
Shmiel
  • 1,201
  • 10
  • 25
0
votes
0 answers

embed subquery result as csv inside another as json in mssql

I must provide query results in json format, one of the data strings is an array/list. I can provide the query and get a result but the system ingesting it requires it in a slightly different format, can anyone help with my query to achieve this. We…
MikeH
  • 1
  • 1
0
votes
1 answer

Best way to get Azure and local SQL Server development databases to sync on request

I'm looking for a one click system that doesn't require one to delete the Azure database, publish from the local server, and re-create the user info onto the deployment. What currently works: Drop existing Azure database. MSDeploy the database to…
MostHost LA
  • 11
  • 2
0
votes
1 answer

CREATE OR ALTER TABLE is failing with "Incorrect syntax near the keyword 'TABLE'"

I am trying to make few tables in the database. & the tool I`m using is Azure Data Studio. Command that I`m using it:- CREATE OR ALTER TABLE TABLE_NAME ( Date datetime, Sequence nvarchar(8), Code nvarchar(3), ) …
Lakshay Rohilla
  • 1,654
  • 6
  • 9
  • 30
0
votes
1 answer

Kerberos ticket "Expired"; Finding old, not new ticket

I'm trying to get Kerberos connecting to a MS SQL database on my Mac (Big Sur). I've been following instructions here. My Kerberos authenticated connections used to work. They stopped working when I tried them recently. This might be due to…
Jed
  • 1,823
  • 4
  • 20
  • 52
0
votes
1 answer

Searching a keyword in multiple tables and returning which tables contain it

A pretty common query to use is SELECT distinct ex1.Column1 FROM ExampleTable1 as ex1 WHERE ex1.Column1 like '%KW1%' Now this will return all the distinct values from that table, if it's there, but that keyword could be in a number of other tables,…
jon
  • 349
  • 3
  • 4
  • 20
0
votes
0 answers

Is there a way to update a Database Project(or dacpac) from a live SQL Server Database?

So the scenario here is that I have done a bunch of work (i.e changing table names, rewriting and renaming SPs, synonyms etc) in a database within our live DEV SQL server. Now I want to move all my changes to our version control where this same…
Reemz
  • 51
  • 4
0
votes
1 answer

Getting an "Invalid object name" error in ADS after creating a new table

I'm working on a new Jupyter Notebook, using SQL as the Kernel, to create a new table, populate it with a couple records, etc., then drop the table. I've written the CREATE TABLE DDL, then ran it. However, when I ran it in ADS it gave me an error on…
Rod
  • 4,107
  • 12
  • 57
  • 81
0
votes
1 answer

How to fix Azure Data Studio session keeps disconnecting?

In Azure Data Studio, I have a connection to Synapse Data Warehouse. Recently, I moved to a new Data Warehouse instance but while working in this new instance, I keep getting disconnected issue. Everything is fine if I open Azure Data Studio and…
Ken Masters
  • 239
  • 2
  • 17
0
votes
1 answer

Azure Data Studio set tab as delimiter when exporting a csv

in Azure Data Studio there's a setting called queryEditor.results.saveAsCsv.delimiter that allows the user to choose the default delimiter when exporting query results in a csv file. However, I'm struggling to find a way to set this property to use…
BobbyRoode
  • 1
  • 3
0
votes
0 answers

Moving data from excel to sql server using Python script

I have attempted to move LARGE amounts of data from excel to sql, but have been unsuccessful. One method was entirely to slow and now this method (attahed) is only moving the last row from excel to sql. move excel data from P:drive to SQL #import…
Cody Allen
  • 1
  • 2
0
votes
1 answer

Azure Data Studio Not Showing SQL Pool Tables

I'm trying to access data on a SQL Server with Azure Data Studio. When connecting to the server it shows a SQL Database and a SQL Pool under Databases. I can see and interact with the Tables of the SQL Database but not with the SQL Pool. When I use…
test-pls-ignore
  • 1
  • 3
0
votes
2 answers

Remove non-numerical values from multiple columns SQL

I am a react developer flying solo on a project. I have a sprint item that requests that I remove non numeric values from one of our data columns. I am not really a SQL guy so I am not sure what I am doing and need a little guidance on the syntax…
Matthew Lemke
  • 151
  • 2
  • 12
0
votes
0 answers

Docker on MacOs running SQL Server can't see /var/opt/mssql/backup when trying to restore backup file

I've setup docker on my mac and setup a SqlServer container that is running successfully. I want to restore a backup database file that is currently located in /var/opt/mssql/backup. I follow these steps to restore the file when I connect to my…
mo_maat
  • 2,110
  • 12
  • 44
  • 72
0
votes
1 answer

Issue with Building .sqlproj from Azure Data Studio Project with dotnet

Im following this github repo for setting up ci-cd pipeline for synapse using dacpac : https://github.com/santiagxf/synapse-cicd In the github workflow for CI , AT BUILD DACPAC step , im getting following error : Build…
ASHISH M.G
  • 522
  • 2
  • 7
  • 23
1 2 3
…
16 17