Category : sql

I’m currently trying to find a way, library or anything else that allows my program to get notified when the contents of my table/database changes. For example, this is what I’d like to do: Program connects to the database Program interacts (add/edit/delete rows) with the database Database detects interaction and sends notification Program receives notification ..

Read more

I’m migrating a SQL Server 2008 database to SQL Server 2019, I have used Microsoft Data Migration Assistant, to look for search any breaking changes, issues or syntax errors. I getting errors for some of my procedures: Object [dbo].[PROCEDURE1] has syntax errors. Must declare the variable or parameter "@SINI". Error number 70590. For more details, ..

Read more

I need to make a Desktop Application that will be using .NET on the frontend and SQL Server Express edition as the backend. I need to make sure that this application works even if the internet goes down. How should I make this application working in offline mode? Please keep in mind that this application ..

Read more

I try to add an SLQ representation of c++ object inside generate code. Each c++ class have a builder and is in charge of save/restore object from SQL database. I have a call like this SELECT With_ext_key.id,With_ext_key.name3, (k1_table.id,k1_table.name1,k1_table.name2,k1_table.re) as k1, (k2_table.id,k2_table.name1,k2_table.name2,k2_table.re) as k2 FROM With_ext_key INNER JOIN With_key AS k1_table ON k1_table.id = With_ext_key.k1 INNER ..

Read more