I have a scenario where I need to trigger Stored procedure in the SQL server from Databricks. With the spark SQL connector,I can able to SELECT but not trigger the stored procedure. I am trying to …
Tag: azure-sql-database
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 l…
First load table in CTE and then query the CTE?
A colleague of mine writes views like this: He says that his professor taught him this because ‘things will be loaded in RAM and it is a lot faster’. Unfortunately the professor is no longer able to explain this. I think the following works at least as good and avoids unnecessary complexity in the…
Extract string between two characters in a string
I have a set of strings that has datetime values and I would like to extract them. I am not sure if this is even possible using T-SQL. Expected Results: Answer For this dataset, string functions should do it: The idea is to count backwards from the end of the string, and capture the 14 characters that preced …
How to type Degree symbol (°) in Azure SQL data warehouse
I have data source like this: 1°18’19.74″N But when I insert it to Azure data warehouse it look like this: 1�18’19.74″N
Assign a value to a column based on multiple conditions
I have accounting data in SQL. These are entries made for a sale so for every sale made there is an offsetting entry for cost of goods sold as well. In the accounting system we use, it auto generates a transaction id in the TxnId column only for the sales lines not for the cost of goods sold lines for
SQL: How to add string text to my CTE output
I’ve a SQL question. I want to add a text value to the front of the JSON result of my view. I am now able to display the results of my view as JSON and then return with the “SELECT * FROM @TABLE” as the result. I need this return query for my ETL process. The output of my CTE
SQL – Column containing current firmware string based on occational messages with several machines
I have a table called SessionEvents. I’m trying to create a column that represents the firmware that is on the machine to later be able to filter messages for only certain software. Currently my SQL query looks like this. (Based on answer by adamlamar in How do I efficiently select the previous non-null…
SQL – Aggregates data with dates interval
i’m facing a problem joining two table with date interval that represent user status change. ID is the same in both table. Table_A ID StatusA FromA ToA 1 Active 01/01/2020 10:…
Using SQL Server Always Encrypted feature in stored procedure
I am using SQL Server Always Encrypted feature of Azure SQL with .NET code. While it works like charm inside Entity Framework where the data can be decrypted, not sure how do I use it in stored procedures? Let’s say I have a column called Department Id and I have encrypted the same using Always Encrypte…