I have an SSIS package which intermittently fails with a handful of errors, the two most informative of which are: DFT_PlaySummary SSIS Error Code DTS_E_O
I'm working on a graphQL backend with TypeORM I found FREETEXT, CONTAiNS, FREETEXTTABLE and CONTAINSTABLE options for fulltext searching in my SQL database. As
I don't want to type all tables' name to drop all of them. Is it possible with one query?
I have a table that has multiple persons linked to multiple groups. I have a procedure that needs to bring everyone from group 75588 but if this person is in gr
I want to find the all the directly and indirectly references to DB objects list. I am using below queries but I found the issue. DECLARE @Search varchar(255)
I'm loading a batch of CSV files into a SQL Server table using Python one row at a time. The files each contain a number of free text fields and erroneous data
Our team recently upgraded our databases from SQL Server 2008 to SQL Server 2012. One breaking change we noticed was in the default order of rows returned by th
I am trying to set up MS SQL Server Express 2019 to listen on TCP/IP and connect to it through IP address instead of shared memory. I am currently connecting th
I have to write a SQL Server query to display the employee last name and his respective manager’s name, as given below. John works for Robert Jane works f
I have a problem with this trigger. I would like it to update the requested information only to the row in question (the one I just updated) and not the entire
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