Stack Exchange

Question I am trying to import a bacpac file to my SQL Server Express 2016. An exception is thrown during the import with Returns: Incorrect syntax near ‘ADMINISTER’. I am running the import as the sa user. Later when I try to run the SQL … [Read More]

Question I’m simulating the situation where I take a backup from instance A and restore it on instance B. I followed the doc to Backup to Disk with Encryption. Since I’m using only my desktop to simulate the whole process, after taking the backup of … [Read More]

Question This has probably been asked before, but I couldn’t find the answer. I have a complex datamodel in sql-server-20XX (more likely to be something old) in which cascade delete has been turned off (by design). A large chunk of our database has been sold … [Read More]

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]