Hi - can someone please help with an sql question ???
well, don't ask to ask, just hit us with your question ;)
I have 3 tables
Which is duck, pond and species
Ducks are confortable given their temp limit in the species table
I need to count how many ducks are happy with their habitat
I have done all joins etc
Just need help with extraction part
well, send the table definitions
i am trying to count a column containing integers
but i am having trouble
select androud_num, cells_info, count (*) AS Num_Devices from table where vrs = '71.0.0-rcrq.0.1.4' and dt >='2018-05-17'
can someone please help
@drethegreat1 this doesn't really sound like a sqlopsstudio issue but rather you having issues/questions about SQL in general, however it's pretty hard to help if we don't know the tables and if and which error you got
Hi, I am developing a Azure Data Studio extension. In the extension I am generating some SQLs and currently I just open those scripts in a new file. Is it possible to automatically run the SQL and directly show the table data to the user? Currently once the SQLs are open, the user has to click on Run to execute the SQL
One more guy trying to make an extension inside an azure data studio. Is it possible to make an separate UI inside the ADS- and activate it with extension ? I would use a react for the UI. Are there some more matierials and exapmles on how to make it all work ?
@konstantinmds let me know how it goes, that's exciting!
Hi @dzsquared , i reproduced the code structure and it seems that something is not valid. Here is my project structure in the pic above. Error is that in my out folder i don't get the extension.js file. Do you know where the problem might be ?
@konstantinmds I took a look at the example I shared and got stuck in a similar spot as you - am now working to build a react view manually into a webview extension. will share if I get anywhere
@dzsquared Awesome !
Hi, does anyone have any idea on how to change the snippets
I want to change the contents of sqlCreateStoredProc and sqlCreateTable
@joshuadapitan extensions/mssql/snippets/mssql.json is the file you're looking for; but instead you should probably add a custom snippet; in AzureDataStudio press F1 and type "Configure User Snippets"
Hi. When I connected my account to Azure and it lists all the databases in the subscription, is there a way for it to default the authentication type to Azure Active Directory - Universal with MFA Support when I select a database? It's defaulting to SQL Login, and I'd rather use my Microsoft account. Even if I change the auth every time, it is never remembered
Hi. I'm new to Azure Data Studio. I love it, it's great, thanks! However, there seems to be a serious bug with the PostgreSQL extension that results in an incorrect "query is executing" error after a short network disconnect. Looks like it was reported over a year ago and many people ran into it. I left a comment at https://github.com/microsoft/vscode-postgresql/issues/79#issuecomment-642143721 Can one of the maintainers please have a look and try to reproduce, or advise how to generate debug information for this bug?
Morning all, there's a tooltip that appears when you hover over * in a select statement, that shows you the columns in the list. Can someone point me to the code that builds this please?