Am I closing my SQL connection correctly, by placing it inside a "using" block? This is how I grab a new connection, execute a query, and return the results:
I'm using python 3.9 to insert a list of multiple news from google rss news to SQL table with parameter using pyobc but always getting programming error below:
I want to take backups of all emails from SQL Server database and need to create it's backup file using C# code in outlook compatible format. So that emails can
I get the following error while trying to create a clustered index The statement has been terminated. Msg 596, Level 21, State 1, Line 0 Cannot continu
I am using PetaPoco v5.1.228.0 and I am trying to fetch a list of people along with the category they belong to, using paging (30 items per page). This is my c
I want to create a sample database using composite partition. I know about Range Partition and List Partition. But, I don't have enough knowledge about Hash Val
I have a data set like this. CREATE TABLE EntityItems ( Id INT NOT NULL, EnitityItemId INT NOT NULL, PRIMARY KEY (Id, EnitityItemId) ); INSERT INTO
In a project using Entity Framework, say I have an entity such as [Table("MyTable")] public partial class MyTable { public string FirstName { get; set; }
I'm trying to use Sequelize and node js to connect to a MS Sql server database and i have the following error when i try to test the post route in Postman: "Con
I'm kind of at my wits end here, and so far have had no feedback from the MySQL Workbench bug reporting site, so I thought I'd throw this question/problem out t
I'm working on a rec process which will pull data out of a SQL Server database into Excel and out of another application to compare the two sources. I've writt
I want to make a persistent shopping cart for a MVC application, in other words if a user add some products to his/her cart when logged in and leaves the applic
I have manually added the column IdCategory to my table Books, and now each time I try to run Update-Database, I get this error: fail: Microsoft.EntityFramewor
As far as I know, uploading images to databases is wrong, but in this specific issue, I have to upload images to SQL Server. I found some results, for example u
I'm getting this error from SQL Server on SSMS 17 while running a giant query: Conversion failed when converting the ****** value '******' to data type ****
Does anybody know what is the limit for the number of values one can have in a list of expressions (to test for a match) for the IN clause?
trying to connect with MSSQL server with windows authentication using reactive(R2DBC) JDBC driver #Data Source Configuration spring: r2dbc: url: r2dbc:mss
I am working on an app that is providing a way for an user to define a SQL query and run it against the database. The only purpose of the query is to create a d
PHP has removed support for php_mssql.dll support for versions starting with 5.3. For that reason I have been using version 5.2 till now. But ionCube which conv
I am working with healthcare data that comes from a table that only has one column for procedure code billed, but multiple lines of transactions for each claim