comprasconencanto1

I'm trying to execute a SSIS package on a SQL Server 2008R2. The script retrieve data on a remo… Read more Error During Loading Of Ssis Package

How can I structure a mySQL query to delete a row based on the max value. I tried WHERE jobPosito… Read more Deleting A Row Based On The Max Value

what is the best solution to create file path in Java for this two OS. Application will be used for… Read more Java File Path Windows/linux

I have SQL issue. Lets suppose we have record: In above record we need to select record with Cance… Read more How To Skip With Other Further Records When Reached Condition?

SqlCE has a parameter set on the Connect String called Flush Interval. It is defined as: The inter… Read more Sqlce Flush Interval - Will The Default Setting Lead To Corruption?

I am using SQL Server 2012 Management Studio. I tried to connect to a remote database. I was able t… Read more Join Remote Database Table With My Local Database Table In Sql Server 2012

I have a procedure that tries to insert samples in a table for each Agent, the # of samples for eac… Read more Select Top N Dynamically With N From The Same Select Statement

So I've seen several mentions of a surrogate key lately, and I'm not really sure what it is… Read more Database "key/id" Design Ideas, Surrogate Key, Primary Key, Etc

I'm having trouble with the following statement, which is returning the error 'Sequence con… Read more Help With Sql/linq Debugging

I am sorry if there is a duplicate but I tried all ways still I can't do the insertion. I have … Read more Mysql&msaccess: Insert Into Table Which Have An Incremented Field

Is there a way in NHibernate / QueryOver API to pass a parameter already in the mapping (so it uses… Read more Nhibernate / Queryover: How To Left Join With Parameter

I want to create a temp table in sql server by using Entity Framework. Is there any way I can do th… Read more Create Temp Table With Entity Framework

I'm trying to create a data import mechanism for a database that requires high availability to … Read more Bulk Inserts Of Heavily Indexed Child Items (sql Server 2008)

I am new to sql. I have added 2 new tables in database. The primary key of first is a foreign key i… Read more Different Ways To Generate The Latest Int Type Primary Foreign Key In Code

My main query was solved at the following post TSQL - Get the difference between each row value I h… Read more The Difference Between Each Row Value - Sum Error

Can someone tell me what I am missing? I am using this connection string to connect to my database … Read more I Cannot Connect To Sql Server Express Using Vb.net

Question is a follow up to this. The SQL in question was UPDATE stats SET visits = (visits+1) And … Read more When It Comes To Updating All Rows In A Table, Does The Method Of Locking Matter For Performance?

I am using phpmyadmin 4.8.4 and have tried to export one of my tables as backup. I noticed that sq… Read more Why Has The Latest Phpmyadmin Dropped Sql As Export Format?

am using entity framework generally successfully, but one query is running remarkably slowly. The … Read more Sql Query Using Entity Framework Runs Slower, Uses Bad Query Plan

I am trying to find a way of converting HEX to a float in SQL Server. An example value is 0x42c8000… Read more Converting Hex To Float Sql

I am having difficulty inserting data with its related entities. public class Status : Entity, IAgg… Read more Entity Framework Insert Conflicts With Another Foreign Key

I'm doing collection of two columns(col & val). Into second select col is parameter of othe… Read more Looking Null Values For Different Oracle Type

Hi I use long time MS SQL and SQL Server Management Studio no I start with oracle and try some SQL … Read more Syntax Highlighting In Oracle Browser Something Like Sql Server Management Studio

I'm having a bit of a problem with using my sequence within a SELECT statement. SELECT c.… Read more Sequence Within Sql Select

The upsert works using on conflict but the datatype of id is serial meaning I want to have it auto-… Read more Upsert/on Conflict With Serial Primary Key

I want to connect from a COBOL/VMS system to an SQL Server 2005 instance. Could someone point me to… Read more Getting A Driver For Vms To Connect To Sql Server 2005

In my Django admin I have a TabularInLine class. In the picture, each element of this class is numb… Read more How To Enumerate New Column?

I am trying to declare a custom type of 'XMLType' for use with MSSQL. But I keep getting &#… Read more Sqlalchemy Declaring Custom Userdefinedtype For Xml In Mssql