I want to store a date in this format March 13, 2014 in SQL but i couldn't find the solution on how to store a date in this format in SQL I tried storing it in this format March 13,…
i have a query to fetch all data and these data are support tickets, each support ticket has many comments, i want to order these data by last comment if exists else order by ticket created date any idea what…
In my ASP.NET web application I want to show to the end user the progress of the stored procedure. The stored procedure computes a batch of calculations depending on how many the user added to the task basket. It works…
I have a working website running on Unix that connects via VPN to a SQL Server database using dblib. The connection has been created in years past like this: $pdo = new PDO('dblib:host=192.168.2.4:1433;dbname=Andover;charset=utf8', 'UserName', 'Password'); $Query= "Select * From tablename";…
I have a table with a boolean column and want know if atleast one record has a TRUE value in that column. This query works as expected with postgresql: SELECT sum(coalesce(CAST(boolean_column AS INT),0)) <> 0 FROM entity WHERE correlation_id =…
I have a table (code_table) with a lot of different types of records and values. One of the type of records contains a json field (but not all). The following returns the records with json fields: select code_data from code_table…
I'm currently trying to use docker-compose to set up two containers, one is using Dockerfile while another is from a public available image: version: '3.4' services: sampleweb: image: ${DOCKER_REGISTRY-}saucedsampleweb build: context: . dockerfile: SaucedSampleWeb/Dockerfile links: - "mssql:database" mssql: image: mcr.microsoft.com/mssql/server:2019-latest…
I'm trying to get a list of one of each of the type of notes of a client ordered by desc. In SQL Server, I wrote the following query SELECT note_id, st_id, note_type, signature_date FROM (SELECT note_id, st_id, note_type, signature_date…
I am trying to get the backup schedule and retention for SQL Servers using Azure Resource Graph Explorer. I am unable to find any such information. The current query that I have is resources | where type == 'microsoft.sql/servers' I…
I am using SQL Server 'JSON PATH' functions to create nested JSON strings programmatically - without actually querying the database, since the strings placeholders (##..##) will undergo further processing elsewhere. This works fine so far with this type of query:…