DBA Stack Exchange

Question I’m really confused by this SQL here, I have this sample where I am using the value from the main query in the subquery and then using XML PATH to add a comma between the dates. The setup is 2 tables one with the … [Read More]

Question Our team is migrating one of our databases to Amazon RDS MS SQL Server. As part of that, we have to rewrite some of our stored procedures. We have a stored procedure that performs a database backup to a network storage. The above stored … [Read More]

Question When I am running: Ctrl+Alt+R will run the web browser in an SSMS tab. However, this now produces the message: I do have MS Edge installed but SSMS is not finding it. What should I do to help SSMS find MS Edge and use … [Read More]

Question I’m trying to find a way to allow an application to create tables and insert data into them on a SQL Server 2019 while protecting from injection attacks in case the app credentials would leak. My experience is limited when it comes to writing … [Read More]

Question I have a SQL query that looks for values in a table on a range of dates. If no record is found, I would like to generate rows with default values. Example of one of the table existing records: DeviceId Time Context Value 1 … [Read More]

Question Can anyone help with this error? SQL: Error: Msg 207, Level 16, State 1, Line 13 Invalid column name ‘PurchaseType’. asked 2022-01-13 by Mark_72 Answer This error is coming from your WHERE clause, not your CASE expression. You say WHERE PurchaseType = ‘Top Performer’, … [Read More]

Question I recently had to uninstall Visual Studio 2012 and DTS, then install VS 2017 and DTS again. Afterwards, The directory containing sqlcmd.exe was not in my PATH variable. I installed the following. Should either of these kits install sqlcmd.exe? If not, which tool will … [Read More]

Question I have an application that uses PostgreSQL as RDBMS. There is a table containing orders placed by customers. The table has an id as primary key, an order_number (integer) and a created_at field (timestamp). id and created_at are assigned automatically when the row is … [Read More]